Summary of the position<\/p>\n
\tWe are seeking a highly accomplished and visionary Business Intelligence Developer to join our team.
\n\tAs a BI Developer, you will report into the Business Intelligence Manager and be responsible for developing and maintaining BI and Reporting solutions.<\/p>\n
Comptencies<\/p>\n
\tProficient in reporting writing tools such as SSRS, dashboarding tools like Power Bi.
\n\tSolid understanding of relational databases, Microsoft T-SQL.
\n\tSolid understanding of ETL processes.
\n\tUnderstanding of scheduling tools such as control-m.
\n\tFundamental understanding of basic warehouse concepts.
\n\tPerformance tuning of complex SQL queries.<\/p>\n
Outline of main duties and responsibilities<\/p>\n
As a Business Intelligence Developer, you will be expected to:<\/p>\n
\tWork with both Business Analysts and business owners to develop and enhance reports and dashboards.
\n\tMaintain and enhance existing ETL processes.
\n\tBe on regular after-hour stand-by support for the data warehouse loads.
\n\tPerformance tuning of stored procedures and reports.
\n\tEnsure that development standards and processes are followed according to Apex\u2019s best practices.<\/p>\n
Skills and experience<\/p>\n
\tA degree or diploma (3 years) with majors Information Systems or Computer Science will be a strong advantage.
\n\tA good working knowledge of IT systems in a corporate environment.
\n\tAt least 2-3 years of solid SQL Server development experience, with profiency in report writing skills. This includes but not limited to building complex stored procedures, functions, and views.
\n\t3-5 years\u2019 experience in building integration solutions independently.
\n\tStrong attention to accuracy and detail.
\n\tStrong analytical and problem-solving skills, including an ability to work independently from the business analyst team when appropriate.
\n\tA high tolerance for ambiguity as requirements is not always clear at the start of a project and can change as users and analysts start to see the data.
\n\tSelf-starter who can take the initiative to learn new technologies independently and not just wait to be sent on training.
\n\tSolid time management and communication skills essential.
\n\tAbility to multi-task and to work on multiple project streams simultaneously.
\n\tHigh personal integrity.
\n\tThe below skills are not an absolute requirement but would give the candidate a significant advantage over others.
\n\tScheduling tools such Control-m
\n\tCloud based database solutions like Snowflake
\n\tCloud based ETL solutions like DBT
\n\tA background in Investment and Financial Accounting<\/p>\n
go to method of application \u00bb<\/p>\n
Apply via company website ( https:\/\/www.apexgroup.com\/ ) or<\/p>\n
<\/p>\n","protected":false},"author":2,"featured_media":0,"template":"","meta":{"_promoted":"","_job_location":"","_application":"","_company_name":"Apex Group","_company_website":"https:\/\/www.apexgroup.com\/","_company_tagline":"Apex Group Ltd., established in Bermuda in 2003, is a global financial services provider. With 85 offices in 42 countries worldwide and 10,000 employees upon the close of announced acquisitions, Apex delivers an extensive range of services to asset managers, capital markets, private clients and f... read moreamily offices. The Group has continually improved and evolved its capabilities to offer a single-source solution through establishing the broadest range of services in the industry; including fund services, digital onboarding and bank accounts, depositary, custody and super ManCo services, business services including HR and Payroll and a pioneering ESG Ratings and Advisory service for private companies. 20 Reid Street, 3rd Floor, Williams House, Hamilton, P.O. Box 2460 HMJX HM12, BM","_company_twitter":"","_company_video":"","_filled":0,"_featured":0,"_remote_position":0,"_job_salary":"","_job_salary_currency":"","_job_salary_unit":""},"job_listing_region":[15],"job-types":[34],"class_list":["post-15222","job_listing","type-job_listing","status-expired","hentry","job_listing_region-western-cape","job-type-full-time-hybrid"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-listings\/15222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-listings"}],"about":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/types\/job_listing"}],"author":[{"embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/users\/2"}],"wp:attachment":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/media?parent=15222"}],"wp:term":[{"taxonomy":"job_listing_region","embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job_listing_region?post=15222"},{"taxonomy":"job_listing_type","embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-types?post=15222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}