FS Technology Consulting - AI and Data - Data Engineer - Senior Consultant - Dublin

Job description

At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. FS Technology Consulting – AI and Data – Data Engineer - Senior Consultant - Dublin General Information Location: Dublin Available for VISA Sponsorship: Yes 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 and scalable 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 data models and 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, BCBS239, IFRS9, IRB 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. 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 Skills and Attributes for Success To qualify for the role, you must have: Experience in one or more of the following Cloud Platforms: Microsoft Azure: Core Azure SQL and MSSQL server Deep understanding of Azure-native services for data engineering. Experience with Azure Key Vault, Azure Monitor, and RBAC. AWS: Experience with S3, Glue, Redshift, and Lambda. Familiarity with IAM, CloudWatch, and Athena. Google Cloud Platform (GCP): Experience with BigQuery, Cloud Storage, and Dataflow. Familiarity with Cloud Functions, IAM, and Vertex AI (optional). Experience in one or more of the following Data Platforms: Microsoft: 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 modelling Understanding of Azure Functions and Logic Apps for automation. Snowflake: 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. Databricks: 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. Successful applicants should also possess: 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. 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 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. Familiarity with Python and the most widely used Python libraires as well as datatypes such as: Dictionaries, Lists, Arrays, Strings 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 we look for Someone who is passionate about reaching their full potential and excelling in their career Someone with energy, enthusiasm and courage who enjoys solving complex problems and variety in their day-to-day working life Someone who enjoys working as part of a community which values integrity, respect, teaming, and inclusiveness 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 is 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 are using the finance products, expertise, and systems we have 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 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. Are you 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.