TD-Analytics-Associate Manager

Ernst & Young Advisory Services Sdn Bhd; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

EY Global Delivery Services in India is seeking an Associate Manager for Transaction Analytics within SaT. You will lead transaction analytics for financial due diligence and data visualization, using Alteryx, Power BI, SQL, and Excel in buy-side and sell-side engagements.

The role offers mentoring, exposure to a broad scope of engagements, and regional travel opportunities as needed.

Qualifications

• 6-8 years of hands-on data mining, ETL and visualization experience.
• Strong SQL and DAX knowledge; proficient in relational data sources.
• Experience with BI tools in financial due diligence or FP&A context.

Responsibilities

• Lead transaction analytics engagements using Alteryx, Power BI, SQL; hands-on Excel pivot tools.
• Manage large volumes of transactional data; identify outliers and trends.
• Translate business problems into technical requirements and work plans.
• Review BI design specs; develop dashboards and reports.
• Mentor team members, support L&D, ensure quality service delivery.

Skills

Data mining

ETL processes

Visualization

SQL

DAX

Excel

Education

B.Tech with Finance/Analytics background

MBA in Finance/Business Analytics

Tools

Alteryx

Power BI

Power Pivot

Power Query

SQL

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.

GDS SaT – Associate Manager – Transaction Analytics

Within SaT, Transaction Diligence (TD) services encompass the strategic development and execution of an appropriate transaction structure, which includes execution of financial due diligence, IPOs and restructuring of banking loans. Our team works to understand profit drivers and trends, assumptions of future performance, and assists with purchase agreements and post-closing transaction matters. TD professionals work on buy-side diligence and provide sell-side diligence services. This helps clients maximize value, mitigate risks and achieve their strategic goals, in acquisition and divestiture deals.

The opportunity

We’re looking for an Associate Manager with expertise in using BI / analytics tools for Financial Due Diligence, transaction analytics, data mining and visualization skills working with a public accounting firm and/or mergers and acquisitions transactions experience or experience in the field of financial planning and analysis. This is a fantastic opportunity to be part of a prominent firm and develop your career through a broad scope of engagements, mentoring, and learning & development.

Your key responsibilities

• Lead and work on transaction analytics engagements using Alteryx, Power BI, Power Pivot, Power Query, DAX, SQL queries along hands‑on experience in Excel, formulas, pivot tables etc
• Ability to manage large volume of transactional data, identify outliers, trends and key findings
• Understand sector specific analysis like churn analysis, retention analysis, cohort, SKU analysis, Market basket, price volume, cash collection analysis etc.
• Author and review of BI design specifications; develop, review and unit test reports, dashboards and other visualizations as part of solutions
• Execute, or provide expert advice related to data modelling and data preparation
• Translate high‑level business problems into a concrete technical requirements and work plans.
• Counsel team members on the project on KPIs, key financial drivers,
• Actively participate in ideation of new analytics services, new tools in automation and analytics
• Drive regional growth by establishing strong working relationship with the assigned region
• Support in team admin, project allocation and reporting activities
• Support L&D activities to drive learning of new skills in the team
• Ensures that team members deliver quality service as per client’s needs and priorities
• Measure, monitor and improve client service by guiding team members and driving excellence in service delivery
• Focus teams on the key priorities while managing several large to medium‑size projects
• Ensuring smooth service delivery within the defined geographical area
• Help team in scoping, feasibility and estimating the efforts of a project request.
• Reviews quality of deliverables, in terms of accuracy of research findings, presentation of data, logical reasoning of analysis done.
• Identifies, develops and implements best practices in projects.
• Manages efficiency and productivity of team members on a day‑to‑day basis. Ensures adherence to SaT work‑flow protocol and tools.
• Demonstrates and applies in‑depth subject knowledge to deliverables and has general understanding of other‑related disciplines
• Proactively participate in research approach identification and execute it to produce outputs contributing to the overall project.
• Provide expert reviews for all projects within the assigned subject

Skills and attributes for success

• 6-8 years of Hands‑on experience in Data mining, ETL and Visualization tools. Good understanding of writing SQL, DAX functions
• Minimum of 2 years of database design, modelling and integration experience with relational data sources, such as SQL Server databases
• Strong technical skills in performing data analysis, data transformation, and ability to learn new tools and technologies emerging in the area of data mining and visualization.
• Strong analytical and interpersonal skills
• Effective written and verbal communication skills
• Strong drive to take new initiatives and ability to adapt to new situations and ideas
• Advanced knowledge and experience in any of the following sectors will be an added advantage – Financial Services, Oil and Gas, Technology, Consumer Products, Power and Utilities and Life Science
• Excellent communication, organizational, interpersonal and teaming skills.
• Willingness to travel, when necessary

To qualify for the role, you must have

• B.Tech with strong finance / transaction analytics background OR MBA in Finance/business analytics from a premier institute with 4-6 years of experience
• Relevant experience working in analytics , technology and innovation firm and/or mergers and acquisitions transactions experience or experience in the field of financial planning and analysis

Ideally, you’ll also have

• Strong communication and presentation skills

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‑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

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.