Data Engineer - Senior Consultant

About the Position

Location: Dublin, Ireland

Contract Type: Full Time - Permanent

Salary: Competitive

At EY, we are dedicated to shaping your future with confidence. Join our globally connected powerhouse of diverse teams and take your career wherever you want it to go. Help us build a better working world.

Responsibilities

• Design, implement, and manage robust and scalable data pipelines and solutions for core systems and applications.
• Collaborate with IT and business teams to understand business and technical requirements to identify, prioritize, 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 data models and ETL processes to ensure effective and efficient data ingestion and transformation.
• Analyze 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.
• Lead performance optimization, identification of data pipeline bottlenecks, and areas for improvement.
• Implement security measures to protect sensitive data throughout the data lifecycle.
• Ensure compliance with data governance policies and regulatory requirements.
• Monitor data quality and integrity throughout the transformation process.
• Design data architecture that can scale horizontally and vertically to accommodate growing data volumes and user demands.
• 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.
• Design and implement robust reporting frameworks that facilitate timely and accurate financial status reporting.

Requirements

Core Skills:

• Experience with Azure SQL and MSSQL server
• Deep understanding of Azure-native services for data engineering
• Experience with Azure Key Vault, Azure Monitor, and RBAC
• Experience with S3, Glue, Redshift, and Lambda
• Familiarity with IAM, CloudWatch, and Athena
• Experience with BigQuery, Cloud Storage, and Dataflow
• Familiarity with Cloud Functions, IAM, and Vertex AI (optional)
• Experience with Azure Data Factory for orchestrating data workflows
• Proficiency in Azure Synapse Analytics and SQL Server
• Familiarity with Azure Data Lake Storage (Gen2) and Azure Blob Storage
• Knowledge of Power BI integration and data modeling
• Understanding of Azure Functions and Logic Apps for automation
• Strong SQL skills and experience with Snowflake’s architecture (virtual warehouses, storage, cloud services)
• Proficiency in Snowflake Streams & Tasks for CDC and automation
• Experience with Snowflake Secure Data Sharing and Snowflake Marketplace
• Familiarity with Snowpark for Python/Java-based transformations
• Understanding of role-based access control, data masking, and time travel features
• Hands-on experience with Apache Spark and Databricks Runtime
• Proficiency in Delta Lake for ACID-compliant data lakes
• Experience with Structured Streaming and Auto Loader
• Familiarity with MLflow, Feature Store, and Model Registry
• Use of Databricks notebooks for collaborative development in Python, SQL, or Scala

Additional Requirements:

• Bachelor’s 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 organization or a large financial services institution.
• Proficient in SQL at an advanced level, with experience in complex data manipulation and analysis including advanced joins, subqueries, and performance tuning.
• 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.
• 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 a 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 to support their colleagues and not afraid to ask for help when needed.
• Understanding and respect for client and team deadlines, great organization skills, and ability to organize and prioritize own work to achieve the delivery objectives.
• Familiarity with Python and the most widely used Python libraries as well as datatypes such as: Dictionaries, Lists, Arrays, Strings.

Nice to 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.

We Offer

• Competitive remuneration package
• Comprehensive Total Rewards package including support for flexible working and career development
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that is right for you
• Benefits package including Pension, Discounted Health Insurance, Web Doctor, 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, and Wellness rooms available in some offices.

About the Company

As a global leader in assurance, tax, transaction, and advisory services, we are using the finance products, expertise, and systems we have developed to build a better working world. Our culture believes in giving you the training, opportunities, and creative freedom to make things better. 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.

We recognize the strength that comes from having a diverse workforce and building a culture where we support all our people to achieve their potential. You will 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.

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, behaviors, and operations is fundamental to driving innovation, building strong relationships, and delivering the best solutions for our clients.

We recognize the strength that comes from having a diverse workforce and building a culture where we support all our people to achieve their potential. You will 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.

Ready to Shape Your Future with Confidence?

Apply today to help create the best experience during the recruitment process. Please describe any disability-related adjustments or accommodations you may need.

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

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.

---

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society, and the planet, while building trust in capital markets.

Enabled by data, AI, and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy, and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network, and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

Apply now »

• Start applying with LinkedIn

• Apply Now

• Please wait...

• Connect with us

• Our locations

• My EY

• Site map

• Legal and privacy

• Labor condition applications

• Cookie Consent Manager

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.