Report Engineer

Connells Group

Milton Keynes

Hybrid

GBP 60,000 - 90,000

Full time

5 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Car leasing
Cycle to work scheme
Gym discounts
Life assurance
Workplace pension

Job summary

Connells Group in Milton Keynes is seeking an experienced Report Engineer to design, build and own modern BI solutions on Microsoft Fabric and Power BI. You will develop robust semantic models, advanced DAX and migrate legacy SSRS to Power BI within a hybrid work pattern.

You will lead the governance of BI assets, implement incremental refresh, RLS, and deployment pipelines, and collaborate with data engineers and business stakeholders to deliver scalable analytics services.

Qualifications

  • Proven end-to-end Power BI experience with semantic models and DAX.
  • Experience migrating SSRS to Power BI and governing reports.
  • Strong Fabric knowledge including OneLake, Lakehouse, Dataflows Gen2 and Pipelines.

Responsibilities

  • Design, build and own enterprise semantic models in Power BI and Fabric using star-schema principles and performant DAX.
  • Lead the migration of legacy SSRS reports to Power BI with governed semantic models.
  • Develop and maintain Power BI reports, dashboards and paginated reports; optimise performance.

Skills

Power BI
DAX
Fabric
Tabular Editor
DAX Studio
SQL/T-SQL
SSRS migration
Data governance
Security: RLS
CI/CD
Git
AZ DevOps
Report Builder

Tools

Performance Analyzer
Power Query (M)
Paginated reports
Azure DevOps pipelines
PySpark/Spark SQL

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead BI Reporting Engineer: Power BI & Fabric
Lead BI Reporting Engineer: Power BI & Fabric

Connells Group • Milton Keynes

Hybrid
GBP 50,000 - 70,000
Power BI & Fabric Semantic Model Engineer
Power BI & Fabric Semantic Model Engineer

Connells Group • Milton Keynes

Hybrid
GBP 60,000 - 90,000
Car leasing
Cycle to work scheme
Gym discounts
+2
Data Engineer
Data Engineer

Airedale Group • United Kingdom

On-site
GBP 45,000 - 70,000
Private Health Insurance
23 days of annual leave
Retail discounts
Data Analyst
Data Analyst

PYVITAL Ltd • Birmingham

Hybrid
GBP 45,000 - 55,000
Salary 50k
Permanent role
Microsoft Fabric exposure
+2
Lead BI Reporting Architect — Power BI & Fabric
Lead BI Reporting Architect — Power BI & Fabric

Connells Group • Milton Keynes

Hybrid
GBP 50,000 - 70,000
Fabric / Power BI Analytics Consultant
Fabric / Power BI Analytics Consultant

Capgemini • Saltley

On-site
GBP 55,000 - 85,000
Business Intelligence Developer
Business Intelligence Developer

Harnham • Greater London

Hybrid
GBP 41,000 - 50,000
Hybrid working
One day a week in London office
Career development
+1
Senior BI Developer - Power BI
Senior BI Developer - Power BI

Chapman Tate Associates • Wolverhampton

Hybrid
GBP 60,000 - 80,000
Business Intelligence Specialist
Business Intelligence Specialist

MSA Data Analytics Ltd • Birmingham

Hybrid
GBP 45,000 - 60,000
Profit-related pay
Life insurance
Flexible working arrangements
Staff BI Data Engineer | Databricks & Power BI
Staff BI Data Engineer | Databricks & Power BI

Datatech Analytics • England

Hybrid
GBP 60,000 - 74,000