Data Engineer

Job description

About us

We're Transform.

We turn data and tech into competitive advantage and social impact for the world's most complex organisations, both public and private.

Organisations like Toyota, the Cabinet Office, Transport for London, Public Health England, Historic Royal Palaces, HM Courts and Tribunal Service, Santander, Department for Education and Domino’s. To name but a few.

We're not here to generate more business for ourselves. We're here to create startling, ambitious outcomes for clients - leaving them with the capabilities they need to take it from there.

We love creating real change. Making a big impact on people's lives. Optimising services, driving business growth or realising social change.

To do that, we built an inclusive, high-performance culture where the world's most talented people do the best work of their careers.

That's what gets us out of bed every day. We hope you feel the same.

​We're part of the Next 15 group, a multi-national organisation spanning over 25 brands. Brands like ours, looking to stand out from the crowd as they deliver best in class work for their clients.

Find out more at:

Data Engineer

You’ll be working to deliver intricate data engineering workflows and insightful data analysis on a range of complex research processes, working closely with our researchers, projects managers and data scientists.

Key Responsibilities:

  • Design, plan and build new data pipelines and data processing workflows following best practises based on our client’s needs.
  • Update and improve existing workflows with the latest technologies to ensure we are providing the best solutions to our clients.
  • Delivered data products and services for use within public or private sector.
  • Analyse and assess data quality including data quality management i.e. profiling, cleansing, deduplication and matching of datasets to inform direction of where effort can be focussed to improve processes.
  • Interpret the technical requirements of our clients to support project managers in bidding and planning projects.
  • Present key technical findings and potential routes forward to clients.
  • Mentor and support the development of junior data engineers within the team.

Key Skills/Experiences:

  • Excellent knowledge of Informatica DEI (or Powercentre or BDM), Azure SQL, Python and the supporting data engineering and analytical libraries available.
  • Experience with Databricks and distributed data processing utilising Pyspark.
  • Strong knowledge of SQL and associated tools.
  • Created databases or data lakes with appropriate schemas for use for insight reporting or analytical modelling.
  • Experience with Azure Data Factory and/or other similar services available from the major cloud platform providers (Azure, AWS, GCP).
  • Experience of working in Azure is a must and use of appropriate technologies.
  • Use of Azure DevOps for sprint planning and tasks and also code repositories.
  • Worked with DevOps teams on CI/CD and automated testing frameworks.
  • Clear understanding of Agile working practices and a sprint-based development cycle.
  • Confidence in discussing complex technical processes with key stakeholders.
  • Experience in presenting technical outputs to range of audiences with varying technical capabilities.
  • Experience with a range of database technologies including data lakes such as Azure SQL or SQL Server, PostgreSQL, Snowflake, MySQL, Cosmos DB or Mongo DB.

Who are we looking for?

It's really hard to get across in a job spec, but Transform is an absolutely brilliant place to work. If you’re the sort of person who...

...loves working with amazing people on juicy projects big on talent but not-so-big on ego

...and is energised by important, challenging work and steep learning curves …

then we really should talk.

Our culture is built on:

  • Being one team; we work for and with each other with respect and positive intent; when the going is tough, we support not blame each other.
  • We aim high and are ambitious; we bring the energy and positivity.
  • We are curious and embrace new ideas and different perspectives, generous with our time and with each other.
  • We are not afraid to fail, we learn from our failures, turning them into our future successes.
  • We deliver quality in everything we do; we are open and honest with each other and our clients.

Our benefits include:

  • Holiday entitlement, 28 days with the option to buy/sell up to 5 days
  • Day off (on or in the week of) your birthday
  • Pension eligibility, up to 5% matched contributions
  • Healthcare eligibility, private healthcare with Vitality, option to buy discounted family cover
  • Enhanced maternity, paternity, and shared parental leave
  • Cycle to work & electric car schemes
  • Gym & retail discounts
  • Regular social events/activities
  • A range of other benefits from our flexible benefits package

At Transform we believe in a culture of inclusivity, we celebrate difference and believe that diversity makes our business more relevant, our work more meaningful and our people more empowered. We’re committed to equality of opportunity for all, and we actively seek applications from all ethnicities, orientations, beliefs, gender identities + those with neurodiverse traits and disabilities.

If this sounds like you, please get in touch to discuss in more details.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.