EY Transaction & Analytical Modelling Experienced 

Ireland 

273682143

Strategy and Transactions (SaT)

If you understand capital and how to make it work harder, Strategy and Transactions Services will offer the career opportunities you’re looking for.

Modelling work provides the opportunity for a variety of assignments, predominantly office/home office-based; from assignments that last a few days to very large assignments working as part of a multi-disciplinary team. As no two projects are the same, the work requires a high level of adaptability, flexibility and innovation.

What will I be doing

Typical activities include the following:

• Working under the supervision of Managers, Assistant Directors, Directors or Partners within Strategy and Transactions as well as other Ernst & Young departments in both Ireland and internationally on the following assignments:
  • Transaction and Decision modelling
  • Advanced Transaction Analytics
• Working effectively as a team member by sharing responsibility, providing support, maintaining communication and updating senior members on progress.
• Understanding our client requirements, co-developing our approach with the client, and providing value to our clients through insights, factual conclusions and advice.
• Design, develop and document complex business models.
• Review Excel models under supervision and arrive at preliminary conclusions.
• Understand, manipulate and interpret financial data and client information, drawing appropriate conclusions.
• Carry out relevant analysis and present your findings (both written and orally).
• Gathering, verifying and analysing information to formulate views.
• Day to day progression of assignments to include; planning, preparing and reviewing various forms of deliverables to include reports and presentations.
• A focus on anticipating and identifying risks that require escalation and subsequently escalating these risks to more senior staff as appropriate.
• Working closely with colleagues you will ensure that work is properly executed, documented and concluded in compliance with our Quality & Risk Management guidelines.
• Actively establishing, maintaining and strengthening your internal and external relationships.
• As an influential member of the team, you will help to create a positive learning culture. You will be responsible for mentoring and developing more junior members of staff and providing constructive feedback on both a formal and informal basis.
• Maintaining and constantly upgrading technical knowledge and personal skills.

People responsibilities

• Develop network of contacts (internal & external)
• Seek regular feedback on individual assignments and regular guidance from counsellor
• Manage own time to budgets and communicate progress against plan to assignment manager
• Identifying issues and drawing to attention of Partner/Director and contributing to discussions

Technical skills requirements

• Ideally you will have an accounting qualification – CA/CFA/CIMA or equivalent; a sound grasp of FRS102/ IFRS and financial accounting, combined with a high level of business awareness and a strong understanding of the factors that drive financial performance
• Highly numerate with a sound grasp of Excel and a natural interest in using it to help clients to better understand their business or to make better business decisions
• A track record in financial modelling, experience of working in a professional services environment, and exposure to high profile transactions, would all be a distinct advantage
• Familiarity with the development or formal review of financial models is a pre-requisite
• Experience with visualisation software (e.g., PowerBI, Tableau or Qlikview), data analytics tools (e.g., Power Query, Alteryx or Azure Data Factory) and ETL processes is desirable
• Experience working with large datasets, knowledge of data warehousing concepts, and additional technical skills such as Visual Basic and/or other programming languages (e.g., SQL Python, R) would be an advantage

Additional skills requirements

• Qualified/newly qualified with ACA, ACCA or equivalent qualification
• Minimum 2.1 degree, numeric subjects preferred
• 2-4yrs relevant experience, preferably in a management consulting environment
• Strong interpersonal skills and client focus are important, as well as attention to detail and the ability to work under pressure
• Excellent verbal and written communication skills
• Demonstrates organisation and self-management skills
• Pro-actively manage own development
• Sector experience in Energy, Public Infrastructure, Health and Technology would be beneficial