Snowflake Data architect

5 days ago

Manchester, New Hampshire, United Kingdom DNS Info Ltd Full time

FullTime Role.

Mode:
3 days onsite required every week.

Yrs of exp:
10 -18 years

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.

  • Data Architect

    3 days ago

    Manchester, New Hampshire, United Kingdom Response Informatics Full time

    Role: Data ArchitectLocation: Manchester, UK(Hybrid) - 3 days in officeMode Of Employment – Full time/ PermanentKey ResponsibilitiesAnalyze existing financial and investment systems to understand current data structures and conversion needsDefine and maintain source-to-target mappings , transformation rules, and data definitions for Snowflake-based...

  • Architect (Data Platform), 100k + 10 bonus

    2 weeks ago

    Manchester, New Hampshire, United Kingdom Morson Edge Full time

    About the companyGreat opportunity for an Architect with experience of designing and building Data Platforms to join a leading FinTech business in Manchester at the beginning of a major modernisation of its data landscape.The business is investing heavily in next-generation cloud and data capabilities, with a strong commitment to best-in-class governance,...

  • Snowflake Developer

    3 days ago

    Manchester, New Hampshire, United Kingdom iXceed Solutions Full time

    Mandatory SkillsPossess good knowledge in Cloud computingVery good working knowledge in data models viz Dimensional Data Model ER Data Model and Data VaultVery good working knowledge in writing SQL queriesVery good working knowledge in Snowflake ArchitectureVery good working knowledge in Snowflake internals like Snowflake Roles dynamic tables streams and...

  • Reltio MDM Technical Architect

    3 days ago

    Manchester, New Hampshire, United Kingdom LTIMindtree Full time

    LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies.Looking for a Senior Reltio MDM Technical ArchitectRole OverviewWe are seeking a skilled Technical Architect with deep expertise in...

  • Data Architect

    2 weeks ago

    Manchester, New Hampshire, United Kingdom Capgemini Full time €60,000 - €120,000 per year

    GET THE FUTURE YOU WANTChoosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the...

  • Senior Data Architect

    3 days ago

    Manchester, New Hampshire, United Kingdom Morson Edge Full time

    Senior Data Architect - ConsultancyI'm partnered with a leading consultancy that's delivering cutting-edge data and technology solutions for their clients. They're looking for a Senior Data Architect to join their team in Manchester or London on a permanent, full-time basis.This is a hybrid role, with 1–2 days per week in the office or client site.As a...

  • ServiceNow Architect

    2 days ago

    Manchester, New Hampshire, United Kingdom Infoplus Technologies UK Limited Full time

    ServiceNow Certified Technical Architect (CTA)contract opportunity.Please find the details below:Role:ServiceNow Certified Technical Architect (CTA)Location:Northwest England / Yorkshire & Humber (Manchester, Leeds, Blackpool) – Hybrid (3 days Onsite in a week)Contract Type:12 months (With potential extension)Clearance:SC clearance Eligible will work...

  • Permanent Opportunity

    5 days ago

    Manchester, New Hampshire, United Kingdom Alphayotta Full time

    Job Title: Snowflake Data ArchitectLocation: ManchesterWork Type: PermanentHybrid work – 3 days a week onsite mandatoryJob Summary –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...

  • Data Analyst

    1 day ago

    Manchester, New Hampshire, United Kingdom Cox Automotive Europe Full time

    Data Analyst – EU WholesaleUp to £45k base depending on experience.Location:Leeds or Manchester (Hybrid)Ready to turn data into decisions that shape the future of automotive?AtCox Automotive Europe, we're driving the digital transformation of the automotive industry. Our cutting-edge platforms empower dealers, OEMs, and buyers to make smarter, faster...

  • GCP Data Lead

    2 weeks ago

    Manchester, New Hampshire, United Kingdom LinuxRecruit Full time £80,000 - £140,000 per year

    Are you a GCP Platform Tech Lead ready to move beyond execution and directly influence the technical direction of a mission critical cloud platform?A highly respected, confidential organisation is seeking a technical leader to serve as the subject matter expert and architect for their next generation, cloud based data solutions. This is an opportunity to put...