Power BI / Analytics Engineer

SUMMARY: We are looking for an experienced Power BI / Analytics Engineer to join our growing Data & AI Practice. This is a hands-on analytics and reporting role for someone strong in Power BI, DAX, and semantic modelling, who enjoys working directly with business stakeholders to turn complex reporting requirements into clear, reliable, well-designed dashboards. You will initially work on TXP’s internal data platform, built on Microsoft Fabric, supporting the next phase of reporting and analytics across finance, sales, recruitment and operational data. Working closely with our Senior Fabric Engineer, who owns the platform architecture and data engineering, you will take governed data and build the semantic models, measures and Power BI reporting that sit on top of it. This is a long-term role within our Data & AI Practice, with opportunities to work across both internal initiatives and client projects. The role is based in Brazil and follows UK business hours. WHAT WILL YOU BE DOING: As part of our Data & AI Practice, you will: Work directly with finance and other business stakeholders to understand reporting requirements and translate them into clear, reliable and useful Power BI dashboards. Build and maintain Power BI semantic models, including relationships, measures and well-structured analytical models. Develop advanced and performant DAX measures to support business and financial reporting. Build reporting over governed data within a medallion architecture, primarily using the gold layer prepared by the Fabric Engineer. Implement and maintain row-level security (RLS) to protect sensitive finance, commission and people data. Work with Direct Lake on Microsoft Fabric where appropriate and optimise semantic models and reports for performance. Capture existing reporting definitions and business logic, including reporting currently held within the existing DataCube, and reproduce them accurately on the new platform. Validate reporting against source data and agreed business definitions to ensure accuracy and consistency. Support user acceptance testing (UAT) with finance and other business stakeholders. Document measures, definitions and reporting logic to ensure dashboards and models remain maintainable. Work closely with the Fabric Engineer, following established architecture and modelling patterns and providing feedback where reporting requirements require changes to the gold-layer model. Build clear, intuitive and visually effective dashboards that business users can easily understand and trust. Contribute to future internal and client-facing analytics and reporting projects across the TXP Data & AI Practice. WHAT WE ARE LOOKING FOR: Strong hands-on experience with Power BI, including building production-level dashboards and reporting solutions. Strong experience with Power BI semantic modelling, not just dashboard visualisation. Excellent knowledge of DAX, including building complex, efficient and…