• Locatie: Cape Town, South Africa
  • Salaris: ZAR50000 - ZAR60000 per month
  • Technologie: Microsoft BI Jobs
  • Soort baan: Contract
  • Datum van publicatie: 19th Aug, 2021
  • Referentie: 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

Vergelijkbare vacatures

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