Data Architect

Response Informatics; Manchester; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading data solutions company is seeking a Data Architect in Manchester to analyze financial systems and manage data migration processes. The role involves defining mappings and executing ETL/ELT for Snowflake-based platforms, ensuring quality in data handling. Ideal candidates should possess strong SQL skills and data mapping experience, preferably in financial services. The position offers a hybrid work model, requiring 3 days in the office.

Qualifications

• Strong hands-on experience in data mapping, migration, and transformation projects.
• Proven expertise with Snowflake and SQL in large-scale data environments.
• Solid understanding of relational databases and data modeling concepts.

Responsibilities

• Analyze existing financial and investment systems to understand current data structures.
• Define and maintain source-to-target mappings and transformation rules.
• Design and execute data migration and ETL/ELT processes.

Skills

Data mapping

Snowflake

SQL

Data quality management

Investment Banking

Analytical and problem-solving

Tools

ETL/ELT processes

Python

Java

Job description

Role : Data Architect

Location : Manchester, UK(Hybrid) - 3 days in office

Mode Of Employment – Full time / Permanent

Key Responsibilities

• Analyze existing financial and investment systems to understand current data structures and conversion needs
• Define and maintain source-to-target mappings , transformation rules, and data definitions for Snowflake-based platforms
• Design and execute data migration and ETL / ELT processes , ensuring consistency and quality of migrated data
• Work closely with business analysts, system owners, and technical teams to gather, validate, and refine data requirements
• Perform data validation, reconciliation, and issue resolution during migration and testing phases
• Support testing activities including unit testing, system integration testing, and UAT by validating migrated datasets
• Create and maintain documentation such as mapping specifications, data dictionaries, conversion plans, and data flow diagrams
• Ensure compliance with applicable financial regulations, PCI DSS standards, and data privacy policies
• Provide post-migration support, including defect resolution and data process optimization

Required Skills & Experience

• Strong hands-on experience in data mapping, migration, and transformation projects
• Proven expertise with Snowflake and SQL in large-scale data environments
• Solid understanding of relational databases and data modeling concepts
• Experience with data quality management , validation, and reconciliation techniques
• Background in Investment Banking or Financial Services domains
• Ability to clearly document complex data logic and communicate effectively with stakeholders
• Strong analytical and problem-solving skills with attention to detail

Nice to Have

• Experience with large enterprise or regulatory-driven data transformation programs
• Exposure to dbt or modern ELT frameworks
• Knowledge of scripting languages such as Python or Java
• Familiarity with cloud-based data ecosystems (e.g., S3, Databricks)