EY Jobs

Job Information

EY Data Engineer in Gurgaon, India

Data Engineer

Core Business Services

Requisition # GGN0047Q

Post Date Jun 04, 2021

Job Summary:

The Data Engineer will join a growing team of analytics experts responsible for expanding and optimizing data, data infrastructure, processing and wrangling.

The position will be responsible for creating data integration frameworks, set up data flow solutions, gather and cleanse data, understands the meaning of datasets and dataset compatibility and implements business rules.

The Data Engineer will support data scientists, product managers and analysts on data initiatives and will ensure optimal data delivery is consistent across projects.

The incumbent must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. This role is expected to optimize or even re-designing our data infrastructure to support our next generation of products, services and data initiatives.

The output produced by Data Engineer is used to generate insights that support strategic decision-making, along with ideas to automate, innovate, and enhance the measurement and reporting process.

Essential functions of the job:

  • Create and schedule data flow tasks in Azure Data Factory or SSIS. Should be able to create automated data validation methods.

  • Assemble, gather and cleanse data sets that meet business requirements.

  • Queries and/or integrates data by using SQL, SQL-like, ELT or ETL skills tools and techniques.

  • Creates data models by delivering calculations, aggregations and derivations from input data.

  • Implements business rules that are required to meet business needs

  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure ‘big data’ technologies.

  • Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

  • Design, develop and manage analytic dashboards and new reports

  • Analyze, visualize, and provide analytics on data captured daily to build reporting solutions to support various knowledge initiatives

  • Work with stakeholders to assist with data-related technical issues and support data and infrastructure needs.

  • Communicates clearly and drives data accuracy, quality and integrity ensuring compliance with data governance.

  • Create data tools for analytics and data scientist team members that assist them in building and optimizing products.

  • Work with data and analytics experts to strive for greater functionality in our data systems.

Analytical Responsibilities:

Database development

  • RDBMS Database and data processing development (and design)

  • Data source analysis to refine code / application of pattern and exceptions

  • Catering for data scenarios and failures

  • Unit testing with dev / test / live data

Data wrangling

  • File, column store, object store and data processing development (and design)

  • Data source analysis to refine code / application of pattern and exceptions

  • Catering for data scenarios and failures

  • Unit testing with dev / test / live data

Test analysis

  • Test scenario and case preparation and execution

  • Data querying construction and execution

  • Testing framework development and configuration

  • Defect logging and management

Technical Skill Requirements:

  • Good knowledge of data integration practices in Azure. Should have experience in scheduling data flow tasks in Azure Data Factory / SSIS using APIs, cloud connectors, etc.

  • Strong technical analytics expertise. Good knowledge of data analytics architectures and standards, including data warehouses, master data management, ETL, OLAP, data quality management, advanced analytics, BI, visualization and service execution rigor / discipline

  • Experience in cloud database architecture and exposure to Adobe web analytics platform is a plus.

  • Data Analytics expertise, including tools, techniques, and data visualization best practices (e.g., Azure Data Factory, Alteryx, Power BI)

  • In-depth knowledge of data integration techniques and data management

  • Ability to operate digitally and display a digital mindset

Supervision Responsibilities:

  • Works with a geographically dispersed team, highly self-motivated, able to work independently

  • Ability to complete multiple medium-sized projects and work with project teams

  • Coaches junior team members

  • Able to meet deadlines independently

Other Requirements:

Job Requirements:


  • Bachelor degree in computer science or computer engineering


  • 5 – 7 years of relevant experience in the field of Data Analytics/ Data Engineering

  • 2 years minimum of relevant experience in a professional data management (ETL, manipulation) role

  • Ideally, experience in knowledge measurement and analytics program in large organization an advantage

Certification Requirements:

  • Data integration certifications (e.g. MS Azure) desirable