Developer (Senior) - Discovery Life

Discovery Limited; Gauteng; On-site; ZAR 300,000 - 600,000; Full time

Job summary

An established industry player is seeking a dynamic Business Intelligence Developer to join their innovative team. In this role, you will design, implement, and support ETL solutions, ensuring the delivery of high-quality information assets to various stakeholders. You will collaborate with business analysts and architects to create complex BI solutions that drive engagement and enhance data-driven decision-making. This position offers the opportunity to work in a fast-paced environment where your contributions will significantly impact the organization’s success and customer satisfaction. If you are passionate about data and have a strong background in BI technologies, this is the perfect opportunity for you.

Qualifications

• 5+ years experience in BI, with 3+ years in complete BI solutions.
• Strong ETL experience and ability to design complex BI solutions.

Responsibilities

• Construct complex BI solutions based on specifications from BI Analysts.
• Develop and maintain SSIS packages and T-SQL code.
• Collaborate with analysts to deliver solid BI solutions.

Skills

ETL Processes

SSIS

T-SQL

Power BI

SSRS

SQL Query Writing

Data Modelling

Analytical Skills

Problem-Solving Skills

Communication Skills

Education

National Diploma in IT (BTech)

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

Tools

Microsoft BI Stack

DAX

MDX

Python

Spark

H2O

Job description

Select how often (in days) to receive an alert:

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

Responsibilities

• Construct complex BI solutions based on specifications produced by BI Analysts.
• Interact with business and system analysts to resolve problems.
• Collaborate with analysts to understand source structures, evaluate requirements and deliver solid solutions.
• 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 plans to optimise performance.
• Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications.
• Contribute to the development of architectural guidelines and standards.
• Prototype, Research and Develop new techniques and solutions.
• Schedule 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.
• Read and maintain code not written by yourself.
• Follow a formal SDLC as part of solution delivery.
• Optimise ETL processes and 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 queries.
• Proven experience with large datasets in the region of billions of records.
• Experience working with delta datasets and versioned history on target tables.
• Solid experience in understanding ERDs and source-to-target mappings.
• Strong SQL query writing ability across database environments (e.g., Oracle, Netezza, Postgres) with a firm understanding of analytical functions.
• Evaluate technical ETL solutions for inefficiencies 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.