BI Analyst Developer at Discovery Limited

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