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.

1. Technical Competencies: 
   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.

Behavioural Competencies: 

1. Hands-on technical leader who can quickly understand a complex environment and establish a practical path forward.
2. Strong client advisory and communication skills, able to explain architecture decisions and trade-offs to technical and business stakeholders.
3. Comfortable operating with ambiguity and evolving requirements while maintaining structure and momentum.
4. Risk and business continuity focused, particularly for critical downstream reporting and billing processes.
5. Strong collaborator who works effectively with the Business Analyst, Reporting Analyst, client SMEs, and existing Technical SME.

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.