• Ort: Cape Town, South Africa
  • Gehalt: ZAR50000 - ZAR60000 per month
  • Technologie: Microsoft BI Jobs
  • Vertragsart: Contract
  • Veröffentlicht am: 19th Aug, 2021
  • Reference: 19082021

Job Title: BI Developer

Job Type: 12 month contract

Location: 100% remote in SA

Are you interested in working in the Financial industry? For one of the most highly recognised companies in SA? My client is seeking a skilled BI Developer to join their dynamic team!

Key Responsibilities:

  • 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

Key Competencies:

  • 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

  • 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

  • Excellent communication skills

Qualifications and Experience:

  • Relevant tertiary qualification in Information Technology or similar

  • At least 5 years' commercial Business Intelligence (Microsoft Stacks) development

  • Intermediate to Advanced skill level in using MS-SQL/T-SQL and SSIS

  • Exposure to Self-Service BI using Power-BI will be an advantage

  • SSRS, SSAS (multi-dimensional and tabular), MDX

  • Working Understanding of Ralph Kimball methodology including good grasp of dimensional modeling and efficient ETL techniques with focus on MS SQL Server

  • Experience in Business Intelligence environment in Financial Services or Retail industry - desirable

  • Exposure in working within an agile project environment will be an added advantage

  • Experience in a SQL Database Administrator or BI Administrator role will be an advantage

  • Experience using a meta-data repository to manage ETL processes and data lineage will be an advantage

  • Experience using Team Foundation (or a similar product) as version control system will be an advantage

Other technologies that the client uses:

  • ActiveBatch

  • Visio / Erwin modelling tools

  • Visual Studio

  • Cognos / Tableau

interested? Get in touch!


Ähnliche Jobs

Bi Developer
Cape Town, South Africa

Senior BI Developer/Data Engineer
Cape Town, South Africa

Senior Data Engineer - Consulting
Cape Town, South Africa

Senior Qlikview Consultant
Cape Town, South Africa

Senior BI Developer - 12 month Contract
Cape Town, South Africa