Developer (Senior) - Discovery Life

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