We are looking for an experienced Report Engineer to join our Group Technology Team in Milton Keynes (hybrid). You will design, build and own modern BI solutions on Microsoft Fabric and Power BI, develop robust semantic models and advanced DAX, and lead the migration of our legacy SSRS estate to Power BI, reporting to the Analytics & Reporting Development Lead in a Reporting team of six.
Key Responsibilities: Design, build and own enterprise semantic models in Power BI and Fabric using star-schema principles and performant DAX
Use Tabular Editor, DAX Studio and Performance Analyzer to document and optimise models and reports
Develop and maintain Power BI reports, dashboards and paginated reports
Lead the SSRS to Power BI migration, rationalising reports onto governed, reusable semantic models
Build Fabric workloads (Lakehouses, Warehouses, Dataflows Gen2, Pipelines, notebooks) to land, transform and serve data
Apply incremental refresh, calculation groups, field parameters, aggregations and composite models
Validate models and reports before release: source reconciliation, Best Practice Analyzer and pipeline testing
Implement row-level and object-level security
Own BI governance: sensitivity labels, certified models, workspace/tenant settings, Purview lineage and a data dictionary
Administer Power BI Service and Fabric workspaces: refreshes, failure alerting, gateways and endorsement
Monitor and size Fabric capacity, understanding throttling and cost
Write and optimise T-SQL (queries, views, stored procedures) on SQL Server and Fabric SQL endpoints
Experience and skills required: Proven end-to-end Power BI experience: semantic models, DAX, Power Query (M) and report design
Advanced DAX (evaluation/filter context, performance optimisation) with hands-on Tabular Editor and DAX Studio
Strong Fabric knowledge: OneLake, Lakehouse, Warehouse, Dataflows Gen2, Pipelines and Direct Lake
Incremental refresh, calculation groups, field parameters, RLS, refresh alerting, gateways and deployment pipelines
BI governance (sensitivity labels, certified models, tenant settings, Purview lineage, data dictionaries) and Fabric capacity monitoring
Validating models and reports (source reconciliation, Best Practice Analyzer)
Solid T-SQL and SQL Server, including query optimisation
Producing and maintaining SSRS reports, ideally migrating them to Power BI
Good understanding of star schema and data warehousing
Excellent communication, able to influence stakeholders and manage multiple priorities
Builds strong relationships with technical teams, business leaders and external stakeholders
Microsoft certifications: PL-300 and/or DP-600
SSIS package development and maintenance
Fabric notebooks (PySpark / Spark SQL) and Python
Git and Azure DevOps, including CI/CD for Power BI and Fabric items
Power BI paginated reports (Report Builder)
What We Offer Aviva Digicare + workplace / Car leasing and cycle to work scheme
Colleague discount scheme / Perks at work / Gym discounts
Life assurance / Workplace pension scheme
Our Commitment to Inclusion Connells Group is an equal opportunities employer committed to a diverse, inclusive and authentic workplace. We welcome applications from all suitably qualified candidates regardless of sex, race, disability, age, sexual orientation, gender identity, religion or belief, marital status, or pregnancy and maternity.
Report Engineer in Milton Keynes employer: CONNELLS GROUP
Connells Group is an exceptional employer, offering a dynamic work environment in Eastbourne where your leadership can truly shine. With a focus on employee growth and development, we provide competitive salaries, substantial OTE, and generous benefits including a company car, ensuring that our team members feel valued and motivated to excel in their roles. Join us to be part of a supportive culture that prioritises performance and engagement across our 8 branches.