FS Technology Consulting - AI and Data - Data Engineer - Senior Consultant - Dublin
Ernst and Young1 month ago
Dublin, IrelandSenior
Responsibilities
- Design, implement, and manage scalable data pipelines and data solutions for core systems and applications.
- Collaborate with IT, business, product, systems, architecture, and change stakeholders to identify and document data requirements.
- Build and maintain data models, ETL processes, and transformations that convert raw data into analytics-ready structures.
- Analyze existing data architectures and processes, conduct gap and root-cause analysis, and design improvement options.
- Optimize data pipeline performance, query performance, data storage, and ETL workflows.
- Implement data security, access controls, encryption, data masking, governance controls, and regulatory compliance measures.
- Monitor data quality and integrity and implement controls and remediation fixes.
- Design scalable data architectures and integrated technology solutions aligned with business and compliance requirements.
- Design and implement reporting frameworks for timely and accurate financial status reporting.
- Support client workshops, stakeholder interviews, technical enhancements, and delivery in an Agile environment.
Requirements
- Bachelor’s degree in Data Science, Analytics, Information Technology, Computer Science, Statistics, Mathematics, Quantitative Economics, Engineering, or equivalent professional education.
- At least 3 years of experience in a Data Engineering role within consulting, a multinational organization, a Data Office, a Data Engineering function, or a large financial services institution.
- Advanced SQL skills, including complex data manipulation, joins, subqueries, and performance tuning.
- Experience with one or more cloud platforms, including Microsoft Azure, AWS, or Google Cloud Platform.
- Experience with data platforms such as Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, Snowflake, or Databricks.
- Experience with CI/CD tools such as Azure DevOps, Azure Pipelines, GitHub, Jenkins, Terraform, Ansible, or CircleCI.
- Familiarity with financial, operational, privacy, security, regulatory, or compliance business domains.
- Knowledge of data management, data governance, and regulatory compliance frameworks.
- Experience delivering data solutions using Agile methodologies.
- Familiarity with Python, commonly used Python libraries, and Python data types.
- Strong analytical, problem-solving, communication, organization, stakeholder management, and decision-making skills.
- Financial services experience in banking, insurance, wealth management, or asset management is preferred.
- Power BI or SAS reporting experience and Snowflake experience are additional advantages.
- Ability to conduct workshops, interviews, and relationship management across business and technology stakeholders.
Benefits
- Full-time permanent employment in Dublin with hybrid and flexible working arrangements.
- Competitive remuneration package with flexible benefits selection through FlexEY.
- Pension, discounted health insurance, free unlimited online GP consultations, and wellness rooms in some offices.
- Additional annual leave purchase, free gym membership, travel pass, bike-to-work scheme, and maternity and paternity leave.
- Recognition awards, referral cash incentives, work mobile, and an EY-paid Tech MBA.
- Career development, coaching, continuous learning, skills development, and career progression opportunities.
- Client-facing work may require regular travel or working at client sites.
Tech Stack
Amazon RedshiftAnsibleApache SparkAWSAzureCircleCIDatabricksGoogle BigQueryGoogle CloudGoogle Cloud PlatformJavaJenkinsMicrosoft SQL ServerMLflowPythonSassScalaSnowflakeSQLTerraform
Categories
Data Engineering
About Ernst and Young
Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.