Snowflake Data architect

Mphasis
Manchester
1 day ago
Create job alert

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.
  • Soft Skills
  • 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.

Related Jobs

View all jobs

Snowflake Data Architect

Senior Data Engineer

Data Architect Snowflake

Head of Data Science

Data Engineer

Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.

Data Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.

Why Data Science Careers in the UK Are Becoming More Multidisciplinary

Data science once meant advanced statistics, machine learning models and coding in Python or R. In the UK today, it has become one of the most in-demand professions across sectors — from healthcare to finance, retail to government. But as the field matures, employers now expect more than technical modelling skills. Modern data science is multidisciplinary. It requires not just coding and algorithms, but also legal knowledge, ethical reasoning, psychological insight, linguistic clarity and human-centred design. Data scientists are expected to interpret, communicate and apply data responsibly, with awareness of law, human behaviour and accessibility. In this article, we’ll explore why data science careers in the UK are becoming more multidisciplinary, how these five disciplines intersect with data science, and what job-seekers & employers need to know to succeed in this transformed field.