Data Engineer

Applications from London will be accepted

Overview

Roles within our RS EMEA Data (Satellite) team will orchestrate client's data onto their RS EMEA data environment and respective tenancy using the support, data and technical patterns and artefacts from RS Data Platform (Hub).

The Data Engineer will play a critical role in designing, developing, and implementing enterprise-wide data solutions. The position focuses on building scalable and reliable data pipelines, data integrations, and models to meet both internal and external customer needs. A strong mix of technical expertise, problem-solving skills, and business acumen is essential.

Key Accountabilities and main responsibilities

Strategic Focus

1. Contribute to the development of advanced data engineering capabilities.
2. Apply software engineering principles and database design to create scalable data pipelines, integrations, and models.
3. Transform raw data into accurate, reusable datasets with a combination of technical expertise and business insight.
4. Actively participate in driving a data-driven decision-making culture across the organisation.

Operational Management

1. Design, develop, and optimise data solutions leveraging Snowflake, Fivetran, and DBT Cloud.
2. Build robust data pipelines to ingest, transform, and load data into Snowflake using Fivetran and other ETL/ELT tools.
3. Develop modular and reusable transformation models using DBT Cloud to maintain a clean, structured data warehouse.
4. Implement advanced SQL solutions for data aggregation, transformation, and analysis in Snowflake.
5. Ensure high data quality by implementing data validation techniques and monitoring pipelines for failures or inefficiencies.
6. Utilise best practices for data warehousing, including dimensional and relational modelling.
7. Execute against the Data and Analytics roadmap, focusing on the adoption of new capabilities and optimisation of existing systems.

Collaboration & Stakeholder Engagement

1. Collaborate with cross-functional teams, including analysts, data scientists, and business stakeholders, to define actionable data solutions.
2. Partner with other engineers to improve foundational data models and accelerate insights delivery.

Governance & Risk

1. Adhere to data design and governance best practices.
2. Maintain compliance with organisational standards, policies, and procedures.
3. Develop and maintain comprehensive documentation for data definitions, processes, and pipelines.

Required Capabilities

Technical Expertise

1. Strong hands-on experience with Snowflake, including:
2. Data modelling, schema design, and performance optimisation.
3. Writing and optimising SQL for large-scale datasets.
4. Working with Snowflake-specific features like time travel, cloning, and zero-copy cloning.
5. Proficiency in Fivetran for data ingestion and management.
6. Connecting various source systems to Snowflake.
7. Monitoring and troubleshooting data pipeline issues.
8. Expertise in DBT Cloud for data transformation:
9. Building modular DBT models with Jinja templating.
10. Using hooks, and testing frameworks.
11. Managing projects with version control and CI/CD pipelines.
12. Strong knowledge of ETL/ELT processes and best practices.

Other Tools and Skills

1. Experience with version control systems like Git.
2. Understanding of cloud-native technologies, particularly in Azure or AWS environments.

Experience & Personal Attributes

Experience

1. 7-10 years of experience in data engineering or related fields.
2. Minimum 3-5 years of hands-on experience working with Snowflake, Fivetran, and DBT Cloud.
3. Proven experience designing and implementing data warehouses using modern cloud architectures.
4. Expertise in data pipeline monitoring and troubleshooting.
5. Familiarity with data governance frameworks and data cataloguing tools.

Attributes

1. Excellent problem-solving skills with a proactive approach to identifying and resolving issues.
2. Effective communication skills to collaborate with global teams and non-technical stakeholders.
3. Quality-oriented mindset with a strong attention to detail.
4. Commitment to continuous learning and staying at the forefront of technology trends.
5. Strong business product knowledge in UK Pensions and/or UK Financial Services Markets.
6. Strong business acumen and passion for current, new and emerging technologies to enable and rollout to the business to improve customer experience.
7. Identify and mitigate security risks and ensure IT security design and delivery.
8. Exceptional skills in influencing and driving change across the organisation.
9. Excellent verbal and written communication skills.
10. Expresses ideas effectively in individual and group situations; uses and shares information resources effectively.
11. Ability to adapt communication techniques to suit the needs of different individuals.
12. Ability to prioritise, organise and plan and to meet demanding deadlines.

About Us

MUFG Pension & Market Services is a global, digitally enabled business that empowers a brighter future by connecting millions of people with their assets - safely, securely and responsibly.

Through our two businesses MUFG Retirement Solutions and MUFG Corporate Markets, we partner with a diversified portfolio of global clients to provide robust, efficient and scalable services, purpose-built solutions and modern technology platforms that deliver world class outcomes and experiences.

A member of MUFG, a global financial group, we help manage regulatory complexity, improve data management and connect people with their assets, through exceptional user experience that leverages the expertise of our people combined with scalable technology, digital connectivity and data insights.

About the Team

Our MUFG Retirement Solutions division combines its proprietary technology, process and people to deliver a comprehensive financial data solution to its superannuation clients. We support clients across all superannuation fund sectors including government, industry, retail and corporate.

By accompanying our core member and employer administration with a full range of value-added services, we offer the most comprehensive superannuation administration solution on the market. The scale, adaptability and ease of use of our proprietary systems, in conjunction with our integrated analytics offering, allow us to innovate and grow with the needs of our clients.

MUFG Pension & Market Services is building a dynamic, client focused, caring and inclusive culture that is built on the foundations of an entrepreneurial spirit, effective risk management, empathy and trust, and underpinned by its core values.

We are an inclusive employer whose people work collaboratively. We encourage, support and value the various talents and perspectives of our people and promote a flexible and blended work environment where our people can thrive and their wellbeing is supported. We know that diversity drives better client outcomes, continuous improvement, and growth. Be part of the MUFG Pension & Market Services journey and together we will achieve our full potential.

We treat all individuals fairly and equitably and do not discriminate on the basis of diverse characteristics including, but not limited to gender, gender identity, sexual orientation, age, ethnicity, cultural background, physical abilities/disabilities, religious or political belief, marital or family status or carers responsibilities.

Candidates must have the relevant work rights to be considered for an opportunity at MUFG Pension & Market Services. Successful applicants will be required to complete background screening prior to commencement of employment.