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)
Seniority Level
Mid‑Senior level
Employment Type
Full‑time
Job Function
Information Technology
#J-18808-Ljbffr