Financial Data Architect: Snowflake, SQL & FP&A Mastery

Snapcode Inc; Foster City (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

Snapcode Inc is seeking a data-focused professional to architect and govern financial data assets, including warehouses and reporting datasets. The role emphasizes scalable data models, secure Snowflake implementations, and end-to-end data integration.

The candidate will leverage advanced SQL and Python to validate interfaces, automate checks, and support FP&A and accounting stakeholders with reliable, auditable data pipelines.

Qualifications

• Experience designing financial reporting datasets or data warehouses.
• Proficiency in conceptual, logical, and physical data modeling.
• Hands-on Snowflake data warehouse design, access control, and cost/performance awareness.
• Strong SQL skills including joins, aggregations, window functions, profiling, and reconciliations.
• Python for data validation, automation, and prototyping.
• Experience with APIs, batch or incremental ingestion, schema changes, and reliable ETL/ELT patterns.
• Ownership of governance, data quality, lineage, glossaries, and exception management.

Skills

Financial data architecture

Data modeling

Snowflake

Advanced SQL

Python

Enterprise integration

Governance and quality

Job description

Snapcode Inc is seeking a data-focused professional to architect and govern financial data assets, including warehouses and reporting datasets. The role emphasizes scalable data models, secure Snowflake implementations, and end-to-end data integration.

The candidate will leverage advanced SQL and Python to validate interfaces, automate checks, and support FP&A and accounting stakeholders with reliable, auditable data pipelines.