EYP - DnA - Assistant Manager

Ernst & Young Advisory Services Sdn Bhd; Pune District; On-site; INR 3,500,000 - 5,500,000; Full time

Job summary

EY Global Delivery Services in India (Pune) seeks an Associate Manager - Data Engineering to lead data warehousing, ETL and cloud data architecture initiatives for client engagements. You’ll design, develop and deploy scalable solutions across on‑prem and cloud platforms, collaborating with architects, SMEs and BI developers.

Ideal candidates have 8+ years in data warehousing/BI, 3+ years with Databricks/Snowflake, and strong SQL, Python, and BI tooling. EY offers global exposure and growth.

Qualifications

• 8+ years of total experience with 5+ years in Data warehousing/ BI and Data Modelling.
• 3+ years experience in Databricks and Snowflake implementation.
• 5+ years hands-on experience with data warehouses on client engagements.
• Strong knowledge of data architecture for staging and reporting schemas.
• Experience with medium to complex on-prem to cloud migrations (AWS/Azure/GCP).
• 3+ years experience in Azure database offerings (Relational, NoSQL, Datawarehouse).
• 3+ years hands-on database design and integration with SQL Server/Oracle/MySQL/Azure SQL.
• 3+ years hands-on Programming language preferably Python.
• Knowledge of BI tools (Power BI, Tableau, Alteryx).

Responsibilities

• Evaluating and selecting data warehousing tools for BI and data management for on-prem and cloud engagements.
• Strong working knowledge across ETL, ELT, data analysis, metadata, data quality, and design.
• Design, develop, and test in ETL tool environment to create workflows.
• Provide technical guidance to a team of data warehouse developers.
• Coordinate with stakeholders on data governance, cloud strategy, privacy, and security.
• Adhere to ETL/Data Warehouse development best practices.
• Responsible for data orchestration, ingestion, ETL and reporting architecture for on‑prem and cloud (Azure/AWS/GCP).
• Assist the team with performance tuning for ETL and database processes.

Skills

Cloud Computing

Data Architecture Design

Data Integration

Data Quality

Data Security

Database Management

Semantic Layer

Computational Thinking

Programming

Problem Solving

Systems Thinking

Analytical Thinking

Collaboration

Client Handling

Communication

Education

Bachelor’s degree in computer science

Job description

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.

Associate Manager – Data Engineering

Data and Analytics team is a multi-disciplinary technology team delivering client projects and solutions across Data Management, Visualization, Business Analytics and Automation. The assignments cover a wide range of countries and industry sectors

The opportunity

We are looking for Associate Manager - Data Engineering. The main purpose 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 onshore 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.

Role Type

Data Architecture & Engineering

A Data Architect & Engineer at EY:

Uses agreed-upon methods, processes and technologies to design, build and operate scalable on-premises or cloud data architecture and modelling solutions that facilitate data storage, integration, management, validation and security, supporting the entire data asset lifecycle. Designs, builds and operates data integration solutions that optimize data flows by consolidating disparate data from multiple sources into a single solution. Works with other Information Management & Analysis professionals, the program team, management and stakeholders to design and build analytics solutions in a way that will deliver business value.

Skills

Cloud Computing, Computational Thinking and Programming, Technical Feasibility Analysis, Data Architecture Design and Modelling, Data Fabric, Data Integration, Data Quality, Data Security, Database Management, Semantic Layer

Client Handling & Communication, Problem solving / critical thinking, Systems Thinking, Interest and passion for Technology, Adaptability/Agility, Analytical Thinking, Collaboration

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 steered tools to create workflows)
• Provides technical guidance 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

• Minimum of 8 years of total experience with 5+ years in Data warehousing/ Business Intelligence and Data Modelling
• Minimum 3+ years experience in Databricks and Snowflake implementation
• Solid hands-on 5+ 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)
• Minimum 3+ years experience in Azure database offerings [Relational, NoSQL, Datawarehouse]
• Minimum of 3 years of hands-on database design, modelling and integration experience with relational data sources, such as SQL Server databases, Oracle/MySQL, Azure SQL and Azure Synapse
• Minimum of 3 years of hands-on Programming language preferably Python
• Knowledge and direct experience using business intelligence reporting tools (Power BI, Alteryx and Tableau)
• Strong creative instincts related to data analysis and visualization.
• 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 life cycle (SDLC) and rules of product development, such as installation, upgrade and namespace management
• Willingness to mentor team members
• Solid thoughtfulness, technical and problem solving skills
• Excellent written and verbal communication skills

To qualify for the role, you must have

• Bachelor’s or equivalent degree in computer science, or related field, required. Advanced degreeor equivalent business experience preferred
• Fact steered and thoughtfulness 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 7 to 9 years in a big 4 or technology/ consulting set up

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

What we look for

• 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-prominent, multi-disciplinary team of 1400 + professionals, in the only integrated global transaction business worldwide.
• Opportunities to work with EY SaT practices globally with prominent businesses across a range of industries

What we offer

EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across six locations – Argentina, China, India, the Philippines, Poland and the UK – and with teams from all EY service lines, geographies and sectors, playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants, we offer a wide variety of fulfilling career opportunities that span all business disciplines. In GDS, you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. We’ll introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career.

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success, as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

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.

Select how often (in days) to receive an alert:

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.