Senior Data Engineer

Senior Data Engineer
Permanent
Full time (34.5 hours), we are open to a conversation about how you work these hours
Location – Split between home and our London Office
Salary Range £63,000 - £69,000

About the role

As the key technologist in your product team, you'll be hands-on in developing and maintaining data pipelines using Azure Synapse. Collaborating closely with stakeholders such as data analysts and architects, you'll focus on integrating, consolidating, cleansing, and structuring data for analytics applications. 

Key Responsibilities 

• Azure Synapse Expertise: Act as the domain expert, ensuring reliable, maintainable and scalable data solutions. 
• Technical Leadership: Define tasks, support incident management, ensure quality deliverables for your team and automate manual processes.
• Code Quality: Develop high-quality, secure, and maintainable code while promoting best practices within the team such as peer reviews, pair programming and DevOps practices.
• Compliance: Ensure compliance with GDPR and other relevant legislation.
• Scrum Participation: Shape user stories and help the team achieve sprint goals. 
• Continuous Learning: Stay updated on industry trends and drive the adoption of relevant technologies. 
• Mentorship: Guide junior and mid-level data engineers to enhance their skills. 

About you

The successful candidate will demonstrate the following skills and experience:

• Experience: Strong background with Azure Synapse and the wider Azure Analytics Ecosystem. 
• Technical Skills: Proficient in SQL and PySpark (Python); familiar with DevOps processes and Infrastructure as Code. Knowledge of BI tools such as Power BI.
• Data Modelling: Skilled in data modelling (especially dimensional) and database management, including performance tuning.
• Desirable: Knowledge of additional cloud warehousing products as we are still improving the data platform, Azure certifications, experience with Delta Lakes. 

In return, we offer a range of benefits including:

• 25 days holiday plus flexible bank holiday options, increasing by 1 day every year of service up to 30 days 
• Pension matched up to 7.5%
• 120+ learning and development offers, with access to external professional qualifications
• Flexible working patterns, such as compressed hours, flexibility to work earlier or later around our core working hours of 10am-4pm
• Holiday buying and selling scheme, life insurance, free wills, retail discounts and much more

Recruitment Process

Application deadline: EOD Wednesday 29th January 2025.

To ensure fairness and consistency to select the best candidate for this role, all our applications are anonymised up until an interview has been confirmed. 

So we can support you to be your best during the application or interview process, please contact Macmillan TA Team TATeam@macmillan.org.uk for advice and reasonable adjustments

Please submit your application as soon as possible as we reserve the right to change the closing date of our vacancies. 

We welcome applications from everyone who meet the criteria and strongly encourage individuals to apply who have a disability, impairment or health condition or individuals who identify as Black, Asian or from another minority ethnic background, as these groups are currently under-represented at Macmillan. Our Equity, Diversity and Inclusion Strategy here along with our internal employee representation body, ‘Our Voice’ and 8 Employee Network groups help us promote fairness and belonging, becoming an engaged and inclusive organisation for all our people.