Data Architect

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)