Senior Data Engineer and Data Architect

Ernst & Young LLP ( EY India ); Bengaluru; On-site; INR 3,200,000 - 4,000,000; Full time

Job summary

EY is seeking a Senior Consultant - Data Engineering & Data Architecture to design and build modern data platforms using Databricks on AWS, and to lead end-to-end data pipelines. You will shape data lakehouse architectures and drive scalable solutions across multiple domains, partnering with business and technology teams to deliver value.

You will architect Lakehouse patterns (Raw, Silver, Gold), implement streaming with Kafka, ensure data quality, governance and security, and enable

Qualifications

• Hands-on data engineering lifecycle expertise across ingestion, transformation and consumption.
• Experience designing enterprise-grade Data Lakehouse platforms on cloud.
• Strong knowledge of governance, quality, and scalability practices.

Responsibilities

• Design, implement modern cloud-based Data Lakehouse platforms on AWS.
• Build scalable Raw/Silver/Gold data layers and end-to-end pipelines.
• Develop streaming pipelines with Kafka and integrate with Databricks/WaaS services.
• Create dimensional models for enterprise reporting and analytics.
• Lead DevOps practices, CI/CD and code reviews for data workloads.
• Collaborate with stakeholders; mentor engineers and drive delivery.

Skills

Databricks

Apache Spark

Delta Lake

Kafka Streaming

Semi-structured data

AWS Cloud

ETL/ELT

Data Lakehouse

Data Modeling

Dimensional Modeling

Data Warehousing

SQL Performance

Real-Time Processing

Data Pipelines

DevOps

GitHub

Azure DevOps

CI/CD

DAB

Agile Delivery

Problem Solving

Communication

Stakeholder Mgmt

Education

Bachelor's / Master's in CS/IT/Engineering

Tools

GitHub

Azure DevOps

Databricks Asset Bundles

Job description

EY - GDS Consulting - AI and DATA - Kafka Engineer - Senior

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY Hiring Requisition Senior Consultant - Data Engineering & Data Architecture Experience : 5-7 Years Job Summary EY is seeking a highly skilled Data Engineering and Data Architecture professional with strong expertise in Databricks, Kafka, AWS, and modern Data Lakehouse architecture. The ideal candidate will have hands‑on experience designing and implementing scalable data platforms, building enterprise‑grade data pipelines, and delivering analytics‑ready data products. The candidate should possess deep technical knowledge across the data engineering lifecycle, from ingestion and transformation to modelling and consumption, while driving delivery through engineering best practices, automation, and stakeholder collaboration.

Data Architecture & Platform Engineering

• Design and implement modern cloud-based Data Lakehouse platforms using Databricks on AWS.
• Define and implement scalable Raw, Silver, and Gold layer architectures.
• Architect end‑to‑end data solutions supporting reporting, BI, advanced analytics, and AI use cases.
• Establish data platform standards, governance controls, and engineering best practices.

Data Engineering & ETL

• Design, develop, and optimize large‑scale ETL/ELT pipelines.
• Build high‑performance Spark‑based data processing solutions.
• Develop reusable and metadata‑driven ingestion and transformation frameworks.
• Ensure data quality, reliability, scalability, and operational efficiency across data pipelines.
• Implement data validation, reconciliation, and monitoring mechanisms.
• Handling semi‑structured data formats- json, xml

Streaming & Real‑Time Data Processing

• Design and implement real‑time data ingestion frameworks using Kafka.
• Build scalable streaming solutions integrating Kafka with Databricks and AWS services.
• Optimize streaming workloads for performance and resilience.

Data Modeling

• Design conceptual, logical, and physical data models.
• Create dimensional models, Fact tables, and Dimension tables for enterprise reporting and analytics.
• Implement data models aligned with business and analytical requirements.

DevOps & Engineering Excellence

• Implement CI/CD pipelines for data engineering workloads.
• Leverage Azure DevOps, GitHub, Databricks Asset Bundles (DAB), and automation frameworks.
• Promote version control, code reviews, testing, and release management practices.

Stakeholder & Team Management

• Collaborate with business stakeholders, architects, and delivery teams to translate requirements into scalable solutions.
• Provide technical leadership and mentoring to engineering teams.
• Contribute to solution design workshops, estimations, and architecture reviews.

Required Skills

Core Technical Skills

• Databricks (Expert Level or Databricks Champion)
• Apache Spark (PySpark / Spark SQL)
• Delta Lake
• Kafka Streaming
• Semi‑structured data processing like json, xmls
• AWS Cloud Services
• ETL/ELT Design and Development
• Data Lakehouse Architecture
• Data Modeling and Dimensional Modeling
• Data Warehousing Concepts
• SQL and Performance Optimization
• Real‑Time Data Processing
• Data Pipeline Orchestration
• DevOps & Collaboration
• GitHub
• Azure DevOps
• CI/CD Implementation
• Databricks Asset Bundles (DAB)
• Agile Delivery Methodology

Other relevant skills

• Strong problem‑solving and analytical skills.
• Excellent communication and stakeholder management capabilities.
• Ability to work in a global delivery environment.
• Strong ownership mindset with focus on quality and client value.
• Demonstrated leadership and mentoring capabilities.

Preferred Experience

• Experience designing enterprise‑scale Data Lakehouse solutions.
• Hands‑on implementation of Raw, Silver, and Gold architectural patterns.
• Experience building metadata‑driven ingestion and transformation frameworks.
• Exposure to Insurance, Banking, or Financial Services domain data platforms.
• Experience supporting analytics, reporting, and AI/ML workloads on Databricks.
• Experience leading distributed teams and managing technical delivery.

Certifications (Preferred)

• Databricks Certified Data Engineer Associate/Professional
• Databricks Certified Professional Certifications
• Databricks Generative AI Engineer Associate
• Databricks Lakeflow Certification
• Databricks Asset Bundles (DAB) Certification

Educational Qualification

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline.

EY | Building a better working world EY exists to build a better working world, helping to create long‑term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.