Data Engineer

Cipla Africa; Cape Town; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A healthcare company in Cape Town is seeking an experienced Data Engineer to evaluate business needs, design and maintain data pipelines, and ensure security compliance. You will work closely with cross-functional teams to develop data infrastructure and support data-driven applications. Ideal candidates will have expertise in data modelling and performance tuning, and must be adept at troubleshooting and building strong collaborative relationships within the organization.

Qualifications

• Strong understanding of data pipeline development and ETL solutions.
• Experience with database administration and optimization.
• Ability to monitor and troubleshoot data infrastructure.

Responsibilities

• Evaluate business needs for data management.
• Design and develop data infrastructure and pipelines.
• Collaborate with cross-functional teams for project success.
• Automate routine data engineering tasks.
• Document all data engineering processes.

Skills

Data modelling

Database design

Performance tuning

Data acquisition

Collaboration skills

Troubleshooting

Automation

Data analysis

Security compliance

Documentation skills

Job description

Job Purpose

Evaluate business needs and design, develop, and maintain data pipelines and ETL solutions. Other duties include data modelling, database design, and performance tuning while championing the needs of the customer.

Data Engineering

Identify opportunities for data acquisition. Collaborate with cross-functional teams on DevOps, development, and security. Communicate effectively with technical and non-technical audiences. Collaborate with data scientists and architects on several projects. Work with developers to troubleshoot and debug data‑driven applications. Create, manage, contribute, and support projects for the team.

Responsibilities

• Evaluate business needs and provide recommended solutions for data management.
• Design, develop, and maintain the company's data infrastructure. This includes:
  • Designing and implementing data pipelines to move data between different systems.
  • Building and managing data warehouses and data lakes.
  • Developing and deploying data processing and analytics applications.
  • Automating data engineering tasks.
  • Monitoring and troubleshooting data infrastructure.
• Stay up-to-date on the latest data engineering technologies and trends.
• Document and maintain all data engineering processes and procedures.
• Design and build data quality principles and solutions.
• Database administration and management: monitor database health, optimize queries and indexes, manage backups, apply patches, and enforce security fixes.
• Security and compliance: create and manage user accounts, roles, and permissions; implement security standards, encryption, auditing, and compliance policies; respond to security incidents and assist with data governance requirements.
• Troubleshooting and support: diagnose and resolve performance bottlenecks, errors, and connectivity issues; provide support to application and Qlik developers for SQL optimization and schema changes; assist with break‑fix scenarios across development, testing, and production environments.
• Automation and deployment: automate routine tasks using scripts or scheduling tools; participate in database deployments, migrations, and version‑control processes.
• High availability and architecture: maintain replication, failover clusters, and high‑availability configurations; support capacity planning and storage management; contribute to database design discussions.
• Documentation and collaboration: maintain clear documentation for configurations, SOPs, and change logs.
• Data analysis: work with data specialists and analysts to understand business requirements and translate them into technical specifications; extract insights from data and solve business problems.
• Collaboration within the Digital Team: build relationships with stakeholders across the company, communicate effectively with technical and non‑technical audiences, and maintain relationships with vendors and global partners.
• Development: work with developers to build and deploy data‑driven applications; translate business requirements into technical specifications; develop and deploy data‑driven features and functionality.
• Other duties: support and resolve BAU queries via the Support Desk.
• Drug Safety / Pharmacovigilance: Escalate within 1 business day (24 hours) of becoming aware of any adverse events or serious medical incidents to the Drug Safety Unit/Pharmacovigilance for all Cipla products.