Sorry, this job is no longer available.

(Loading More Opportunities)

SQL BI Support Developer

Main Purpose:

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. 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.


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 in use:
Visio / Erwin modelling tools
Visual Studio
Cognos / Tableau
PBT Group
Cape Town, WC, ZA