Point your AI agent at freehire and let it find you a job.

Get the CLI →

Jobtailor

NewBe an early applicant

Senior Data Engineer

Discussion

Summary

Designs, builds and maintains data pipelines, ETL processes and data models, documenting architectural decisions and mentoring other engineers. Core stack is SQL, Python and a modern cloud data warehouse (Snowflake/BigQuery/Redshift), with testing, CI/CD and data-quality work; dbt, Fivetran and AWS/Glue are desirable extras.


  • Design, build and maintain data pipelines, ETL processes and data models

  • Make and document architectural and data-modelling decisions

  • Integrate and transform diverse data sources into a reliable, unified data platform

  • Design and implement database schemas for large volumes of structured and unstructured data

  • Build scalable and maintainable data solutions supporting analytics, reporting, operational processes and data-driven products

  • Champion engineering standards across SQL, Python, testing, documentation and code review

  • Review designs and code produced by other engineers

  • Identify and address technical debt and improve the data platform

  • Optimise data solutions using partitioning, indexing and caching

  • Develop and maintain data quality processes

  • Improve reliability, observability and performance of data solutions

  • Collaborate with product managers, developers, data colleagues and business stakeholders to define requirements

  • Diagnose and resolve performance and production issues

  • Coach and mentor engineers

  • Keep up to date with data engineering developments and evaluate new technologies

  • Participate in the team’s out-of-hours support rota where required


Requirements



  • Strong commercial data engineering experience, ideally in a senior or lead capacity

  • Significant experience delivering production data engineering solutions

  • Advanced SQL and an excellent understanding of databases

  • Strong Python skills for data engineering

  • Strong understanding of data warehousing and dimensional/data modelling

  • Experience designing and operating production data pipelines

  • Experience with a modern cloud data warehouse such as Snowflake, BigQuery or Redshift

  • Experience with automated testing, version control and CI/CD

  • Strong understanding of data quality, reliability and observability

  • Experience diagnosing performance and production issues

  • Ability to make, document and communicate technical design decisions

  • Experience mentoring or supporting other engineers

  • Excellent written and verbal communication skills

  • Desirable: Experience with Snowflake, dbt or Fivetran

  • Desirable: Experience working with AWS / Glue

  • Desirable: Experience with MySQL or SQL Server

  • Desirable: Experience with Salesforce

  • Desirable: Familiarity with JSON and data integration formats


Core Competencies


Demonstrates expertise in designing and maintaining data pipelines, ETL processes, and data models, with a strong focus on SQL and Python for data engineering. Proven ability to optimize data solutions for performance and reliability while collaborating effectively with cross-functional teams.


Highest-signal resume keywords



  • Data Engineering Experience

  • Advanced SQL Skills

  • Strong Python Skills

  • Cloud Data Warehouse Experience

  • Data Quality and Reliability


Hard Skills



  • Data Pipeline Design

  • ETL Processes

  • Data Modelling

  • Database Schema Design

  • Automated Testing

  • Version Control

  • CI/CD

  • Performance Diagnosis

  • Data Quality Processes

  • Technical Documentation


Soft Skills



  • Excellent Communication Skills

  • Mentoring and Coaching


Industry Keywords



  • Data Warehousing

  • Dimensional Modelling

  • Data Integration

  • Observability

  • Technical Debt


Tools & Technologies



  • Snowflake

  • BigQuery

  • Redshift

  • AWS

  • Glue

  • MySQL

  • SQL Server

  • Dbt

  • Fivetran

  • JSON

Skills

See also

Data Engineering jobs by country — openings, pay and top skills →

Tailor your CV for this role?

We couldn't check your fit for this role — add a CV to your profile to see it next time.

A new version of freehire is available