Developer (Senior) - Discovery Life

1 week ago

Sandton, South Africa Discovery Limited Full time
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.

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.

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.

Key Purpose

The Business Intelligence (BI) developer is responsible for designing, implementing, and supporting ETL solutions according to defined frameworks. The right individual will possess the skills to design and implement new frameworks required by the team to keep up with evolving changes in sources and technologies.

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

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

#J-18808-Ljbffr

  • Actuarial Analyst

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Life**Function**:Actuarial Sciences**Date**:4 Oct 2024- Discovery Life Actuarial Analyst - Market Analytics and R&D**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...

  • Legal Advisor

    2 weeks ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Life**Function**:Legal Affairs**Date**:3 Sep 2024- Discovery - Discovery Life Legal Advisor**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...

  • Internship: Legal Advisor

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Central Services**Function**:Legal Affairs**Date**:4 Sep 2024- Discovery Life Legal Advisor Intern- 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...

  • Internship: Insurance Agent

    7 days ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Central Services**Function**:Administration and Office Support**Date**:6 Sep 2024- Discovery Life - Operations- Insurance Agent**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...

  • Life Insurance Agent for Discovery Life

    1 week ago

    Sandton, South Africa Blue Mercury Financial Services Full time

    Blue Mercury is looking for individuals to sell #1 ranked long Term Insurance and Life Insurance product discovery life We have 3 types of positions available: Junior, Senior & Executive sales consultants. So all experience levels are welcome We offer a basic salary and uncapped commission, with no retainers or claw-backs. Commission and basic is payable...

  • Life Insurance Agent for Discovery Life

    4 weeks ago

    Sandton, South Africa Blue Mercury Financial Services Full time

    Blue Mercury is looking for individuals to sell #1 ranked long Term Insurance and Life Insurance product discovery life We have 3 types of positions available: Junior, Senior & Executive sales consultants. So all experience levels are welcome We offer a basic salary and uncapped commission, with no retainers or claw-backs. Commission and basic is payable...

  • Case Management Consultant

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Life**Function**:Case Management**Date**:2 Oct 2024- Discovery - Discovery Life Case Management Consultant**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...

  • Life Risk Specialist

    2 days ago

    Sandton, South Africa Discovery Limited Full time

    Select how often (in days) to receive an alert:Life Risk Specialist - Discovery LifeBusiness Unit: Discovery LifeFunction: Brokers (FAIS Accredited)Date: 26 Mar 2025About DiscoveryDiscovery'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...

  • Junior Data Scientist Actuarial Analyst

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Life**Function**:Actuarial Sciences**Date**:29 Nov 2024- Discovery Life**Junior Data Scientist | Actuarial Analyst** - Advanced Analytics**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...

  • Life Insurance Risk Expert

    1 day ago

    Sandton, South Africa Discovery Limited Full time

    About the RoleAs a Life Insurance Risk Expert at Discovery Limited, you will be responsible for providing expert guidance to our distribution teams, advisors, and clients on life insurance products.The successful candidate will identify and pursue strategic new business and servicing opportunities, building and maintaining strong relationships with...

  • Administrator (Senior)

    4 weeks ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Employee Benefits **Function**:Administration and Office Support **Date**:4 Mar 2025 - Achieve more than**YOU BELIEVE** - Discovery Corporate and Employee Benefits - Administrator (Senior) **About Discovery** - Discovery’s core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest...

  • Team Leader Telesales

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Connect**Function**:Call Center / Contact Center**Date**:2 Oct 2024**About Discovery Connect** - People increasingly want to transact faster, on their terms, in fluid, and dynamic ways. Discovery Connect facilitates this need as a direct sales channel, leveraging the best of technology with the best in people. We are often a...

  • Underwriter (Senior)

    15 hours ago

    Sandton, South Africa Discovery Limited Full time

    Select how often (in days) to receive an alert:Business Unit: Vitality LifeDate: 27 Mar 2025About DiscoveryDiscovery'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...

  • Life Coach Opportunity

    12 hours ago

    Sandton, South Africa Discovery Remote Work Freelance Full time

    About the Job Description StructureThe job description structure consists of Company overview, Salary, Job description, Required skills and qualifications, Benefits, and Others.Company OverviewDiscovery Limited is a leading financial services group in South Africa, listed on the Johannesburg Stock Exchange.Job DescriptionTo effectively coach eligible members...

  • Cloud Architect

    2 days ago

    Sandton, South Africa Discovery Limited Full time

    Key ResponsibilitiesThe successful candidate will lead the architecture and design of complex IT systems, ensuring they align with business goals and technical requirements. This role involves delivering robust, scalable, secure, and high-performance systems that enhance operational efficiency and support business growth. You will also collaborate closely...

  • Development Manager

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Health**Function**:Information Technology**Date**:5 Sep 2024- Discovery Health Systems (DHS) - Development Manager - Digital and Services - 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...

  • Systems Architect

    2 days ago

    Sandton, South Africa Discovery Limited Full time

    Select how often (in days) to receive an alert:Systems Architect - Discovery LifeBusiness Unit: Discovery LifeFunction: Production Support and Release ManagementDate: 26 Mar 2025About DiscoveryDiscovery'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...

  • Administrator (Senior)

    1 week ago

    Sandton, South Africa Discovery Ltd. Full time

    **Business Unit**:Discovery Employee Benefits**Function**:Administration and Office Support**Date**:20-Sep-2021Achieve more than - *** **YOU BELIEVE** - Discovery Employee Benefits Administrator (Senior) - **About Discovery** - Discovery’s core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in...

  • JAVA Developer

    15 hours ago

    Sandton, South Africa Discovery Full time

    Location: Sandton - 1 Discovery Place/GautEmployment type: Full-TimeJob DescriptionReq#: 59380Discovery Health Systems – Healthcare and Digital Solutions (HDS) / Business to Business (B2B)Intermediate Java (Integration) DeveloperAbout DiscoveryDiscovery's core purpose is to make people healthier and to enhance and protect their lives. We seek out and...

  • Android Developer

    15 hours ago

    Sandton, South Africa Discovery Limited Full time

    Business Unit: Discovery Central ServicesDate: 4 Mar 2025Discovery – Group Information Systems - Digital ChannelsAbout DiscoveryDiscovery'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...