Analytics Engineer (business Intelligence & Reporting)
Posted
Description
Key Responsibilities
- Design, develop, and maintain Power BI dashboards, reports, scorecards, and visualisations.
- Develop semantic models and trusted reporting datasets that support self-service analytics.
- Build KPI dashboards and reporting solutions for business stakeholders.
- Develop and maintain Power BI Paginated Reports where required.
- Optimise Power BI models, DAX calculations, and report performance.
- Analyse datasets to identify trends, opportunities, risks, and business insights.
- Translate business requirements into scalable reporting and analytical solutions.
- Define, monitor, and maintain business KPIs and performance metrics.
- Perform trend analysis and support data-driven business investigations.
- Develop and maintain Py Spark notebooks within Microsoft Fabric.
- Build reporting-ready datasets through data cleansing, transformation, and validation.
- Develop scalable data models that support reporting and analytics requirements.
- Write and optimise complex SQL queries for reporting and analytics.
- Ensure data quality, governance, and consistency across reporting solutions.
- Document datasets, business rules, and reporting standards.
- Collaborate with business users, product owners, and technical teams to deliver impactful solutions.
- Contribute to analytics best practices and continuous improvement initiatives.
- Degree, Diploma, Certification, or equivalent experience in Data Science, Computer Science, Information Systems, Information Technology, or a related field.
- Minimum 4 years' experience in Analytics Engineering, Business Intelligence, or a related role.
- Proven experience delivering enterprise reporting and analytics solutions.
- Strong experience building Power BI dashboards, semantic models, and reporting solutions.
- Experience developing Py Spark notebooks within Microsoft Fabric or Apache Spark environments.
- Strong SQL development and data modelling experience.
- Experience working with modern Microsoft Data Platform technologies.
- Exposure to Financial Services or Insurance environments advantageous.
- Microsoft Fabric
- Azure Synapse Analytics
- Azure Data Factory
- One Lake
- Lakehouse Architecture
- Delta Lake
- Power BI
- DAX
- Power Query (M)
- Semantic Models
- Tabular Models
- Power BI Report Builder
- Dashboard Development
- Data Visualisation
- SQL
- Py Spark
- Python
- Data Modelling
- ETL / ELT Development
- Data Warehousing Principles
- KPI Development
- Data Analysis
- Trend Analysis
- Data Storytelling
- Business Intelligence Reporting
- Git
- Version Control
- CI/CD (Advantageous)
- Data Ops (Advantageous)
- Experience with Microsoft Fabric analytics solutions.
- Exposure to forecasting and predictive analytics.
- Exposure to machine learning concepts.
- Understanding of Kimball dimensional modelling.
- Experience with Delta Lake architectures.
- Experience within Financial Services or Insurance environments.
Skills
- Analytics
- Azure
- Azure Data Factory
- Azure Synapse
- Business Intelligence
- CI/CD
- Data Engineering
- Data Modeling
- Data Quality
- Data Science
- Data Visualization
- Data Warehousing
- Delta Lake
- Dimensional Modeling
- ELT
- ETL
- Git
- Lakehouse
- Machine Learning
- Microsoft Fabric
- Power Query
- Power BI
- Predictive Analytics
- Python
- Spark
- SQL
- Version Control
Sign in to read and join the discussion.