BI Analyst Developer

Discovery – Vitality Data Solutions

Junior BI Analyst Developer

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 to not only achieve financial success, but to ignite positive and meaningful change within our society.

Key Purpose

The Junior Business Intelligence (BI) analyst developer is responsible for implementing and supporting MIS and BI solutions. The right individual will possess knowledge of all stages of MIS and BI delivery including requirements analysis, logical design, physical design, implementation, testing and deployment.  

Areas of responsibility may include but not limited to

• Interact with Vitality Data Solutions team and business stakeholders to establish information needs.
• Maintain and comply with data governance, data modelling and data integration standards.
• Support the creation, enhancement and implementation of newer BI/MIS standards and processes.
• Work with the Vitality Data Solutions team to ensure loads are running optimally.
• The position requires you to maintain databases. This includes:
  • Implementing database table and structure designs
  • Creating views, functions, and stored procedures
  • Writing optimized SQL queries
  • Maintaining data quality and overseeing database security
• Moreover, you’ll need to write SQL queries to store, sort, and retrieve a range of data.
• Conduct data analysis and data quality checks on various data sources.
• Improve query and report performance.
• Create functions, scripts, stored procedures and triggers to support application development.
• Perform bug fixes.
• Translate business & technical requirements into efficient sustainable SQL solutions
• Interact with software developers, business analysts, quality management and end users on BI and MIS solutions and the implementation of the various BI artifacts.
• Coordinate and apply various coding efforts
• Provide second tier support as required

Personal Attributes and Skills

• Good oral and written communication skills.
• Must be able to present solutions
• Experience working with BI front-end tools to develop prototype solutions (Power BI, Excel)
• Strong SQL query writing ability (across database environments)
• Knowledge and understanding of logical and physical data modelling using a variety of techniques including Kimball.
• Database fundamentals and data modelling knowledge (normalization and de-normalization).
• Good understanding of ETL solution architectures.
• Good understanding of ODS, data warehouse, data mart, cube, and database technologies.
• Good analytical and problem-solving skills.
• Must be able to navigate ambiguity and complexity around business products and benefits and how they tie into data.
• You should be quick thinker, highly organized and able to troubleshoot any number of issues that can come up during the day-to-day operations.

Education and Experience

• Minimum Bachelor’s degree in either Computer Science or Informatics.
• 1- 2 years' worth of relevant experience
• Business Intelligence certifications will be an added advantage

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.