Intermediate BI ETL Developer

Cape Town, Western Cape
Permanent
Full-time

1 month ago

BE responsible for the support, enhancement, and optimization of the current BI Data Warehouse by managing service requests from users and the support of internal data management tasks as the next Intermediate BI ETL Developer sought by a dynamic Financial Services Group. You will develop, maintain & improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL. You will also provide a support service to users. The ideal candidate requires a suitable IT tertiary qualification or similar, a minimum of 5 years' commercial Business Intelligence (Microsoft Stacks) development with Advanced proficiency in SQL, T-SQL & SSIS. Your other tech tools should include SSRS, SSAS, MDX and the Ralph Kimball methodology.DUTIES:Offer support to information delivery production environment -

Understand the current production environment and relevant processes.
Support the BI Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published.
Develop, maintain and improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL.
Work closely with the BI Architect and BI Administrator to streamline data flows between internal/external systems and the BIDW.
Testing and reconciliation of warehouse data to source data to ensure data integrity.
Efficient and effective resolution of production issues, and users' requests for information.
Monitor the environment to proactively engage in prevention activities and to maintain an environment that is easy to understand and troubleshoot.
Recurring standby to support and resolve operational issues encountered in the day-to-day operations of the BIWH production environment.

User Support -

Provide a support service to users on data and information to satisfy user needs.
Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements.
Adapt ETL processes to accommodate changes in source systems and new business user requirements.

REQUIREMENTS:Qualifications –

Relevant tertiary qualification in Information Technology or similar.

Experience/Skills -

At least 5 years' commercial Business Intelligence (Microsoft Stacks) development.
Intermediate to Advanced skill level in using MS-SQL/T-SQL and SSIS.
SSRS, SSAS (multi-dimensional and tabular), MDX.
Working understanding of the Ralph Kimball methodology including a good grasp of dimensional modeling and efficient ETL techniques with focus on MS SQL Server.

Other technologies utilised in the BI Division:

ActiveBatch
Visio / Vertabello Modelling tools
Visual Studio
Cognos / Tableau

Advantageous -

Exposure to Self-Service BI using Power-BI.
Experience in the Business Intelligence environment in Financial Services or Retail industry.
Exposure in working within an Agile project environment.
Experience in a SQL Database Administrator or BI Administrator role.
Experience using a meta-data repository to manage ETL processes and data lineage.
Experience using Team Foundation (or a similar product) as version control system.

ATTRIBUTES:

Strong analytical, problem solving and conceptual thinking skills essential.
Ability to take ownership of problems assigned and find innovative solutions.
Attention to detail and commitment to delivery is important.
A team player with a positive attitude.
Must be able to work to and manage deadlines.
Flexible, able to change focus when required.
Excellent communication skills.

Copyright 2016-2024 © Datafin. All Rights Reserved.|Manage Cookie ConsentTo provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.Functional Functional Always activeThe technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network. Preferences PreferencesThe technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user. Statistics StatisticsThe technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you. Marketing MarketingThe technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.

Intelligence Software

Apply Now