• Lieu: Cape Town, South Africa
  • Salaire: ZAR50000 - ZAR60000 per month
  • Technologie: Microsoft BI Jobs
  • Type de contrat: Contract
  • Date de publication: 19th Aug, 2021
  • Référence: 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!


y.asir@nigelfrank.com

Emplois similaire

Senior QlikView Developer
Cape Town, South Africa

Qlik Developer
Cape Town, South Africa

Qlikview Developer
Cape Town, South Africa

Business Intelligence Developer
Cape Town, South Africa

Bi Developer
Cape Town, South Africa