Job Description

We are looking for a talented Data Engineer to join our team and help develop scalable business intelligence solutions, including robust ETL processes and insightful company reports.
In this role, you will be responsible for designing, implementing, maintaining, and documenting ETL workflows and delivering high-quality, functional business reports. You'll work closely with colleagues across IT and the wider business, so collaboration, attention to detail, and a proactive approach to problem solving are key.
Responsibilities will include:

• Design, develop, and maintain business intelligence solutions, including data models, ETL processes, and reporting dashboards.
• Develop and optimise SQL queries, stored procedures, and scripts to extract, transform, and load data from various sources into the data warehouse.
• Implement data quality and data governance processes to ensure data accuracy and consistency.
• Design and develop data models to support business intelligence initiatives.
• Perform data profiling and analysis to understand the structure, relationships, and quality of data.

Our company values matter, and guide all that we do each day. The successful candidate will be expected to operate in line with them as we strive to be the provider of choice for specialist logistics solutions to the global scientific community, based on the highest levels of care, expertise and precision; enabling our customers to retain absolute focus on research and development.
In addition, you will demonstrate these key competencies:

• Proven work experience as a Business Intelligence Developer.
• Strong proficiency and experience in T-SQL (SQL Server) , SSIS, SSRS and SSAS packages.
• Power BI
• Knowledge and experience of data warehousing concepts, methodologies and ETL Development.
• Automation of maintenance tasks.
• Familiarity with ETL (Extract, Transform, Load) processes and tools.
• Familiarity with Agile methodologies and project management concepts.

In return we offer:

• Up to ZAR 725,000 per annum, depending on experience
• Discretionary annual bonus scheme
• Pension
• Life Insurance
• Medical Aid Benefit
• 20 days holiday
• Birthday Leave
• Wellness Programme

Please note this is a full time role, 40 hours per week Monday to Friday 08:30-17:30 and will be based at our Johannesburg office (Kempton Park 1619).
This is a South Africa based role and the right to live and work in South Africa will need to be established during the recruitment process.
Please note that as part of the recruitment process, if offered the role, you will be asked to complete MIE checks.
Biocair provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Please be aware that we are NOT inviting recruitment agencies to submit candidates for this role and as such any approaches will be rejected. Thank you for your understanding. [tweak as necessary].
Since 1986, Biocair has established a global reputation as a leading GDP logistics specialist within the pharmaceutical, biotechnology and life sciences sectors. Biocair has built up a unique, client-centric approach by employing scientists in front-line logistics positions and assembling a team of best-in-class industry experts in quality, cold chain and regulatory compliance. Biocair focuses on providing the most comprehensive time-sensitive and temperature-controlled logistics services available whilst delivering flexible, tailored, cost-effective solutions to all its clients. It is committed to delivering complete end-to-end logistics solutions through its 24/7 operation and global network spanning across Europe, Africa, Asia and the Americas.