Data Analyst

SUMMARY:
Data Analyst - Pinelands, Cape Town

POSITION INFO:

Job Title: Data Analyst

Location: Pinelands, Cape Town

Key Duties & Responsibilities of the Role:

Core Technical Delivery:

Data Engineering & Pipeline Management

• Design, build and maintain scalable ETL/ELT pipelines within Microsoft Fabric
• Ingest, cleanse and transform structured and unstructured data sources
• Manage Lakehouse architecture, data flows and Fabric workspaces
• Monitor pipeline performance and implement data quality controls
• Ensure data lineage, cataloguing and governance compliance

Analytics, Modelling & Insights

• Develop statistical and machine learning models to solve business problems
  
• Perform exploratory data analysis and communicate findings to non-technical stakeholders
• Build and maintain Power BI dashboards and semantic models
• Translate business questions into data hypotheses and actionable insights
• Conduct forecasting and trend analysis as required

Quality & Data Governance

• Ensure data processes adhere to organisational data governance and quality standards
  
• Maintain audit-ready documentation of data models, pipelines and outputs
• Participate in building a data quality culture across the business
• Proactively identify and remediate data integrity risks

Collaboration & Stakeholder Engagement

• Work closely with the Innovation Manager and business units to prioritise data needs
• Present findings and dashboards to management and executive teams
• Mentor junior analysts where applicable
• Engage with IT on data infrastructure and security requirements

Technical Competencies:

• Communication of technical concepts to non-technical audiences
  
• Statistical modelling and machine learning (scikit-learn, statsmodels)
• Power BI - DAX, Power Query, Semantic Model design
• Data visualisation best practices
• Notebooks / VS Code / Fabric Notebooks
• Microsoft Fabric (Pipelines, Dataflows, Lakehouses, Notebooks)
• Python (pandas, PySpark, NumPy)
• SQL / T-SQL / KQL
• Azure Data Lake Storage and cloud data infrastructure
• ETL design patterns and orchestration
• Data governance frameworks and metadata management
• Enterprise data platforms: Microsoft Fabric, Azure, Power BI or equivalent
• Data engineering fundamentals (ETL/ELT): data extraction, transformation, and integration
• Data visualisation and storytelling: dashboards, reporting, and insight generation
• Data architecture and cloud platforms

Qualifications:

Required:

• BSc / BCom in Computer Science, Statistics, Data Science, Mathematics or related field

Preferred:

• Honours or postgraduate degree in Data Science or Applied Mathematics
• Experience in pharmaceutical, life sciences or regulated manufacturing (GxP advantage)
• Prior pharmaceutical or regulated manufacturing experience is advantageous

Experience needed to deliver the role seamlessly:

• Demonstrated delivery of end-to-end data projects from raw data to business outputs
• Proficiency in Python for data manipulation, modelling and automation
• Hands-on experience with Microsoft Fabric (Lakehouses, Pipelines, Notebooks, Semantic Models)
• Power BI report and dashboard development including DAX and data modelling
• SQL and relational/non-relational database knowledge
• Data engineering fundamentals (ETL/ELT): data extraction, transformation, and integration
• Data visualisation and storytelling: dashboards, reporting, and insight generation
• Data architecture and cloud platforms

Preferred:

• Exposure to Azure Data Services (Synapse, Data Factory, ADLS)
• Experience with MLOps and model deployment
• Familiarity with GMP/GxP data integrity requirements