Data Analytics Engineer

Quick Facts

• Role: Data Analytics Engineer

• Focus: End-to-end delivery of advanced Power BI reporting solutions

Description

Own end-to-end delivery of enterprise-grade Power BI reporting solutions, turning business requirements into robust, governed, and supportable analytics products. Collaborate with business, data engineering, and operations to design reports and dashboards, define the semantic layer (measures, dimensional models), and ensure data quality, monitoring, and validation. Use Git-based workflows and CI/CD to version, test, and deploy Power BI assets while working in an Agile/Scrum team.

Responsibilities

• Collaborate with business stakeholders to clarify requirements and translate them into report designs, KPIs, and user stories

• Design and build enterprise-grade Power BI reports and dashboards aligned with UX/design standards and reusable components

• Define the semantic layer by translating business needs into measures, calculations, and dimensional models; propose and validate the underlying data model

• Work with data engineers to translate semantic/model requirements into source data structures, data pipelines, and transformations

• Collaborate with Operations to define SLAs, monitoring, and validation points (data quality checks, reconciliation rules, alerting)

• Develop complex DAX measures, calculation logic, and row-/object-level security

• Optimize dataset and report performance (model design, aggregations, indexing, partitioning, incremental refresh, query tuning)

• Use Git-based workflows (branches, pull requests, code reviews) and CI/CD pipelines to version, test, and deploy Power BI assets

• Contribute to and enforce standards: modeling conventions, naming, folder structures, documentation, and governance

• Actively participate in Scrum processes (refinement, planning, reviews, retrospectives) and support rollout/adoption

Requirements

• Several years of hands-on experience delivering end-to-end Power BI solutions in a complex business environment

• Expert knowledge of Power BI (Power Query, DAX, TMDL format, Field Parameters, Calculation Groups)

• Strong data modeling skills (dimensional/star schemas, semantic modeling) and solid SQL experience

• Proven experience with Git and CI/CD for BI/reporting solutions

• Experience collaborating with data engineers and operations/SRE teams on SLAs, monitoring, and validation

• Strong communication skills; able to challenge, refine, and document business requirements clearly

• Comfortable working in Agile/Scrum teams

Benefits

• P&G-sized projects and access to world-leading IT partners and technologies from Day 1

• Training and certification paths for self-development

• Competitive salary and benefits program (private health care, P&G stock, saving plans, sport cards)

• Regular salary increases and possible promotions based on results and performance

• Opportunity to change role every few years to match your interests and business needs

• Hybrid work model: option to work from home two days a week and be in the office to support teamwork and communication