Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Ernst & Young

Compare

3.4

based on 10.4k Reviews

2050 Ernst & Young Jobs

SaT-DnA-Data Engineer-Assistant Director

Ernst Young

3.4

based on 10.4k Reviews

12-14 years

₹ 27 - 53L/yr (AmbitionBox estimate)

Noida

1 vacancy

SaT-DnA-Data Engineer-Assistant Director

Ernst & Young

posted 3hr ago

Job Role Insights

Flexible timing

Key skills for the job

Python SQL Oracle Automation Testing Informatica MySQL

+ 4 more

Job Description

We re looking for Assistant Director - Data Engineering. The main objective of the role is to support cloud and on-prem platform analytics and data engineering projects initiated across engagement teams. The role will primarily involve conceptualizing, designing, developing, deploying and maintaining complex technology solutions which help EY solve business problems for the clients. This role will work closely with technical architects, product and business subject matter experts (SMEs), back-end developers and other solution architects and is also on-shore facing.

This role will be instrumental in designing, developing, and evolving the modern data warehousing solutions and data integration build-outs using cutting edge tools and platforms for both on-prem and cloud architectures. In this role you will be coming up with design specifications, documentation, and development of data migration mappings and transformations for a modern Data Warehouse set up/data mart creation and define robust ETL processing to collect and scrub both structured and unstructured data providing self-serve capabilities (OLAP) in order to create impactful decision analytics reporting.

Your key responsibilities

Evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management and warehouse administration for both on-prem and cloud-based engagements
Strong working knowledge across the technology stack including ETL, ELT, data analysis, metadata, data quality, audit and design
Design, develop, and test in ETL tool environment (GUI/canvas driven tools to create workflows)
Experience in design documentation (data mapping, technical specifications, production support, data dictionaries, test cases, etc.)
Provides technical leadership to a team of data warehouse and business intelligence developers
Coordinate with other technology users to design and implement matters of data governance, data harvesting, cloud implementation strategy, privacy, and security
Adhere to ETL/Data Warehouse development Best Practices
Responsible for Data orchestration, ingestion, ETL and reporting architecture for both on-prem and cloud (MS Azure/AWS/GCP)
Assisting the team with performance tuning for ETL and database processes

Skills and attributes for success

12-14 years of total experience with 8+ years in Data warehousing/ Business Intelligence field
Solid hands-on 8+ years of professional experience with creation and implementation of data warehouses on client engagements and helping create enhancements to a data warehouse
Strong knowledge of data architecture for staging and reporting schemas, data models and cutover strategies using industry standard tools and technologies
Architecture design and implementation experience with medium to complex on-prem to cloud migrations with any of the major cloud platforms (preferably AWS/Azure/GCP)
5+ years experience in Azure database offerings [ Relational, NoSQL, Datawarehouse]
5+ years hands-on experience in various Azure services preferred - Azure Data Factory, Kafka, Azure Data Explorer, Storage, Azure Data Lake, Azure Synapse Analytics, Azure Analysis Services & Databricks
Minimum of 8 years of hands-on database design, modeling and integration experience with relational data sources, such as SQL Server databases, Oracle/MySQL, Azure SQL and Azure Synapse
Knowledge and direct experience using business intelligence reporting tools (Power BI, Alteryx, OBIEE, Business Objects, Cognos, Tableau, MicroStrategy, SSAS Cubes etc.)
Strong creative instincts related to data analysis and visualization.
Aggressive curiosity to learn the business methodology, data model and user personas.
Strong understanding of BI and DWH best practices, analysis, visualization, and latest trends.
Experience with the software development lifecycle (SDLC) and principles of product development such as installation, upgrade and namespace management
Willingness to mentor team members
Solid analytical, technical and problem-solving skills
Excellent written and verbal communication skills
Strong project and people management skills with experience in serving global clients

To qualify for the role, you must have

Master s Degree in Computer Science, Business Administration or equivalent work experience.
Fact driven and analytically minded with excellent attention to details
Hands-on experience with data engineering tasks such as building analytical data records and experience manipulating and analysing large volumes of data
Relevant work experience of minimum 12 to 14 years in a big 4 or technology/ consulting set up
Help incubate new finance analytic products by executing Pilot, Proof of Concept projects to establish capabilities and credibility with users and clients. This may entail working either as an independent SME or as part of a larger team

Ideally, you ll also have

Ability to think strategically/end-to-end with result-oriented mindset
Ability to build rapport within the firm and win the trust of the clients
Willingness to travel extensively and to work on client sites / practice office locations
Strong experience in SQL server and MS Excel plus atleast one other SQL dialect e.g. MS Access\Postgresql\Oracle PLSQL\MySQLStrong in Data Structures & Algorithm
Experience of interfacing with databases such as Azure databases, SQL server, Oracle, Teradata etc
Preferred exposure to JSON, Cloud Foundry, Pivotal, MatLab, Spark, Greenplum, Cassandra, Amazon Web Services, Microsoft Azure, Google Cloud, Informatica, Angular JS, Python, etc.
Experience with Snowflake

A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
An opportunity to be a part of market-leading, multi-disciplinary team of 1400 + professionals, in the only integrated global transaction business worldwide.
Opportunities to work with EY SaT practices globally with leading businesses across a range of industries

Employment Type: Full Time, Permanent

Read full job description

Ernst & Young Interview Questions & Tips

Prepare for Ernst & Young Assistant Director roles with real interview advice

What people at Ernst & Young are saying

3.2

Rating based on 42 Assistant Director reviews

Anonymous · Customer Success, Service & Operations in Bangalore / Bengaluru

Likes

Against many popular opinions, except coming across a few toxic individuals here and there, my overall experience has been an exceptional one. The leave policy is great in comparison to what I have experienced in IBM and Oracle Financials previously. The opportunities are immense and the compensation is above my expectations in comparison with IBM and Oracle Financials.

Salary - Excellent

+6 more

Dislikes

Promotions above manager levels get difficult to get sponsors. Work does get exhaustive at times and one needs to find balance between what we want vs what is available.

Read 42 Assistant Director reviews