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:

• ActiveBatch
• Visio / Erwin modelling tools
• Visual Studio
• Cognos / Tableau
• Python