Role Purpose
To support the delivery of high quality Power BI reporting across the group by building dashboards, reports, semantic models and measures, and by contributing to a consistent and trusted reporting layer.
Department: Web & Data
Salary: £45,000 – £50,000
Location: Euston / Hybrid
Hours: Monday to Friday, 9am – 5pm
Reporting To: Senior Data Engineer
Main Responsibilities
Stakeholder engagement and delivery
- Work with stakeholders across the business to define, scope and deliver new reporting functionality in Power BI by translating business questions into clear reporting requirements, including KPIs, definitions and expected outputs
- Manage reporting requests through a structured delivery lifecycle, including development, testing and release
Power BI semantic model ownership
- Support the maintenance and enhancement of the underlying semantic models in Power BI, including developing and maintaining DAX measures in line with agreed business definitions
- Ensure semantic models are well structured, reusable and high performing, supporting both dashboards and self-service reporting
- Support the Analytics Engineer in maintaining consistent reporting standards across the group
Reporting layer within the data warehouse
- Support the development and maintenance of the reporting layer within the data warehouse, primarily through SQL views and reporting tables
- Work closely with data engineering to ensure warehouse outputs are fit for reporting and aligned to dimensional modelling principles
- Support investigation of data quality issues and ensure reporting outputs reconcile to source systems where required
- Identify opportunities to improve reporting performance by optimising SQL logic and semantic model design
Skills and Experience (Essential)
- Strong experience with Microsoft Power BI, including DAX
- Experience working with Power BI Service including publishing, workspaces and scheduled refresh
- Strong Microsoft T‑SQL skills, including views and stored procedures, Common Table Expressions and window functions
- Basic understanding of data modelling principles including facts, dimensions and star schema
Skills and Experience (Desirable)
- Experience working with Azure Synapse
- Experience using Power Query and M
- Understanding of performance tuning in Power BI datasets and reports
- Experience working with Git and structured release processes
About The Company
Campions is one of the fastest growing sales and lettings agency groups in the UK. It currently includes the Chestertons, Chase Buchanan, Retirement Homesearch and Campions Lettings & Management brands which collectively sell, rent and manage thousands of properties across the country every year.
Benefits
- Employee assistance programme, competitive holiday allowance + public holidays, charity matching and payroll giving, contribution towards eye care tests, annual flu vaccination vouchers, birthday leave, health cash plan plus a range of other additional benefits that are linked to specific job grades.
We are an equal opportunities employer, we welcome applications from everyone who is excited by the opportunity to join us. At Campions, we are committed to creating a diverse and inclusive workplace. We will thoroughly consider all applications without attention to ethnicity, religion, sexual orientation, gender, identity, family or parental status, national origin, veteran status, neurodiversity status, or disability status.
#J-18808-Ljbffr…