Macmillan cancer support

Senior Data Engineer

15/01/2025
Other
Apply Now
Deadline date:
£63000 - £69000 / year

Job Description

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

Related Jobs

Dufrain, data management & analytics consulting

Senior Data Engineer

11/12/2024
Other
Apply Now
Deadline date:

Job Description

We are Dufrain, a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing strategies for AI readiness, improving data literacy and culture, enhancing real-time reporting, and managing data from mergers and acquisitions.

At Dufrain we prides ourselves on a creative and innovative approach, focusing on delivering exceptional outcomes for clients by leveraging data to drive growth and efficiency.

Our mission is to inspire, shape and deliver the data capabilities of tomorrow.

We have great opportunities for Senior Data Engineers to play a pivotal role in supporting clients navigate the complexities of data management, analytics, and strategy.

As a Senior Data Engineer you will

  • Possess a broad range of data engineering skills, with a focus on having delivered in Microsoft Azure
  • Develop good working relationships with clients on a project including interpersonal skills with both business and technical focused colleagues.
  • Experience working as a data engineer to develop performant end-to-end solutions in a collaborative team environment.
  • Delivering high-quality pieces of work, proven ability to escalate problems to client / senior team members where necessary and propose possible solutions.
  • Support building the Consulting practice through contribution to ongoing initiatives. This can include contributing to knowledge-sharing activities, and data services.
  • Demonstrated success in delivering commercial projects leveraging the above technologies.
  • Experience overseeing junior staff, including mentoring, reviewing work, and ensuring project alignment with organisational goals and standards.


EXPERIENCE REQUIRED

  • Strong experience designing and delivering data solutions in Azure Data Factory, Azure Synapse or Fabric.
  • Expertise in SQL and Python.
  • Experience working with relational SQL databases either on premises or in the cloud.
  • Experience delivering multiple solutions using key techniques such as Governance, Architecture, Data Modelling, ETL / ELT, Data Lakes, Data Warehousing, Master Data, and BI.
  • A solid understanding of key processes in the engineering delivery cycle including Agile and DevOps, Git, APIs, Containers, Microservices and Data Pipelines.
  • Experience working with one or more of Spark, Kafka, or Snowflake

Nice to have certifications

  • DP-203 Azure Data Engineering
  • Microsoft Certified: Fabric Analytics Engineer Associate

SKILLS REQUIRED

  • A high level of drive with the ability to work to tight deadlines.
  • Experience of providing insightful solutions
  • The ability to participate effectively in meetings with senior stakeholders
  • A team player who supports, encourages and shares knowledge with others
  • A self-starter with the ability to work under pressure and with limited supervision
  • A track record of accurate output and responsibility for elements of project delivery
  • The ability to work as part of an integrated team or on an individual basis
  • Awareness of industry standards, regulations and developments


Benefits

  • Competitive base salary
  • Annual Performance related bonus
  • Hybrid home/onsite/office working – Edinburgh, Manchester & London
  • 25 days annual leave (plus bank and public holidays)
  • Birthday day off – celebrate with an extra holiday
  • Career progress programme – guaranteed learning and development investment and your own career coach
  • Life insurance
  • Private medical health insurance
  • Contributory pension
  • Health and wellbeing group
  • And many more.

If you’re passionate about data, and you’re looking to join a leading data and analytics company based in the UK, you could find your dream role at Dufrain.

Please submit your CV highlighting your relevant experience and certifications. Applicants must have the right to work in the UK and not require sponsorship now or in the future. Visa sponsorship is not available.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Related Jobs

Dentsu

Senior Data Engineer

06/12/2024
full-time
Apply Now
Deadline date:

Job Description

Lead media-focused cloud engineering client projects, including owning client relationships, managing junior team members and delivering hands on technical work.

Job Description:
Merkle’s heritage in data, technology and analytics is the foundation for our understanding of consumer insights that inspires our people-based marketing strategies. Combined with our expertise in performance creative and media, we can then offer our clients content-driven, contextual customer experiences that increase business growth.
In 2016, the agency joined dentsu, one of the world’s biggest media companies to form the Customer Experience Management (CXM) Line of Business.
Responsibilities:
  • Reporting into the Senior Director of Engineering, you will provide BigQuery solutions for analysing Google Analytics and media data
  • You will deliver ETL processes to ensure data accuracy and integrity
  • You will collaborate with data analysts and marketing teams to understand data requirements and deliver insights
  • You will create and manage data pipelines to integrate multiple data sources into BigQuery
  • You will complex SQL queries to extract, transform, and load data
  • You will monitor and troubleshoot data issues
Requirements:
  • You will have experience as a BigQuery Developer or in a similar role
  • You will have proficiency in SQL and experience with Google BigQuery
  • You will have familiarity with Google Analytics and media data
  • You will have experience with ETL tools and processes
  • You will have experience communicating updates and resolutions to customers and other partners
  • You will have experience with Python or other programming languages
  • You will have knowledge of cloud platforms such as Google Cloud Platform (GCP)
  • You will have understanding of digital marketing and media analytics
What we’ll give to you
This is a permanent role. The team is based in our London and Edinburgh office but operates under flexible working arrangements. Whether it’s the joy of working with people at the top of their game or the Dentsu social calendar, people love working here – and we hope you will too
  • Flexible hybrid working with wonderful central London office location
  • Career development through Dentsu University and other tools; with access to courses, textbooks, mentorship, and external training funding
  • Private Medical Insurance, Company Pension, life insurance, and other corporate benefits
  • A selection of other benefits includes 3 wellness days, birthday day off and 2 volunteer days
Inclusion and Diversity

Our diverse and inclusive culture enables our employees to bring their whole selves to work and be proud of doing so. For us, this is the foundation for great innovation which, in turn, generates better outcomes for our people, partners, and communities. This is why we encourage applications from people with disabilities, and of all ages, nationalities, backgrounds, and cultures.
About dentsu

Taking a people-centered approach to business transformation, we use insights to connect brand, content, commerce and experience, underpinned by modern creativity. As part of Dentsu Group Inc. we are headquartered in Tokyo, Japan and our 65,000 employee-base of dedicated professionals work across four regions (Japan, Americas, EMEA and APAC). Dentsu combines Japanese innovation with a diverse, global perspective to drive client growth and to shape society.

Diversity, equity, and inclusion sits at the heart of our Social Impact strategy – our fully integrated sustainability strategy which includes our ambition to build a fair and more equal society, where everyone is equipped to thrive.

If you have any reasonable adjustment needs arising from a disability or medical condition to fully participate in the recruitment process, please discuss this with our recruitment teams.
#LI-Hybrid #LI-MERKLE
Location:

London

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

Related Jobs