Analytics Engineer (OVA5693)

• We are looking for an experienced Analytics Engineer to design, build and maintain data models and orchestrated data pipelines within a complex enterprise data environment.
• The successful candidate will translate business and data requirements into documented data flows and reusable data models, implement testing and observability, optimise cost and performance, and ensure datasets remain timely, accurate and well documented.
• You will also mentor and guide junior Analytics Engineers while working closely with Data Engineers, Data Architects, Data Modelers and Data Governance teams.

Key Responsibilities

• Design, build and maintain scalable data models, schemas, metadata and data pipelines.
• Translate business requirements into data-product backlogs, data contracts and acceptance criteria.
• Partner with stakeholders to understand data requirements, user interactions and business outcomes.
• Provide Data Management guidance aligned to organisational frameworks, standards and data strategy.
• Collaborate with Data Modelers, Data Engineers, Data Architects and Data Governance teams.
• Apply Data Vault, Relational, Dimensional and Object-Oriented modelling concepts.
• Design and maintain data architecture supporting efficient storage, retrieval and analysis.
• Perform data profiling, testing, validation and reconciliation throughout the data lifecycle.
• Identify and resolve data quality issues and contribute to data standards.
• Build and maintain APIs in collaboration with Data and Software Engineers.
• Build and maintain data pipelines that extract, transform and load data from multiple sources and formats.
• Automate, monitor and optimise pipeline performance.
• Implement data lineage within the metadata environment.
• Ensure validation and reconciliation checks are incorporated into data pipelines.
• Support cloud technology adoption within database and data environments.
• Ensure compliance with data protection, privacy, regulatory and data governance requirements.
• Enable stakeholders to access and use governed data for self-service insights.
• Develop reliable datasets, metrics and APIs and ensure they are documented, secured and monitored.
• Provide technical guidance and mentorship to junior Analytics Engineers.

Technical Expertise

• Data Products & Self-Service Insights
• Data Modelling & Data Architecture
• Data Vault, Relational & Dimensional Modelling
• Data Pipelines / ETL
• Data Quality & Validation
• Data Governance
• Data Visualisation
• Data Contracts & APIs
• Metadata & Data Lineage
• Cloud Data Platforms
• Database Design & Management

Essential Requirements:

• Undergraduate Degree
• General Experience: Experience enables job holder to deal with the majority of situations and to advise others (Over 3 years to 6 years)
• Managerial Experience: Experience of general supervision of more junior colleagues (7 to 12 months)

Behavioural Competencies

We are looking for someone who:

• Collaborates effectively with stakeholders and technical teams.
• Ensures Accountability and consistently delivers on commitments.
• Optimises Work Processes and continuously looks for ways to improve efficiency.
• Demonstrates strong Decision Quality and sound judgement.
• Manages Complexity and can analyse complex data and business requirements.
• Communicates clearly and works effectively across multidisciplinary teams.