BI Developer (Senior) - Discovery Life

Discovery Limited; Johannesburg; On-site; ZAR 600,000 - 700,000; Full time

Job summary

A leading financial services company in Johannesburg is seeking a Senior Microsoft BI Developer responsible for designing and implementing ETL solutions. The ideal candidate will have significant experience in the Microsoft BI stack, including SSIS, T-SQL, Power BI, and SSRS. This role requires strong analytical skills and the ability to work with large datasets to drive business insights and support data-driven decision-making.

Qualifications

• Minimum 5 years’ experience in BI with over 3 years’ experience in implementing complete BI solutions within an enterprise data warehouse.
• Microsoft Business Intelligence certifications will be an added advantage.
• Ability to design and implement complete ETL processes using SSIS and T-SQL.

Responsibilities

• Design, implement, and support ETL solutions according to defined frameworks.
• Collaborate with analysts to evaluate requirements and deliver solid solutions.
• Develop and maintain SSIS packages and T-SQL code.

Skills

Analysis and Communication Skills

Data gathering, research and analytical abilities

Strong SQL query writing ability

Strong analytical and problem-solving skills

Education

National Diploma in IT (BTech)

Bachelor of Science (Information Systems, Computer Science, Mathematics)

Tools

SSIS

T-SQL

Power BI

SSRS

SSAS

Job description

Discovery Life

Microsoft BI Developer (Senior)

Business Intelligence

About Discovery

Discovery’s core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in exceptional individuals who understand and support our core purpose, and whose own values align with those of Discovery. Our fast-paced and dynamic environment enables smart, self-driven people to be their best. As global thought leaders, Discovery is passionate about innovating in order to not only achieve financial success, but to ignite positive and meaningful change within our society.

About Discovery Life

Discovery Life is an ever growing fast-paced and dynamic environment that provides innovative risk assurance to individual clients. This environment thrives on customer engagement and customer experience as well as mutually beneficial relationships with our brokers and other stakeholders. It is important for our employees to provide a world class service to our internal and external clients, thereby ensuring long and sustainable relationships.

About Discovery Life - Business Intelligence

The Discovery Life – Business Intelligence is part of the Discovery Life Company. We are responsible for building all information assets and delivering information to the business through various reporting channels from an executive level down to the call centre agent. The information assets that we are building is not only limited to report delivery, but also integrated information assets to support the data scientists, risk analysts and the data analytics teams.

Key Purpose

The Business Intelligence (BI) developer is responsible for designing, implementing, and supporting ETL solutions according to defined frameworks. The right individual will in addition possess the skills and capabilities to design and implement new frameworks required by the team to keep with evolving changes in sources and technologies. Construction of complex BI Solutions based on requirements of business area owners and/or specifications produced by the BI Architects and Systems Analysts.( BI Solutions imply ETL / Analytics / Presentation).Driving Engagement and building relationships with key stakeholders which include Systems Analysts, BI Architects and Business area owners. The BI Developer should have a firm grasp of BI implementation methodologies especially in a dimensional data warehouse environment using the Microsoft BI stack as a basis for required development.

The candidate should possess the following:

• Analysis and Communication Skills
• Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
• Conceptualize and design solutions
• Support and coach other junior systems and business analysts

Areas of responsibility may include but not limited to

The BI Developer must be able to construct complex BI solutions based on specifications produced by BI Analysts. In addition to working off specifications, the incumbent should been quite adapt at conceptualizing and implementing solutions based on technical discussions with team members.

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

Personal Attributes and Skills

• Ability to design and implement complete ETL processes using SSIS and T-SQL.
• Strong ETL experience in loading slowly changing dimensions as well as transactional and snapshot fact tables.
• Strong reporting experience using Microsoft data technology stack such as (, SSRS, Power BI)
• Ability to design and implement semantic models using SSAS
• Ability to write DAX and MDX query
• Proven experience with working with large datasets in the region of billions of records.
• Experience on working with delta datasets and versioned history on target tables.
• Solid experience in understanding ERD’s and source-to-target mappings as well as producing source-to-target mappings of solutions.
• Strong SQL query writing ability (across database environments e.g. Oracle, Netezza, Postgres etc) with a firm understanding of analytical functions.
• Must be able to evaluate technical ETL solutions for inefficiencies (from a database and code perspective) and implement optimization.
• Strong database fundamentals and data modelling knowledge (normalization and de-normalization).
• Good understanding of ODS, data warehouse, data mart, cube, and database technologies.
• Strong analytical and problem solving skills.
• Navigating ambiguity and complexity
• Excellent oral and written communication skills.
• Added advantage of Data mining and BIG data technology including (Python, Spark, H2O)
  
  
  

Education and Experience

• National Diploma in IT (BTech) – Essential
• Bachelor of Science (Information Systems, Computer Science, Mathematics) – Advantageous
• Microsoft Business Intelligence certifications will be an added advantage
• Minimum 5 years’ experience in BI with over 3 years’ experience in implementing complete BI solutions within an enterprise data warehouse.

EMPLOYMENT EQUITY

The Company’s approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.