Snowflake Data architect

Mphasis; Manchester; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading financial services company is seeking a Data Mapping Specialist in Manchester, UK. The role involves analyzing and migrating data between legacy and new systems, ensuring data integrity throughout the conversion process. Candidates should have strong SQL skills, experience with data mapping, and preferably a background in financial services. Excellent analytical and communication skills are essential. The role offers a chance to work in a dynamic environment, collaborating with stakeholders to deliver high-quality data solutions.

Qualifications

• Must have experience with data mapping and ETL processes.
• Proficiency in SQL and relational databases is required.
• Experience in financial services or investment banking is preferred.

Responsibilities

• Analyze and map data between legacy and new systems.
• Develop detailed data mapping documentation.
• Collaborate with teams to validate mapping logic.
• Design and execute ETL processes ensuring data quality.
• Support testing activities and document processes.

Skills

Data mapping experience

SQL proficiency

Data validation skills

Data architecture experience

Analytical skills

Communication skills

Attention to detail

Teamwork

Tools

Snowflake

Kubernetes

Databricks

Job description

Job Description

• Data Mapping & Migration : Experience with data mapping, data migration, and ETL (Extract, Transform, Load) processes.
• Database Knowledge : Hands‑On Proficiency in SQL, relational databases (Oracle, SQL Server, DB2), and data modeling.
• Data Quality & Validation : Skills in data validation, cleansing, and reconciliation.
• Data Architecture & Design : Experience with Data Transformation programs, creating and managing the data architecture roadmaps and designing and maintaining new and existing data schema's and designs.
• Business & Domain Knowledge : Good knowledge of Investment banking and Financial services domain.
• Regulatory Requirements : Awareness of financial regulations and data privacy laws relevant to credit card data.
• Project Management & Analytical Skills
• Requirements Gathering : Ability to work with business analysts and stakeholders to gather and document data mapping requirements.
• Problem Solving : Strong analytical and troubleshooting skills for resolving data discrepancies.
• Documentation : Experience in creating detailed mapping documents, data dictionaries, and conversion plans, Data Flow Diagrams, Epics and Features.
• Communication : Excellent verbal and written communication skills for collaborating with cross‑functional teams.
• Attention to Detail : High level of accuracy and attention to detail in data mapping and validation.
• Teamwork : Ability to work effectively in project teams, often under tight deadlines.

Nice to Have

• Prior experience in Investment banking data transformations, data mapping, or similar financial services projects is highly preferred.
• Experience with large‑scale data migration projects, especially in banking or payments industry.
• Programming Languages : Knowledge of scripting or programming languages (Python, Java, etc.) for data manipulation.
• Tools : Knowledge on Snowflake / DBT, Kubernetes, S3, Databricks etc.

Role and Responsibility

• The Data Mapping Specialist is responsible for analyzing, mapping, and migrating data between legacy and new processing systems. This role ensures the integrity, accuracy, and completeness of data throughout the conversion process, working closely with business stakeholders, IT teams, and vendors.
• Analyze existing Investment system data structures and identify mapping requirements for conversion to new platforms.
• Develop detailed data mapping documentation, including source‑to‑target mapping, transformation rules, and data dictionaries.
• Collaborate with business analysts, system owners, and technical teams to gather requirements and validate mapping logic.
• Design and execute data migration and ETL processes, ensuring data quality, consistency, and compliance with regulatory standards.
• Perform data validation, reconciliation, and troubleshooting to resolve discrepancies during conversion.
• Support testing activities, including unit, system integration, and user acceptance testing, by providing test data and validating results.
• Document conversion processes, mapping logic, and any issues encountered for future reference and audit purposes.
• Ensure compliance with PCI DSS and other relevant data privacy and security regulations.
• Provide post‑conversion support, including data issue resolution and process optimization.