Business Intelligence (BI) Developer

SUMMARY:
A fast-growing Pharmaceutical Company based in Johannesburg, established in 2005, is committed to delivering ethical, clinically supported healthcare solutions with a patient-first philosophy.
The organisation offers a diverse range of over the counter and prescription products across various therapeutic areas; all developed to meet rigorous quality and efficacy standards.

With a strong focus on innovation, data-driven decision-making, and continuous improvement, the company provides an exciting environment for a Business Intelligence (BI) Developer looking to contribute to impactful, health-focused initiatives in a purpose-driven and growth-oriented team.

POSITION INFO:
Responsibilities:

• Develop and maintain business intelligence solutions using Microsoft SQL Server, Power BI,
• and other relevant BI tools.
• Collaborate with cross-functional teams to understand data requirements and implement effective BI solutions.
• Provide day-to-day support for existing BI solutions, troubleshoot issues, and ensure data accuracy and integrity.
• Design and optimise SQL queries, views, and stored procedures to extract, transform, and load data.
• Create and maintain documentation related to BI processes, data models, and reports.
• Participate in the full software development life cycle, including analysis, design, development, testing, and deployment.

• Bachelor's degree in computer science, Information Systems, or a related field.
• Advantageous: MS BI certification.

• Minimum 2 years proven experience as a Business Intelligence Developer with a focus on Microsoft SQL Server and Power BI.
• Experience with data modeling and designing efficient and scalable data warehouses.
• Knowledge of best practices in BI development and data visualisation.
• Knowledge of data warehousing concepts and methodologies.

• Experience with ETL processes and tools.
• Strong SQL skills and proficiency in developing complex queries, views, and stored procedures.
• Familiarity with other BI tools and technologies such as PowerBI, or similar.
• Advantageous: PHP & MySQL.
• Experience with cloud technologies.