Senior Consultant, Data Engineer, AI & Data, UKI

Ernst & Young GmbH Wirtschaftsprüfungsgesellschaft; Greater London; On-site; GBP 100,000 - GBP 125,000; Full time

Job summary

A global consulting firm is seeking a Senior Consultant, Data Engineer to design and build robust data pipelines for advanced analytics and AI initiatives. This role requires expert knowledge in data engineering practices and cloud solutions. The ideal candidate possesses a strong background in Python and SQL, with experience in tools like Databricks and Snowflake. Join us to contribute to innovative data solutions that drive business transformation.

Qualifications

• Experience building and maintaining large-scale data pipelines.
• Strong programming skills in Python and SQL.
• Familiarity with data quality frameworks and governance.

Responsibilities

• Design and deploy end-to-end data pipelines.
• Collaborate with data scientists and AI engineers.
• Ensure data quality and integrity.

Skills

Data engineering

Python

SQL

Data governance

Analytical thinking

Collaboration

Education

Degree in Computer Science or related field

Tools

Databricks

Azure Data Factory

Snowflake

CI/CD tools

Airflow

Job description

Senior Consultant, Data Engineer, AI&Data, UKI, London

Location: London

Requisition ID: 1654633

At EY, we’re all in to shape your future with confidence. Join EY and help build a better working world.

Position Overview

We are seeking a highly skilled Data Engineer Senior Consultant with hands‑on experience designing, building, and optimizing data solutions that enable advanced analytics and AI‑driven business transformation. This role requires expertise in modern data engineering practices, cloud platforms, and the ability to deliver robust, scalable data pipelines for diverse business domains.

Your Client Impact

• Design, develop, and deploy end‑to‑end data pipelines for complex business problems, supporting analytics, modernising data infrastructure and AI/ML initiatives.
• Design and implement data models, ETL/ELT workflows, and data integration solutions across structured and unstructured sources.
• Collaborate with AI engineers, data scientists, and business analysts to deliver integrated solutions that unlock business value.
• Ensure data quality, integrity, and governance throughout the data lifecycle.
• Optimize data storage, retrieval, and processing for performance and scalability on cloud platforms (Azure, AWS, GCP, Databricks, Snowflake).
• Translate business requirements into technical data engineering solutions, including architecture decisions and technology selection.
• Contribute to proposals, technical assessments, and internal knowledge sharing.
• Data preparation, feature engineering, and MLOps activities to collaborate with AI engineers, data scientists, and business analysts to deliver integrated solutions.

Essential Qualifications

• Degree or equivalent certification in Computer Science, Data Engineering, Information Systems, Mathematics, or related quantitative field.
• Proven experience building and maintaining large‑scale data pipelines using tools such as Databricks, Azure Data Factory, Snowflake, or similar.
• Strong programming skills in Python and SQL, with proficiency in data engineering libraries (pandas, PySpark, dbt).
• Deep understanding of data modelling, ETL/ELT processes, and Lakehouse concepts.
• Experience with data quality frameworks, data governance, and compliance requirements.
• Familiarity with version control (Git), CI/CD pipelines, and workflow orchestration tools (Airflow, Prefect).

Soft Skills

• Strong analytical and problem‑solving mindset with attention to detail.
• Good team player with effective communication and storytelling with data and insights.
• Consulting skills, including development of presentation decks and client‑facing documentation.

Preferred Criteria

• Experience with real‑time data processing (Kafka, Kinesis, Azure Event Hub).
• Knowledge of big data storage solutions (Delta Lake, Parquet, Avro).
• Experience with data visualization tools (Power BI, Tableau, Looker).
• Understanding of AI/ML concepts and collaboration with AI teams.

Preferred Qualifications

• Certifications such as AWS Certified Data Analytics – Specialty, SnowPro Advanced: Data Engineer.

EY | Building a better working world