FS Technology Consulting - AI and Data - Data Engineer - Senior Consultant / Manager

FS Technology Consulting – AI and Data – Data Engineer -  Senior Consultant / Manager - Dublin/Cork/Limerick/Galway

General Information

Location: Dublin, Cork, Limerick or Galway. 

Available for VISA Sponsorship: NO

Business Area: Data & Analytics

Contract Type: Full Time - Permanent

EY is the only major professional services firm with an integrated Financial Services practice across Europe, the Middle East, India and Africa (EMEIA). We connect our Asset Management, Banking and Capital Markets and Insurance clients to 6,500 talented people from 12 countries and 35,000 Financial Services colleagues around the world.

In EY FS Ireland, we are expanding our Consulting practice and building our Technology Consulting team as a key component of our All In Strategy.

All In  is EY’s global strategy and ambition to create  long-term value to all stakeholders by leveraging data and technology. It is designed to integrate transformative solutions across EY’s services, ensuring a comprehensive approach to our clients’ needs.  We are actively recruiting high achieving individuals with technical data expertise within Financial Services: Banking, Insurance and Wealth and Asset Management.

We are seeking an experienced Data Engineer with a strong background in supporting business and analytics teams in Financial Services industry by designing, developing and operating robust data pipelines.  The ideal candidate will have experience in working with Azure Cloud and proficiency in using Microsoft Azure Data Services and platforms such as Azure SQL, Data Warehouse, Data Factory, Data Lakes, HDInsight and Stream Analytics. Core Azure SQL, MSSQL server. They will also have understanding of the underlying data flow architectures, will have supported finance, operations, privacy & security, compliance & regulatory projects in the past, have a functional understanding of the data sets used in the relevant business domain(s) they supported, as well be adept at data sourcing, data wrangling, issue gap and root cause analysis, ETL and implementing data solutions for effective process change and improvement strategies. Experience is agile software delivery is a must.

Your Key Responsibilities

• Design, implement, and manage robust data pipelines and solutions for core systems and applications.
• Collaborate with IT and business teams to understand business and technical requirements in order to identify, prioritise and document data requirements for management and business insights.
• Design, build, and maintain data solutions that transform raw data into structured formats suitable for analytics.
• Develop and manage ETL processes to ensure effective and efficient data ingestion and transformation.
• Analyse and conduct gap analysis in existing data architectures to identify impact areas and design solution options.
• Conduct thorough analysis of existing data processes and systems, identifying areas for improvement. Work closely with Data Stakeholders (e.g. Product and System Owners, Technical Leads, Business and Change Leads, Data and Solution Architects) to communicate and influence implementation of the identified technical enhancements.  
• Lead performance optimisation identification of data pipeline bottlenecks and areas for improvement. Optimise query performance in data storage solutions and implement best practices for data processes and transformations to enhance the efficiency of ETL workflows.
• Implement security measures to protect sensitive data throughout the data lifecycle, including encryption, access controls, and data masking.
• Ensure compliance with data governance policies and regulatory requirements, such as GDPR or HIPAA.
• Monitor data quality and integrity throughout the transformation process, implementing controls and fixes as needed and maintaining compliance with the organisation’s Data Governance and Data Management policies and procedures.
• Design data architecture that can scale horizontally and vertically to accommodate growing data volumes and user demands.
• Utilise Azure services that support auto-scaling and load balancing to ensure data solutions can handle peak loads.
• Support the design and implementation of integrated technology solutions with data expertise, ensuring alignment with business goals and compliance with internal and external policies, procedures and regulations.

To qualify for the role, you must have:

• Bachelors' degree in Data Science, Analytics, Information Technology, Computer Science, Statistics, Mathematics, Quantitative Economics, Engineering, or equivalent professional education.
• Minimum of 3 years’ experience in a  Data Engineering role with a blue-chip consulting firm or in the Data Office: Data Engineering function of  a multinational organisation or a large financial services institution.
• Experience working with the Microsoft’s Data Ecosystem and Azure Cloud (e.g. Data Warehouse, Data Factory, Data Lakes, Azure Purview, Azure Synapse Analytics, HDInsight and Stream Analytics. Core Azure SQL, MSSQL server).
• Experience with Data Integration and ETL Tools; e.g. Azure Data Factory or Azure Logic Apps.
• Experience in Continuous Integration & Continuous Delivery (CI/CD) and relevant tools, e.g. Azure DevOps/ Azure Pipelines, GitHub, Jenkins, Terraform, Ansible, CircleCI.
• Familiarity with one or more business domains: finance, operations, privacy & security, regulatory & compliance.
• Knowledge of typical data management and governance frameworks and compliance requirements.
• Relevant Data Engineering certifications, e.g.  Microsoft Certified: Azure Fundamentals , Microsoft Certified: Azure Data Engineer Associate, Azure Database Administrator Associate etc.
• Experience with Agile methodologies and a proven track record of delivering data solutions in an Agile environment.
• Excellent analytical, problem-solving, and decision-making skills.
• Relevant work experience in multi-stakeholder environment. Strong communication and interpersonal skills, with the ability to engage effectively with both technical and non-technical stakeholders.
• Team centric mindset, always ready support their colleagues and not afraid to ask for help when needed.
• Understanding and respect for client and team deadlines, great organisation skills and ability to organise and prioritise own work to achieve the delivery objectives.

Ideally, you will also have:

• Experience working with Financial Services clients (Banking, Insurance or Wealth and Asset Management) is preferred.
• Ability to deal with ambiguity and uncertainty.
• Growth and continuous learning mindset.
• Be able to conduct workshops and stakeholder interviews.
• Ability to build and manage relationships across business and technology stakeholders.
• Financial Services industry background or experience as a bonus.
• Preparation and delivery of MI/ BI reporting in Power BI or SAS a bonus.
• Snowflake experience a bonus.

What working at EY offers

We offer a competitive remuneration package. Our comprehensive Total Rewards package includes support for flexible working and career development, and with FlexEY you can select benefits that suit your needs, covering holidays, health and well-being, insurance, savings and a wide range of discounts, offers and promotions. Plus, we offer: 

• Support and coaching from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career.
• The freedom and flexibility to handle your role in a way that’s right for you.

All our employees are given a benefits package which they can tailor to suit their individual preferences. Our range of benefits include:

• Pension
• Discounted Health Insurance
• Web Doctor – Free unlimited online GP Consultations for you and your family
• The purchase of additional annual leave
• Hybrid Working
• Free Gym Membership
• Travel Pass
• Maternity & Paternity Leave
• Bike to Work Scheme
• Recognition Awards
• Cash incentives for Referrals
• Work Mobile
• Tech MBA paid by EY
• Wellness rooms available in some offices

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.

Career Progression:

• When you join EY, you will be supported to ensure that you are enhancing your skills from day one.
• Continuous learning, where you can develop the mindset and skills to navigate whatever comes next.
• As you grow and develop here, you’ll discover opportunities to help customise your career journey, so that it’s as unique as you are - success is defined by you, we will provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership, we will give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture, you will be embraced for who you are and empowered to use your voice to help others find theirs.
• We have embraced Hybrid working at EY adding greater flexibility and autonomy to the roles of our employees.

About EY

As a global leader in assurance, tax, transaction and advisory services; we’re using the finance products, expertise and systems we’ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime.

Inclusion & Diversity

We hold a collective commitment to foster an environment where all differences are valued and respected, practices are equitable and everyone experiences a sense of belonging: Inclusion, diversity, and equity are part of who we are at EY. We believe that the highest-performing teams maximize the power of different perspectives and backgrounds. These teams are both diverse and inclusive and are willing to invite and learn from other perspectives. Our ability to include various viewpoints into our mindsets, behaviours and operations is fundamental to driving innovation, building strong relationships, and delivering the best solutions for our clients.

We recognise the strength that comes from having a diverse workforce and building a culture where we support all our people to achieve their potential. You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

As an equal opportunities’ employer, we welcome applications from people of all backgrounds. Reasonable accommodations are offered at every stage of our recruitment process.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Join us in building a better working world. That’s Why, EY.

Apply now.

IMPORTANT: Where Agency assistance is required, our Talent Team will engage directly with suppliers. CVs / Profiles should not be shared directly with Hiring Managers.

Unsolicited CVs / Profiles supplied to EY by Recruitment Agencies will not be accepted for this role.