Snowflake Data Architect

About the Role:

The Data Architect will provide hands-on technical leadership for the client's reporting transformation from Salesforce to ServiceNow, with Snowflake supporting the future-state data environment. The role will assess current data and reporting dependencies, define the target approach, and develop a POC using representative high-value reports. The Architect will establish a repeatable technical framework that can subsequently be scaled across the broader reporting landscape while minimizing disruption to critical business processes.

Technical Competencies:

1. Strong Snowflake architecture and hands-on data engineering experience, including data modelling, ELT, security, performance, and report-ready data structures.
2. Strong understanding of Salesforce data models and extraction/integration patterns, along with ServiceNow data and integration concepts.
3. Expertise in SQL, ETL/ELT, APIs/CDC, data mapping, reconciliation, and migration patterns across enterprise platforms.
4. Experience designing POCs, reference architectures, and repeatable migration frameworks for reporting/data transformation programs.
5. Strong understanding of reporting-oriented data architecture, data quality, lineage, dependencies, and business continuity during platform migrations.

Required Qualifications:

1. 10+ years of experience in data engineering, data architecture, analytics architecture, or enterprise data transformation.
2. Proven experience with Snowflake and enterprise data integration/migration, preferably involving Salesforce and/or ServiceNow.
3. Experience leading reporting/data transformation or legacy-to-new-platform migration initiatives.
4. Demonstrated experience building POCs and scalable technical frameworks that can be extended into larger transformation programs.
5. Bachelor's degree or equivalent experience; strong hands-on experience with SQL, Snowflake, ETL/ELT and modern data engineering technologies required.