Data Engineer

YTL Construction UK; Bath; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading construction company in the UK is looking for a Microsoft Data Engineer to design and implement efficient data pipelines and lakehouse structures. The ideal candidate will have expertise in ETL processes, Azure Data Services, and Power BI integration. This role offers a dynamic opportunity to work alongside senior engineers and contributes to enterprise-wide data governance initiatives. Benefits include a strong pension plan, generous holiday allowance, and opportunities for professional development.

Benefits

Pension contribution of up to 20%

25 days holiday rising to 28

Healthcare package

Life assurance

Cashback from retailers

Paid volunteering day annually

Qualifications

• Experience with Delta Lake and Parquet storage concepts.
• Familiar with data processing using Python and Spark SQL.
• Ability to translate business needs into technical solutions.

Responsibilities

• Design and maintain data pipelines and ETL/ELT processes.
• Develop PySpark notebooks for data transformation.
• Collaborate with BI teams for Power BI integration.
• Ensure data governance compliance.

Skills

ETL/ELT design

Azure Data Services

PySpark

Power BI integration

SQL Server expertise

KQL for Eventstream

Data security and compliance

Excellent teamwork skills

Machine learning integration

Job description

We are looking for a Microsoft Data Engineer to design, implement and optimise data pipelines, data lakes, lakehouses and databases.

You will be involved in designing and implementing data flows, building efficient data models, integrating multiple data sources, and optimising performance and cost while aligning with enterprise data governance, security and compliance.

What you'll do

You will:

• design, develop and maintain data pipelines and ETL/ELT processes
• you will work with our Senior Data Engineer and Architects across the business
• implement Lakehouse and Warehouse structures
• develop PySpark notebooks for data transformation and enrichment
• support and enhance legacy data integrations, eg, SSIS
• design and implement data models optimised for Power BI and downstream analytics (eg, star/snowflake schemas)
• Optimise Lakehouse performance with partitioning, indexing and caching strategies
• collaborate with BI teams to ensure seamless Power BI dataset and semantic model integration
• ensure compliance with data governance (GDPR)
• participate in data quality, lineage and cataloguing initiatives to ensure enterprise-wide trusted datasets
• contribute to CI/CD automation pipelines using Azure DevOps or GitHub Actions
• support key stakeholders
• coordinate with data users and stakeholders to develop and improve data processes
• maintain a good understanding of the technologies that are relevant to YTL UK data and analytics initiatives, covering standards, features and products that could be exploited
• contribute to the establishment and maintenance of agreed standards, patterns and designs applicable to the work undertaken and to ensure that they are adhered to
• ensure integration solutions comply with relevant standards and regulations, including information security best practices.

What you'll need

• ETL/ELT design with a focus on incremental and streaming data pipelines.
• Fabric (Data Engineering, Data factory and Lakehouse).
• Azure Data Services (Data Lake storage, Data Factory, Synapse Analytics, Event Hubs, and Logic Apps).
• PySpark, Spark SQL, and Python for data processing and transformations.
• Expertise in Delta Lake, Parquet and OneLake storage concepts.
• Power BI integration, including semantic models and DirectLake.
• SQL Server and T-SQL with performance tuning expertise.
• KQL (Kusto Query Language) for Eventstream and real-time analytics.
• Familiarity with machine learning integration and predictive analytics pipelines.
• Experience with data security, encryption and compliance standards.
• Excellent teamwork skills for collaboration with highly technical colleagues.
• Familiarity with testing techniques used to plan and execute software tests of all application components (functional and non-functional) to verify that the software satisfies specified requirements and to detect errors.
• The ability to translate business requirements into technical data solutions.

What you'll receive

• A combined pension contribution of up to 20%.
• Career progression and professional development opportunities.
• 25 days' holiday rising to 28 with length of service.
• The opportunity to sell up to five days of holiday every year.
• The opportunity to buy up to ten days of holiday each year (subject to conditions).
• A healthcare package that allows you to claim back healthcare costs.
• Life assurance of up to eight times your salary.
• The opportunity to lease a new electric car through salary sacrifice (subject to conditions).
• Cashback and discounts from more than 3,000 retailers.
• One paid volunteering day each year.
• Enhanced family leave and pay arrangements.
• Access toan interactive health and wellbeing platform.
• Support from trainedmental health first aiders.
• A £1,000 referral fee if you recommend someone who is successfully recruited by us.

Who we are

YTL UK is part of the international YTL Group based in Kuala Lumpur. The UK companies include:

• Wessex Water – one of the top-performing water and sewerage companies in England and Wales, serving 2.9 million people across the South West
• YTL Developments – a major UK developer currently redeveloping a 350-acre former airfield into an award-winning, exciting mix of houses, apartments, schools, commercial space, restaurants and hotels, to make a truly sustainable new community
• YTL Construction UK – a top 20 UK contractor providing fully integrated services to infrastructure, residential, commercial, industry, energy and environmental sectors
• YTL Arena – the development and operation of an entertainment complex that includes a 20,000 capacity arena, conferencing and exhibition space
• Plus, a number of other retail,environmental and specialist businesses.

Our people tell us that YTL UK is a great place to work, which is why so many of them stay with us! You will have a unique opportunity to develop and progress your career within such a diverse group.

We are passionate about diversity and inclusion – with that in mind, all applicants are welcome. We are delighted to have signed the Armed Forces Covenant and are a Disability Confident Employer.

If you require reasonable adjustments to be made during the recruitment process, please inform a member of our Recruitment team.