Data Engineer (Gauteng) at Aspen Pharma Group

OBJECTIVE OF ROLE

• The Data Engineer is responsible for designing, building, maintaining, and optimising data pipelines and data platforms to support the Aspen SA Commercial business. The role ensures that data is efficiently collected, cleaned, transformed, governed, and made readily available for analytics and reporting. Success in this role requires strong knowledge of both current and future-state data architecture, enterprise data standards, and Aspen’s core business capabilities. The Data Engineer must apply deep technical expertise to design and develop cost-effective and scalable data architecture solutions aligned to business needs.

KEY RESPONSIBILITIES

• Analyse and map data across systems to support master data updates
• Collaborate with business and technical teams to design and implement solutions to improve reporting efficiency and enhance data-driven decision making
• Drive the AI agenda by utilising approved tools for enhanced business value and operating firmly within governance frameworks
• Analyse structured and unstructured data to improve data quality and availability
• Implement processes and tools to measure and improve data quality
• Process bulk master data updates in line with governance requirements
• Transform, merge, and enrich data for business usability
• Continuously evaluate systems and processes to identify optimisation opportunities
• Contribute to Innovation pipeline by generating improvement ideas
• Ensure data integrity, accuracy, and validity across product planning systems

Requirements
EDUCATIONAL REQUIREMENTS

• Matric (Grade 12)
• Bachelor’s degree in computer science, Data Informatics, Information Technology, or any other related qualification

KNOWLEDGE & EXPERIENCE REQUIREMENTS

• 3-5 years’ experience (in Pharmaceutical/Life Sciences industry would be advantageous)
• Advanced SQL experience
• Strong experience with Microsoft SQL (T-SQL, query optimisation, and data modeling) and building ETL/ELT pipelines using Azure Data Factory and/or SSIS
• Experience supporting BI and reporting solutions using Power BI.
• Experience working with cloud data platforms such as Microsoft Fabric and AWS
• Experience working with and interpreting SAP data

SOFT SKILLS AND COMPETENCY REQUIREMENTS

• Fast learner and self-starter with strong problem-solving and time-management abilities
• Strong organizational skills with the ability to multi-task in a fast-paced, dynamic environment
• Ability to coordinate and collaborate effectively with cross-functional teams
• Strong verbal and written communication skills
• High level of interpersonal and entrepreneurial skills to understand business needs and develop practical solutions
• Excellent analytical abilities with high attention to detail.
• Demonstrates accountability, teamwork, innovation, and adaptability in ambiguous contexts.

COMPUTER SKILLS REQUIRED

• Advanced SQL
• Microsoft SQL Server
• Azure Data Factory / SSIS
• Power BI
• Microsoft Office (Excel, Word, PowerPoint)
• SAP data tools