Data Architect – Snowflake | Salesforce to ServiceNow Transformation

Umanist Staffing LLC; Deutschland; Remote; EUR 103.000 - 155.000; Vollzeit

Zusammenfassung

Umanist Staffing LLC is seeking a Senior Data Architect for a 6‑month contract to lead a Salesforce to ServiceNow reporting transformation with Snowflake at the core. The role emphasizes hands-on leadership, scalable migration frameworks, and repeatable data architectures across ELT/ETL pipelines and security considerations.

The successful candidate will model data, build POCs, ensure report-ready structures, and collaborate with SMEs and analysts to minimize disruption to critical reporting

Qualifikationen

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

Aufgaben

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

Kenntnisse

Data engineering

Data architecture

Analytics architecture

Enterprise data transformation

Snowflake architecture

SQL

Data modelling

ELT/ETL

Snowflake security

Data integration

Salesforce data models

ServiceNow data integration

APIs

CDC

POCs

Reference architectures

Migration frameworks

Data quality

Data lineage

Tools

Snowflake

Salesforce

ServiceNow

ETL/ELT tools

Jobbeschreibung

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.