Analytics Engineer
Role details
Job location
Tech stack
Job description
As the first Analytics Engineer in the Data Centre of Excellence, you will build the scalable analytics foundations that unlock faster and more reliable decision support. You will create reusable metrics, semantic models, curated datasets, and data contracts, enabling federated analysts to self-serve with confidence. You'll partner with the Insight Analyst and the Technology Teams to ensure data is available in Microsoft Fabric, working within architecture guardrails and medallion principles., * Build and maintain semantic models (star schemas, measures, calculation patterns, performance tuning).
- Develop reusable metric/KPI definitions and maintain consistency across reporting and analysis. Curate and publish business-ready datasets aligned to medallion architecture (silver
- gold readiness).
- Establish data contracts, versioning, and change control for key data products and metrics.
- Introduce coding practices (standards, documentation, peer review) and implement data validation/testing.
- Work with the relevant Technology team to ensure required data is available, reliable, and performant in Fabric.
- Enable analysts through templates, exemplars, office hours, and best-practice guidance.
Requirements
Do you have experience in Warehouse experience?, Do you have a Bachelor's degree?, * Proven experience in analytics engineering / BI engineering / semantic modelling roles.
- Advanced SQL with demonstrated semantic model design and optimisation experience.
- Strong grasp of modern data modelling and medallion architecture concepts.
- Experience working in agile delivery, prioritising speed with discipline.
- Strong communication skills: able to align stakeholders and explain trade-offs.
Desirable:
- Microsoft Fabric experience (Lakehouse/Warehouse, pipelines, notebooks, semantic models, deployment patterns).
- Exposure to Python/R/PySpark for prototyping or large-scale transformations.
- Domain experience: commercial, supply chain, manufacturing (healthcare a plus)., * Bachelor's degree in computer science, Mathematics, Statistics, Data Science, or a related quantitative field (or equivalent practical experience).
- Background working with modern data platforms and analytics ecosystems.
- Relevant certifications on data or analytics platforms (e.g., Microsoft Fabric, Azure, SQL/BI platforms, cloud data technologies) are strongly preferred.
- Continuous learning mindset, with evidence of upskilling through certifications, training, or hands-on platform experience.
Working Conditions:
- Role based in Lisbon with hybrid work schedule.