Data Architect (Role : Reporting Transformation| Salesforce to ServiceNow & Snowflake)

Job Title: Data Architect (Role : Reporting Transformation| Salesforce to ServiceNow & Snowflake)

Location: Remote

Mode: Contract

Engagement : Contract - 6 months, extendable

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.

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.

Q1. Is the candidate willing to work on contract for 6 months (and maybe extendable)?*

Yes
No

Q2. Is the candidate willing to work 8 hours a day and 40 hours a week?*

Yes
No

Q3. How soon can the candidate join?*

Q4. Candidate's Citizenship/Visa status(only US Citizens & Green Card)*

US CItizen
Green Card
Others

Q5. Do you have 10+ years of professional experience in data engineering, data architecture, analytics architecture, or enterprise data transformation?*

Yes
No

Q6. Do you have hands-on experience designing and developing data solutions using Snowflake, rather than only using Snowflake as a reporting/querying platform?*

Yes
No

Q7. Do you have hands-on experience with both Salesforce and ServiceNow data integration or migration?*

Yes
No

Q8. Have you designed or implemented a reporting transformation/migration POC that was subsequently converted into a reusable or scalable migration framework?*

Yes
No

Q9. Have you worked on a data/reporting transformation involving Salesforce as a source, ServiceNow as a source or target system, and Snowflake as part of the target data architecture?*

Yes
No

Q10. Which best describes your hands-on experience with Snowflake architecture?*

I have only worked with Snowflake as a user/consumer
I have developed pipelines and queries in Snowflake but have not designed the architecture
I have designed data models, ELT pipelines, security, performance strategies, and reporting-ready structures in Snowflake
I have mainly managed Snowflake administration/infrastructure

Q11. In a recent project, what was your primary role in Snowflake-based data engineering?*

Writing SQL queries and creating reports
Developing ETL/ELT pipelines and data transformations
Designing the overall Snowflake data architecture, data models, pipelines, security and performance framework
Monitoring existing pipelines developed by another team

Q12. Which combination best matches your experience with enterprise data integration?*

Salesforce only
ServiceNow only
Salesforce and ServiceNow, including data models, extraction/integration patterns and reporting transformation
Worked with other enterprise applications but not Salesforce or ServiceNow

Q13. What best describes your experience with reporting transformation/migration?*

Developed individual reports based on existing requirements
Migrated reports individually from one platform to another
Built POCs to validate the target architecture and developed reusable/scalable frameworks for migrating multiple reports
Primarily provided reporting support after migration