Bi Developer

Human Accent; Johannesburg; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading company in the pharmaceutical industry is seeking a BI Developer in Johannesburg. The role involves end-to-end BI development, supporting and optimizing BI solutions, and collaborating with cross-functional teams. Candidates should have a Bachelor's degree in Computer Science and at least 2 years of experience in BI development, particularly with Microsoft SQL Server and Power BI.

Qualifications

• Minimum 2 years experience as a BI Developer focusing on Microsoft SQL Server and Power BI.
• Experience with data modelling and designing scalable data warehouses.
• Strong SQL skills with proficiency in complex queries.

Responsibilities

• Develop and maintain BI solutions using Microsoft SQL Server and Power BI.
• Provide support for existing BI solutions and ensure data accuracy.
• Participate in the full software development life cycle.

Skills

SQL

Business Intelligence

ETL processes

Data visualization

Collaboration

Education

Bachelor's degree in Computer Science

MS BI certification

Tools

Microsoft SQL Server

Power BI

PHP

MySQL

Job description

Our well-established client in the pharmaceutical industry has a vacancy available for a BI Developer based in Parktown.

Main Purpose of Job

The BI Developer is responsible for end-to-end BI development, support, monitoring, analysis, and maintenance within the BI and Data Warehouse environments, as well as general BI functions to assist the BI team in day-to-day operations and ad hoc tasks when required.

Key Performance Areas (Core, essential responsibilities – outputs of the position)

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

Minimum Requirements

EDUCATION

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• MS BI certification advantageous.

EXPERIENCE

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

SKILLS / PHYSICAL COMPETENCIES

• 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 Power BI or similar.
• PHP & MySQL (advantageous).
• Experience with cloud technologies.

BEHAVIOURAL QUALITIES

• Excellent communication and collaboration skills with a proactive and problem-solving mindset.
• Ability to work on multiple projects simultaneously and prioritize tasks effectively.
• Time management.
• Attention to detail.
• Interpersonal skills.
• Collaboration: Refers to formal and informal relationships.

General working conditions

• In office.
• Travel: None.

Please attach CV, qualification, ID, and driver's license.