EY UKI TAS - Transaction Analytics Manager in Ireland
Title: UKI TAS - Transaction Analytics Manager
Job Number: IRE001Q0
Senior Executive (Manager) - Transaction Analytics
EY’s Transaction Analytics team helps to bring faster, better and deeper insights in the deal environment. Be it pre or post-merger, the team is responsible for deploying industry-leading analytics and innovation, providing valuable insights to executives making strategic and operational decisions about their businesses. It forms part of the Valuations & Business Modelling group, a UK market leader with a very successful international business. We are now looking to build on previous success and strengthen the Transaction Analytics team at the Senior Manager level across our Transaction Advisory Services practise.
We work with major corporate and private equity clients, investment banks, large central government departments and other public sector bodies, advising them on complex strategic, commercial, financial and operational decisions.
Our projects often involve managing multiple stakeholders and high degrees of complexity and uncertainty under tight time frames. Decision making in this environment requires strong client management and communication skills, rigorous analytical techniques and excellent data handling skills.
Our client work typically involves constructing purpose built databases applicable to the transaction in question, using data preparation tools such as Alteryx and statistical tools, to derive insight through forecasting calculations and simulations, supported by data visualisation tools for example: Tableau, Spotfire, Qlikview, PowerPivot & Power BI, often in a fast moving transaction environment.
Although the TAS Analytics team is largely London-based, we operate as a national team and many of our engagements involve multi-national clients. This role will require some travel within the UK and could require overseas working.
Actively involved throughout the life-cycle of an assignment – requirements definition, specification, data collection, solution design, development, documentation, implementation and user training
Designing and building complex database models to perform analysis on large diverse datasets
Working directly with clients as well as other EY specialist teams
Manages clients expectations in relation to deliverables
Identifies risk on the assignment, involving Director / Partner appropriately in its resolution
Sets and agrees budgets and produces project plans and progress reports, keeping seniors on the assignment informed of status
Professional development of other team members including feedback to others, identifying potential areas for improvement and good practice features
Helps the group achieve target fees by assisting in proposal development and other selling initiatives
Qualification in Computer Science, Operational Research, Statistics, Mathematics, Engineering or highly numerate science
Strong experience in SQL Server, MS Access and MS Excel is required, plus at least one other SQL dialect (e.g. Postgresql, Oracle PLSQL, MySQL).
Highly numerate with a strong technical knowledge and experience of applying analytical and modelling techniques to provide insights to business issues
Experience in applying analytical techniques, to calculate problems such as predictive forecasting, prescriptive action, capacity planning
Programming experience in VB, VBA, TSQL stored procedures
Ability to work with clients and model users to identify their particular needs, to design appropriate solutions to load data, perform complex calculations, derive corollaries and deliver interfaces tools to provide repeatable visual output
Strong oral and written communication skills
Who we are
EY is committed to being an inclusive employer and we are happy to consider flexible working arrangements. We strive to achieve the right balance for our people, enabling us to deliver excellent client service whilst allowing you to build your career without sacrificing your personal priorities. While our client-facing professionals can be required to travel regularly, and at times be based at client sites, our flexible working arrangements can help you to achieve a lifestyle balance.