Data Architect – Snowflake | Salesforce to ServiceNow Transformation

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.