Business Intelligence Analytics Engineer

Purpose of the position

Working within a team of professionals, the Business Intelligence Analytics Engineer will create and manage BI and analytics solutions within a Data Lakehouse that will be used to visualise information and support analytical needs in the various organisational areas within the Department

Key responsibilities

• Design, develop, and maintain data models in dbt for structured, scalable analytics using Data Vault 2.0 methods.
• Build and optimise data pipelines.
• Work closely with data platform engineers, analysts, and business stakeholders to improve data accessibility and usability
• Optimise queries for performance and efficient creation of data products
• Implement best practices for data quality monitoring and automation

Essential requirements

• 2+ years of Databricks experience
• Demonstrated experience in analytics engineering, data engineering, or BI development
• Understanding of data modelling, governance, and performance optimisation
• Excellent communication and team skills.
• Experience in Azure and an understanding of modern data platforms
• Analytical mind with a problem-solving aptitude.

Desirable requirements

• Data engineering capability
• Experience working in Databricks, including using Python.
• Understanding of Data Lakehouse principals.
• Experience in Data Vault 2.0 modelling methods
• Experience work in Agile teams.
• Microsoft Power BI experience using DAX, Power Query.
• Development of Azure Data Factory pipelines, mapping, and wrangling dataflows

Deliverables

• Modelling data, datasets, and data products
• Contribute to Data Lakehouse content and supporting processes.
• Other governance documentation as required.