Senior Consultant / Data Engineer AI & Data UKI

Ernst & Young GmbH Wirtschaftsprüfungsgesellschaft; Belfast; Hybrid; GBP 55,000 - GBP 75,000; Full time

Job summary

A leading consulting firm is looking for a Data Engineer Senior Consultant to design and implement data solutions that drive advanced analytics and transformational projects. This role requires strong expertise in Python, SQL, and modern data engineering practices, enabling collaboration with diverse teams. The successful candidate will ensure data quality and governance while building scalable data pipelines in cloud environments like Azure and AWS. Join this role based in Belfast and make an impact in a globally connected workforce.

Qualifications

• Hands-on experience designing and building data solutions for advanced analytics.
• Familiarity with data engineering libraries, like pandas and PySpark.
• Experience with data quality frameworks and compliance requirements.

Responsibilities

• Design and implement data models and ETL workflows for complex problems.
• Collaborate with AI engineers and data scientists for integrated solutions.
• Ensure data quality and governance throughout the data lifecycle.

Skills

Python

SQL

ETL/ELT processes

Data modeling

Problem-solving mindset

Education

Degree in Computer Science, Data Engineering or related field

Tools

Databricks

Azure Data Factory

Snowflake

Power BI

Job description

Location: Belfast

Other locations: Primary Location Only

Requisition ID: 1657289

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help to build a better working world.

Data Engineer Senior Consultant – Job Specification

Location: Belfast or Derry/Londonderry

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 such as finance, supply chain, energy, and commercial operations.

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.
• Experience building and maintaining data pipelines using platforms such as Databricks, Azure Data Factory, Snowflake, or similar.
• Good programming skills in Python and SQL, with familiarity with data engineering libraries (e.g., pandas, PySpark, dbt).
• Solid 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