EYP-DNA-Assistant Manager

Assistant Manager – Carvex

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 Assistant Manager – for financial sector under Sell and Separate practice. The main purpose of the role is to support complex transaction and carve-out analytics engagements by leveraging financial data modelling, reconciliation, and advanced analytics capabilities.

The role will involve working across the end-to-end CARVEx lifecycle including data ingestion, transformation, modelling, reporting, and advanced analytics to generate decision-ready financial views.

This role will work closely with cross-functional teams including finance, transaction stakeholders, and technology teams to deliver scalable, cloud-based analytics solutions leveraging modern Azure data platforms and AI-enabled capabilities.

This role will be instrumental in designing, developing, and evolving modern financial data warehousing solutions and integration frameworks tailored for carve-out transactions, leveraging cutting-edge tools and platforms across both on-prem and cloud environments. In this role, you will define data models, financial mapping logic, and documentation to support the extraction, transformation, and allocation of financial statements (P&L, Balance Sheet, Cash Flow) for carve-out scenarios.

Discipline 

Information Management & Analysis

Role Type

A Data Engineer (technofunctional role)in CARVEx

Uses agreed-upon methods, processes and technologies to design, build and operate scalable data solutions that support financial carve-outs. Enables integration, validation, reconciliation, and reporting of complex financial datasets while delivering meaningful business insights. Works with stakeholders to build analytics solutions that drive transaction decision-making and business value.

Skills

• SQL, Python, Power BI, Azure Platform – Azure data explorer, Azure Data factory, Azure Databricks, Cloud Computing, Programming, Data Modelling, Data Integration, Data Quality, Database Management,
• Agentic architectures like langraph/n8n/autogen, experience with vector databases and tuning the database queries and LLMs
• Client Handling & Communication, Problem solving / critical thinking, Interest and passion for Technology, Adaptability/Agility, Analytical Thinking, Collaboration

Your key responsibilities

• Design and develop scalable data models and pipelines supporting carve-out financial reporting (P&L, Balance Sheet, Cash Flow)
• Perform data ingestion, transformation, and integration from multiple financial systems (GL, ERP, trial balance)
• Execute data validation, reconciliation, and audit-trail alignment with financial statements
• Build interactive dashboards and reports using Power BI and other visualization layers
• Conduct advanced analytics (financial variance, margin analysis, KPI-driven insights) for transaction support
• Develop and maintain robust data warehousing layers (staging, transformation, reporting)
• Collaborate with cross-functional teams to understand business dimensions and financial constructs
• Evaluating data warehousing tools for business intelligence, data population, data management and metadata management
• Strong working knowledge across the technology stack including ETL, ELT, data analysis, metadata, data quality, audit and design, visualization using Power BI and Paginated reports
• Design, develop, and test in ETL tool environment (GUI/canvas steered tools to create workflows)
• Experience in design documentation (data mapping, technical specifications, production support, data dictionaries, test cases, etc.)
• Adhere to ETL/Data Warehouse development Best Practices, Visualization best practices
• Responsible for Data orchestration, ingestion, ETL and reporting architecture for both on-prem and cloud ( MS Azure)
• Assisting the team with performance tuning for ETL and database processes, reporting using excel, power bi and paginated reports
• Apply AI/GenAI-driven techniques to enhance analytics and automate insights generation
• Support POCs, solutioning, and business development initiatives
• Ability to integrate AI into BI workflows for improved insights and efficiency

.

Skills and attributes for success

• 5-8 years of total experience with 3+ years in Data warehousing/ Business Intelligence field with exposure to financial datasets
• Strong understanding of financial concepts (trial balance, consolidation, financial statements) and transforming them into technical usable solutions
• Solid hands-on 3+ 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
• Minimum 3+ year’s experience in Azure database offerings [Relational, NoSQL, Datawarehouse]
• 2+ years hands-on experience in various Azure services preferred – Azure Data Factory, Azure Data Explorer, Storage, Azure Analysis Services & Databricks
• 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
• Knowledge and direct experience using business intelligence reporting tools (Power BI, Paginated reports, Alteryx etc.)
• Strong creative instincts related to data analysis and visualization.
• Strong with Excel with exposure to advanced excel capabilities like Power Query, Power Pivots, VBA
• Curiosity to learn the business methodology, data model and user personas.
• Strong understanding of BI and ETL best practices, analysis, visualization, and latest trends.
• 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 degree
• or 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 analyzing large volumes of data
• Relevant work experience of minimum 6 to 8 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.