UK jobs. Bigger possibilities.

Report Engineer

Hybrid in Milton Keynes·Full-time·Added 5 days ago (last checked 13 Nov)

Connells Group

655 open roles

Our summary

Work mode
Hybrid, Milton Keynes
Contract
Permanent, full-time hours
Closing date
Apply by Wednesday 16 December
Commute
Cycle to work scheme

Skills

Nice to have

Requirements

What we're looking for

Essential:

  • 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

Nice to have

  • 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)
  • Wider Azure data landscape (Azure SQL, Data Factory, Synapse)

Pay & benefits

What you'll get

  • Aviva Digicare + workplace / Car leasing and cycle to work scheme
  • Colleague discount scheme / Perks at work / Gym discounts
  • Life assurance / Workplace pension scheme
  • Collaborative agile environment
  • Ongoing professional development

The role

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.

What you'll do

  • 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

About Connells Group

Industry
Real Estate

In their own words

Additional information

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.

All open roles at Connells Group
WhatsApp
See all 655 jobs