Excel Power Query and VBA developer

Excel Power Query and VBA developer London, England

EY
Full Time London, England 10.56 - 12.04 GBP Today
Job description

Senior – Alternative Investment Funds Tax Technology


The team


The partnership and funds tax team at EY acts for a wide range of UK and international alternative investment funds, private equity houses and professional partnerships. The services that we deliver include partnership advisory work, UK fund reporting, deal & fund structuring and fund advisory projects. We work closely with our Private Client Services team advising principals of private equity firms and providing both personal tax compliance and advisory work in relation to their affairs. Our international network results in our team undertaking a high proportion of cross border tax services.


We are looking for a creative and innovative problem solver who enjoys using a wide variety of technology tools to develop strategic and tactical solutions for our Private Equity Funds tax engagements.


The role is highly varied and requires you to be detail orientated, a great communicator and have excellent technical skills including business analysis, data wrangling and data modelling skills.


The opportunity


This is an exciting opportunity for a motivated and ambitious individual to join EY’s Funds Tax team. The successful candidate will work as part of our integrated technology team to provide a market leading tax compliance and advisory service to our clients. You will work as part of a small, specialised technology group to maintain existing technology tools as well as contribute to the design of new builds. Although you will be positioned in a client facing role within the domain of a Big Four private equity tax team, the majority of your time will be dedicated to the continuous improvement of our technology – which will include the maintenance of existing builds and also the design and development of new and more advanced solutions.


What you will do


  • Convert complex client structures, tax rules and source client data in to data models
  • Create reports for our clients’ investors to enable them to understand our tax analysis
  • Perform data analytics on client data to identify inconsistencies and added value
  • Build, maintain and customise user friendly tools for client engagements
  • You will be client facing as well as offering technology support to the engagement team
  • Provide technology expertise on client proposals
  • Work with our tax experts to find pragmatic approaches to problems in a mixed environment of tax and data
  • Continuously research, evaluate and present new technology services and solutions that fit the business needs
  • Continuously improve and automate processes and tools


About you


The successful candidate will be detail orientated, pragmatic and a self-learner. You should also have strong communication skills and be able to explain technical issues in a clear way to non-technical users. The skills below would also be very useful – if you already have these then great but if not then we can provide training and on the job coaching.


  • You should be eager to be an expert user of Excel, Power Query (M), Power Pivot (DAX) and VBA.
  • Excel modelling/development experience
  • Data modelling experience
  • Experience of improving and automating processes
  • Nice to have:
    • Basic web programming (e.g. HTML, CSS)
    • Understanding of accounting and tax concepts


What we offer


  • 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.
  • You can read more here: https://www.ey.com/en_uk/careers/what-its-like-to-work-here


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.


About EY


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.

Excel Power Query and VBA developer
EY

Unknown / Non-Applicable
Unknown
Unknown
Related Jobs

All Related Listed jobs

Cleaners Wanted
Cleanhome Folkestone, England 11 GBP HOURLY Today

11 per hour paid directly by client after each session. Part time hours to suit. Job Types: Part-time, Permanent.

Part Time Client Advisor M/F - Heathrow Airport
Moncler London, England Today

Provides the best service, taking care of all phases of the selling ceremony: welcoming, understanding customers needs, providing support while trying the

General Labourer
Options Manchester Limited Birmingham, England 13.5 GBP HOURLY Today

Working on brand new student accommodation. Options Resourcing are looking for a Full time cleaner to start work on a project in Birmingham City Centre:

Advice and Information Team Leader
Age UK Redbridge, Barking & Havering Ilford, England 29000 GBP ANNUAL Today

Age UK Redbridge, Barking & Havering offers an Advice & Information service to support older people living in the boroughs of Redbridge, Barking & Dagenham and

Office Cleaner - Weekend - (L)
Hashtag Clean Ltd Crawley, West Sussex, South East England, England 11 GBP HOURLY Today

Hours*: Saturday/Sunday (3.5 Hours per shift) per person. Pay:* 11 to 12 Per Hour, Employed + Holiday Pay. Pay Frequency:* Paid weekly every Wednesday.