Microsoft BI Developer

About

Description

The Microsoft BI Developer at Discovery Life is responsible for designing, implementing, and supporting ETL solutions using Microsoft BI stack tools. The role involves data analysis, database maintenance, and SQL query optimization. Candidates must have 3 years of experience, strong analytical skills, and experience with large datasets, versioned history tables, and Microsoft BI certifications.

Responsibilities

• Interact with business and system analysts to resolve problems
• , Collaborate with analysts to understand source structures evaluate requirements and finally deliver a solid solution
• , Conduct data analysis on various source systems as part of the solution development process
• , Develop and maintain SSIS packages, Create required database structures, Develop and maintain T-SQL code - Added advantage, Analyse SQL execution plan to optimise performance, Develop SSAS models, Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications
• , Contribute to the development of architectural guidelines and standards
• , Prototyping Research and Development of new techniques and solutions
• , Team engagement champion, Scheduling business processes via ETL tools, Excel Reporting and scripting – advanced charting conditional formatting
• , Understand and resolve complexities working across multiple database platforms
• Develop PowerBI and SSRS reports
• Must be able to read and maintain code not written by yourself
• , Have experience following a formal SDLC as part of solution delivery
• , Optimise ETL processes as well as SQL queries by analysing query execution plans
• , Maintain code repositories for version control of developed solutions
• , Peer review of code and solutions developed
• , Create and maintain metadata repositories
• , Implement database structures according to specifications and guide on improvements (indexes/partitioning etc
• ) where necessary
• , Perform ETL support on a standby basis to ensure that the ETL batch completes within SLA

Qualifications

• National Diploma in IT (BTech) – Advantageous, Bachelor of Science (Information Systems Computer Science Mathematics) – Advantageous, Microsoft Business Intelligence certifications will be an added advantage

Application instructions:

• To apply click on the apply button