Data Architect - Snowflake | Salesforce to ServiceNow Transformation Job at Umanist Staffing LLC, United States

RU1sSTMxeHFNRkgreGlBQmd3UVFoK0JwNEE9PQ==
  • Umanist Staffing LLC
  • United States

Job Description

Data Architect – Snowflake | Salesforce to ServiceNow Transformation

Experience: 10+ Years
Location: North America – Remote
Job Type: Contract
Duration: 6 Months, Extendable

Role Overview

We are seeking a Senior Data Architect to provide hands-on technical leadership for a reporting transformation initiative involving Salesforce, ServiceNow, and Snowflake .

The architect will assess the current data and reporting environment, identify dependencies, define the target-state architecture, and develop a Proof of Concept (POC) using representative high-value reports.

The successful candidate will establish a repeatable technical framework that can be scaled across the broader reporting landscape while minimizing disruption to critical reporting and business processes.

Key Responsibilities

  • Lead the architecture and technical design for reporting/data transformation initiatives.

  • Design and implement Snowflake-based data architectures , including data models, ELT pipelines, security, performance, and report-ready data structures.

  • Analyze Salesforce data models, extraction methods, integrations, and reporting dependencies.

  • Understand ServiceNow data and integration concepts and support the Salesforce-to-ServiceNow reporting transformation .

  • Develop POCs using representative business-critical reports.

  • Create scalable and repeatable migration/reference architecture frameworks.

  • Define data mapping, reconciliation, migration, and integration approaches.

  • Work with APIs, CDC, ETL/ELT pipelines, and enterprise data integration patterns.

  • Assess data quality, lineage, reporting dependencies, and downstream impacts.

  • Ensure business continuity for critical reporting and billing processes during migration.

  • Collaborate with Business Analysts, Reporting Analysts, client SMEs, and Technical SMEs.

  • Communicate architecture decisions, risks, and technical trade-offs to both technical and business stakeholders.

  • Provide hands-on technical leadership while working independently in an evolving environment.

Required Technical Skills

Must Have:

  • 10+ years of experience in Data Engineering, Data Architecture, Analytics Architecture, or Enterprise Data Transformation.

  • Strong hands-on Snowflake architecture and data engineering experience.

  • Strong SQL skills.

  • Strong experience with data modelling and ELT/ETL.

  • Experience with Snowflake security and performance optimization.

  • Experience building report-ready data structures.

  • Strong understanding of Salesforce data models and extraction/integration patterns .

  • Working knowledge of ServiceNow data and integration concepts .

  • Experience with enterprise data integration and migration.

  • Experience with APIs and/or CDC.

  • Experience with data mapping, reconciliation, and migration patterns.

  • Experience designing POCs, reference architectures, and scalable migration frameworks .

  • Strong understanding of reporting-oriented data architecture, data quality, lineage, and dependencies.

Preferred Experience

  • Salesforce-to-ServiceNow reporting or data transformation experience.

  • Large-scale legacy-to-modern platform migration.

  • Enterprise reporting transformation.

  • Snowflake modernization initiatives.

  • Experience working with critical downstream reporting or billing systems.

  • Experience establishing reusable architecture patterns/frameworks.

Job Tags

Contract work, Remote work

Similar Jobs

Tasca Ford Berlin

Parts Counter Person Job at Tasca Ford Berlin

Parts Counter PersonLocation: Berlin, CTCompany: Tasca Ford BerlinJob Type: Full-timeTasca Ford Berlin is looking for a Parts Counter Person to join our team. In this role, youll help customers and technicians find the right parts while delivering a high level... 

Johns Hopkins Medicine

RN - Radiation Oncology Therapy Job at Johns Hopkins Medicine

 ...cancer specialists at Sibley Memorial Hospital provide surgical, radiation and medical oncology and inpatient oncology services in...  ...Here. Join the world-renowned Johns Hopkins Proton and Photon Therapy program as a Radiation Oncology RN. Work alongside distinguished... 

Bilfinger

Blaster/Painter Job at Bilfinger

 ...communicate in a professional manner with customers. # Other related duties may be assigned. Qualifications # No previous experience is required # Knowledge of all components of a standard equipment package and the ability to describe its function is... 

Elevenlabs

Remote Account Executive - Japan Job at Elevenlabs

 ...hubs, we offer a monthly co-working stipend. About the role Were looking for an Account Executive to scale our business in Japan a highly motivated self-starter who is passionate about voice AI and how its transforming the way businesses build and engage... 

Merck & Co.

Sr. Specialist, Learning & Development (Remote - US) Job at Merck & Co.

Job DescriptionOur US Ophthalmology team is committed to transforming the lives of patients living with diabetic macular edema (DME) and neovascular age-related macular degeneration (nAMD) with a portfolio of two products in the pipeline. We aspire to achieve this through...