Senior Data Engineer

Description:

The Digital Recruitment Company is proud to partner with one of the UK’s leading Wealth Management firms in their search for a Senior Data Engineer. This is an exceptional opportunity to join a forward-thinking organisation that leverages cutting-edge data and cloud technologies to deliver secure, high-quality, and innovative services to an expanding client base.

The successful candidate will play a pivotal role in designing, developing, and maintaining the organisation’s Azure-based data infrastructure, shaping the next generation of their data platform as they transition to Microsoft Fabric. This role offers an exciting blend of technical leadership, platform modernisation, and hands-on engineering, ideal for professionals seeking growth in a highly collaborative environment.

Key Responsibilities:

Data Engineering & Architecture

• Design, build, and maintain Azure Data Factory (ADF) pipelines to manage complex ETL processes and integrations.

• Develop scalable, optimised data models in Azure Synapse Analytics to support analytics and operational reporting.

• Lead the design and governance of Power BI datasets and semantic models, ensuring adherence to DAX best practices and performance tuning.

• Shape and evolve the organisation’s data architecture, supporting the migration to Microsoft Fabric and driving data platform modernisation.

Data Governance & Quality

• Implement and maintain data validation, monitoring, and quality frameworks to ensure the reliability and integrity of all data assets.

• Manage and optimise Azure Data Lake structures, ensuring seamless integration with analytics environments.

Collaboration & Mentorship

• Work closely with cross-functional teams to translate business requirements into technical data solutions.

• Mentor and guide junior data engineers, establishing and enforcing best engineering practices.

• Participate in Agile delivery processes using Azure DevOps for sprint planning, backlog management, and CI/CD workflows.

Continuous Improvement & Innovation

• Contribute to the organisation’s adoption of Microsoft Fabric by influencing architecture decisions and integration strategies.

• Explore AI-driven automation through ChatGPT and Copilot integrations to enhance data processing and reporting efficiencies.

Technical Skills:

• Azure Data Factory (ADF): Expert in building and automating ETL pipelines.

• Azure Synapse Analytics: Skilled in SQL pool performance tuning, data warehousing, and large-scale analytics.

• Power BI: Advanced experience managing enterprise models, data governance, and performance optimisation.

• SQL: Expert in writing, optimising, and troubleshooting complex queries.

• Azure Data Lake: Strong understanding of storage layers, structures, and analytics integration.

• Microsoft Fabric: Experience contributing to or leading adoption projects (preferred).

• Git / Azure DevOps: Proficient in version control, CI/CD, and release management.

• Azure Machine Learning (desirable): Experience integrating ML models into data pipelines.

• AI & Automation (desirable): Experience leveraging ChatGPT/Copilot for insights and automation.

Soft Skills:

• Proven leadership and mentoring capabilities within engineering teams.

• Strong documentation and communication skills.

• Analytical thinker with a problem-solving mindset.

• Collaborative and adaptable, thriving in a fast-paced, agile environment.

• Passionate about data-driven innovation and continuous improvement.

Experience Required:

• Minimum 5 years of experience in a Data Engineering role within a cloud-based environment.

• Demonstrated success delivering projects using Azure Data Factory, Synapse Analytics, and Power BI.

• Experience leading data modernisation initiatives involving Microsoft Fabric or similar technologies.

• Proven ability to mentor junior team members and establish technical standards.

Benefits:

This organisation offers an exceptional benefits package focused on both professional and personal well-being, including:

• Salary: £60,000 – £70,000

• Bonus scheme based on performance

• 25 days holiday, rising to 28 with service (plus additional leave for birthday, volunteering, wedding, or moving house)

• Holiday purchase scheme (buy up to 5 extra days)

• Private Medical Insurance (PMI) with optical & dental cover

• Pension: 7% employer / 5% employee contribution

• Group Income Protection (GIP): 75% of salary

• Death in Service (DIS): 4x salary

• Critical Illness Cover (CIC): £10k cover

• Professional qualifications, study support, and career development programs

• Offices closed for 3–4 days during Christmas

• Supportive, innovative, and growth-focused working culture