We are currently assisting our client in their search for a Senior BI ETL Developer to join their team.
The successful candidate will be responsible for creating ETL processes for transforming data residing in various source systems into actionable information using ETL tools and coding primarily in Transact-SQL. Interpreting user requirements and building data pipelines to populate data structures that are easily accessible and provide accurate information which supports consistent and informed operational, tactical and strategic business decisions. To be successful in this role you will need to have experience working with the Microsoft BI Stack and be well versed in the Ralph Kimball methodology.
Qualification Required:
- Grade 12
- Relevant tertiary qualification in Information Technology or similar
Experience Required:
- 5+ years’ commercial Business Intelligence (Microsoft Stacks) development
- Essential technology experience: SQL, SSIS.
- SSRS, SSAS (multi-dimensional and tabular), MDX, PowerBI (advantageous)
- Working Understanding of Ralph Kimball methodology
- Experience in Business Intelligence environment in Financial Services or Retail industry – desirable
Key Responsibilities:
- Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements
- Adjusting existing ETL processes, or designing and building new ETL processes to accommodate new requirements
- Testing and reconciliation of warehouse data to source data to ensure data integrity
- Adhering to company’s internal BI SDLC and development methodologies
- Provide a high-level of customer service
Key Competencies:
- Strong analytical, problem solving and conceptual thinking skills essential
- Attention to detail and commitment to delivery is important
- Must be a team player with a positive attitude
- Must be able to work to and manage deadlines
- Flexible, able to change focus when required
- Presentable with excellent communication skills
Other technologies in use:
- Active Batch
- Visio / Erwin modelling tools
- Visual Studio
- Cognos / Tableau
12 months contract
Location: Cape Town preferable, but will consider candidates from other locations
Hybrid working model: 3 days in the office, 2 days WFH)
Desired Skills:
- Systems Analysis
- Complex Problem Solving
- Programming
- C#
- Java
- SQL
- HTML