Data Engineer in Bath

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

• Design, develop and maintain data pipelines and ETL/ELT processes.
• Implement Lakehouse and Warehouse structures.
• Develop PySpark notebooks for data transformation and enrichment.
• Design and implement data models optimised for downstream analytics (e.g. star/snowflake schemas).
• Optimise Lakehouse performance with partitioning, indexing and caching strategies.
• Ensure integration solutions comply with relevant standards and regulations, including information security best practices.
• Maintain a good understanding of the technologies that are relevant to YTL UK data and analytics initiatives.
• Support key stakeholders and users.
• Contribute to CI/CD automation pipelines using Azure DevOps or GitHub actions.
• 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.
• Contribute to data quality, lineage and cataloguing initiatives to ensure enterprise-wide trusted datasets.
• Occasional support of legacy data integrations e.g. SSIS.

What you’ll need

• ETL/ELT design with a focus on incremental and streaming data pipelines.
• Azure Data Services (Data Factory, Synapse Analytics, Event Hubs, and Logic Apps).
• PySpark, Spark SQL, and Python for data processing and transformations.
• Knowledge of Data Lake, Delta Lake, Parquet and OneLake storage concepts.
• SQL Server and T-SQL experience with data security, encryption and compliance standards.
• Excellent teamwork skills for collaboration with highly technical colleagues.
• The ability to translate business requirements into technical data solutions.
• 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.
• Familiarity with machine learning integration and predictive analytics pipelines.
• Power BI integration, including semantic models and DirectLake.
• KQL (Kusto Query Language) for Eventstream and real-time analytics.

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 to an interactive health and wellbeing platform.
• Support from trained mental 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.

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.