Group IT Data Engineer

As our IT Data Engineer, you'll play a key role in shaping how we use data across the entire construction project lifecycle, from early estimation through procurement, site activity, safety, commercial performance, finance, and asset management. You'll build the modern data foundations that enable our teams to make trusted, timely, insight-driven decisions. This role is based from our Preston head office., Design and deliver end-to-end data solutions using Microsoft Fabric (including Lakehouse, Warehousing, Dataflows, and Notebooks) that support both enterprise-wide architecture and project-level needs.

• Develop reliable ELT/ETL pipelines that bring together data from key construction systems such as ERP, finance, procurement, project controls, BIM/CDE platforms, and site health & safety applications.
• Build and maintain high-quality semantic models for Power BI creating reusable measures, KPIs, and hierarchies while ensuring great performance and consistent business definitions.
• Establish strong governance practices in Fabric, including workspace design, lakehouse organisation, medallion architecture, data security, lineage, and sensitivity labelling.
• Implement CI/CD pipelines to automate deployment of data assets from notebooks and pipelines to lakehouse tables and Power BI datasets and reports.
• Work closely with project teams and business stakeholders (estimating, commercial/QS, planning, H&S, operations, and more) to turn real world requirements into robust data models and actionable insights.
• Document and standardise data processes, including data contracts, source-to-target mappings, transformation logic, and operational runbooks.
• Support and empower users, partnering with BI developers and analysts to promote data literacy, provide technical guidance, and help resolve complex data challenges.

Do you have experience in SQL?, * Hands-on experience with Microsoft Fabric including Lakehouse/Warehouse, Dataflows, Pipelines, and Notebooks (PySpark).

• Strong Power BI skills across data modelling (star schema), DAX, performance optimisation, RLS, composite models, and deployment pipelines.
• Solid data engineering foundations: ELT/ETL design, orchestration, schema design, data quality, and observability.
• Proficiency in SQL for transformations and optimisation, plus Python/PySpark for data processing.
• Experience integrating data from systems such as ERP/finance (e.g., Business Central), scheduling tools (Primavera/MSP), BIM/CDE platforms (Autodesk/BC), and APIs/flat files.
• Practical knowledge of Git and ideally CI/CD for Fabric and Power BI assets.
• Strong understanding of data governance and security, including privacy, sensitivity labelling, RLS/OLS.
• Confident working with business stakeholders, translating domain needs into clear technical solutions.
• Ability to create high-quality documentation, including data contracts, mappings, design decisions, and runbooks.

Desirable

• Awareness of construction industry processes and project lifecycles.
• Advanced Power BI capabilities: Tabular Editor, calculation groups, Direct Lake, and advanced DAX patterns.
• Experience with compliance, audit, ISO standards, or client reporting requirements.
• A passion for change enablement running demos, training, and supporting data literacy across teams.

• Be open - Share feedback, celebrate strengths, and speak up for what's right
• Be collaborative - Offer support, share knowledge, and learn from others
• Be inspiring - Lead with positivity, embrace innovation, and foster teamwork
• Be bold - Speak up, be curious, and help shape the future

Why Join Us?

• Be part of a business that exists to make a difference
• Thrive in a healthy, empowering environment
• Work with passionate, dedicated colleagues who live our values
• Enjoy real opportunities to grow and shape your future
• Good salary and benefits offer

Our offer

• Enhanced annual leave starting at 26 Days + bank holidays rising with service
• Enhanced Paid Family Leave - maternity, paternity, adoption, fertility, compassion, bereavement, crisis, emergency dependants, and much more
• Learning and development - we offer a range of learning opportunities to develop talent at all levels within our business focussing on technical competence, upskilling, compliance and governance and career development.
• Pension - 6.5% employer contribution of your salary into your pension to help you save for the future
• BUPA - optional scheme and can include your family to the scheme (50% contribution)
• Group Income Protection - 50% of your salary covered for 3 years for long term illness
• Health Plans - optional, including dental, cash health plans and critical illness
• EAP - Employee Assistance Programme through Health Assured, supporting you and your family with advice, guidance and counselling on a variety of areas such as health, fitness, home life, finances and much more.
• Mental Health support - through the Thrive app, approved by the NHS, provides tools, to tackle, prevent and manage common stressors such as sleep, bereavement, work issues etc. Also provides relaxation, breathing and meditation techniques and measures impact.
• Savings scheme - Put aside an affordable amount for a rainy day in the future
• Recognition awards - awards for long service and special birthdays
• Onsite gym - we have a gym on site at Head Office - free to use
• Company Doctor - for when you can't get to see your own or if you have any health concerns
• A comprehensive health and wellbeing strategy focussed on physical, emotional, financial and career wellbeing
• A wide range of enhanced benefits to support your well-being and work-life balance

Our business is truly special; part of the Eric Wright Group, and wholly owned by the Eric Wright Charitable Trust, we are a commercially focused business with a social purpose. Forward thinking and people focussed, we retain our traditional values and are extremely proud of our dedicated, passionate and friendly colleagues who live our values and work hard to make a difference every day. Our business would not be the business it is today without its people, we strive to develop and nurture talent, provide a positive healthy environment empowering our people to be the best they can be., Working at the Eric Wright Group of companies is truly special. Owned 100% by the Eric Wright Charitable Trust, we are a commercially focused business with a social purpose, which means that after reinvestment in the business, our profit is donated to charity via the Trust. This ownership structure provides a high level of stability for the Group and supports longer-term commercial and charitable strategies. Our reputation is built on our Chairman's founding principles of a company that must be profitable, ethical and farsighted, as a result we have people, community and social value at our heart. The companies across the Group regularly collaborate to deliver outstanding results on bespoke projects for both public and private sector clients. We are extremely proud of our dedicated, passionate and friendly colleagues who live our values and work hard to make a difference in communities every day. Equal opportunity statement: At Eric Wright Group, our clients come from all walks of life and so do we. We hire great people from a wide variety of backgrounds, who share of values, not just because it's the right thing to do, but because it makes our company stronger. Safeguarding if required The Eric Wright Group is committed to safeguarding and promoting the wellbeing of its employees, contractors and clients and expects its people to share this commitment. Successful applicants may be required to undertake a Disclosure and Barring (DBS) check or Disclosure Scotland check and to provide proof of their right to work in the UK. We are committed to equal opportunities, inclusion and fairness across all employment opportunities and service delivery. All managers and employees are expected to promote our values to ensure our workplaces and services are inclusive and accessible.