The Jupiter Group
We are seeking an experienced Snowflake Data Architect to own the design, development, and operationalization of a modern cloud data platform that powers
board-level financial dashboards
(Net Revenue, EBITDA, Free Cash Flow, etc.). You will lead Snowflake environment design, write production-grade SQL, build robust
dbt
transformation pipelines, and contribute light-weight Python utilities that automate quality checks and CI/CD. A solid grasp of
financial consolidations, inter-company eliminations, and multi-currency reporting
is essential so you can partner effectively with FP&A, Accounting, and Executive stakeholders. Key Responsibilities Area What Youll Do * Design Snowflake schemas (star, Data Vault or medallion) aligned to GAAP/IFRS reporting structures. * Translate chart-of-accounts, legal entities, and consolidation hierarchies into scalable dimensional models. * Build and maintain dbt models (staging ? marts) with rigorous tests, documentation, and Slim-CI. * Author complex, performance-tuned SQL (windowing, CTEs, semi-structured VARIANT) to aggregate Net Revenue, EBITDA, and Cash-Flow statements. * Implement SCD-2 and snapshot patterns for time-series finance data. Automation & Governance * Develop lightweight Python scripts (Airflow operators, Great Expectations, or custom Snowpark) for data quality, orchestration, and metadata lineage. * Enforce role-based access, masking, and tag-based governance for confidential financial data. Performance & Operations * Optimize Snowflake warehouses (clustering, caching, auto-suspend) to meet sub-second dashboard SLAs. * Establish monitoring, cost-usage analytics, and incident playbooks. * Mentor junior engineers, review dbt PRs, and evangelize best practices. * Partner with FP&A to interpret eliminations logic, currency conversion, and minority interest adjustments. * Present technical trade-offs and roadmap status to the Data Platform Director and CFOs staff. Minimum Qualifications 10+ years
end-to-end data engineering experience,
3+ years Snowflake
(enterprise scale). 4+ dbt projects
in production (or 3 if each >12 months, multi-domain). Working Python (Snowpark, pandas) for ELT helpers and test harnesses. Proven delivery of executive-grade
financial dashboards
or data martsmust demonstrate understanding of eliminations, inter-company balances, multi-GAAP roll-ups. CI/CD with Git, dbt Cloud/CLI, and at least one orchestrator (Airflow, Prefect, Dagster). Cloud experience (AWS preferred: S3, IAM, Glue, Lambda or Step Functions). Strong communication skills: can brief non-technical finance leaders yet dive deep with architects. Bachelor's degree in Computer Science, Information Systems, Engineering, or Finance/Accounting; MS or MBA a plus. Preferred / Nice-to-Have Snowflake Snowpipe, Stream-&-Task, Dynamic Tables. Experience integrating SAP, Oracle E-Biz, or Workday Financials. Exposure to BI tools (Power BI, Tableau) and semantic layers (Cube, ThoughtSpot). Accounting / CPA coursework or hands-on consolidation system (OneStream, HFM). Great Expectations, Soda, or Monte Carlo for data observability. Seniority level
Seniority level
Not Applicable Employment type
Employment type
Contract Job function
Job function
Information Technology Industries
Manufacturing Referrals increase your chances of interviewing at The Jupiter Group, Inc by 2x Get notified about new Data Architect jobs in
Houston, TX . Houston, TX $150,000.00-$180,000.00 1 day ago Lead Data Architect - AI Driven Modeling & Governance
Lead Data Architect - Hybrid (Dallas or Houston, TX)
Sr. Principal IT Enterprise Architect - R&D/Engineering
Houston, TX $158,249.97-$232,099.95 5 days ago Houston, TX $180,000.00-$185,000.00 5 days ago Houston, TX $102,400.00-$204,100.00 1 week ago Part-Time Faculty - Computer Information Tech Cloud Computing (South)
Houston, TX $145,000.00-$160,000.00 1 month ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
board-level financial dashboards
(Net Revenue, EBITDA, Free Cash Flow, etc.). You will lead Snowflake environment design, write production-grade SQL, build robust
dbt
transformation pipelines, and contribute light-weight Python utilities that automate quality checks and CI/CD. A solid grasp of
financial consolidations, inter-company eliminations, and multi-currency reporting
is essential so you can partner effectively with FP&A, Accounting, and Executive stakeholders. Key Responsibilities Area What Youll Do * Design Snowflake schemas (star, Data Vault or medallion) aligned to GAAP/IFRS reporting structures. * Translate chart-of-accounts, legal entities, and consolidation hierarchies into scalable dimensional models. * Build and maintain dbt models (staging ? marts) with rigorous tests, documentation, and Slim-CI. * Author complex, performance-tuned SQL (windowing, CTEs, semi-structured VARIANT) to aggregate Net Revenue, EBITDA, and Cash-Flow statements. * Implement SCD-2 and snapshot patterns for time-series finance data. Automation & Governance * Develop lightweight Python scripts (Airflow operators, Great Expectations, or custom Snowpark) for data quality, orchestration, and metadata lineage. * Enforce role-based access, masking, and tag-based governance for confidential financial data. Performance & Operations * Optimize Snowflake warehouses (clustering, caching, auto-suspend) to meet sub-second dashboard SLAs. * Establish monitoring, cost-usage analytics, and incident playbooks. * Mentor junior engineers, review dbt PRs, and evangelize best practices. * Partner with FP&A to interpret eliminations logic, currency conversion, and minority interest adjustments. * Present technical trade-offs and roadmap status to the Data Platform Director and CFOs staff. Minimum Qualifications 10+ years
end-to-end data engineering experience,
3+ years Snowflake
(enterprise scale). 4+ dbt projects
in production (or 3 if each >12 months, multi-domain). Working Python (Snowpark, pandas) for ELT helpers and test harnesses. Proven delivery of executive-grade
financial dashboards
or data martsmust demonstrate understanding of eliminations, inter-company balances, multi-GAAP roll-ups. CI/CD with Git, dbt Cloud/CLI, and at least one orchestrator (Airflow, Prefect, Dagster). Cloud experience (AWS preferred: S3, IAM, Glue, Lambda or Step Functions). Strong communication skills: can brief non-technical finance leaders yet dive deep with architects. Bachelor's degree in Computer Science, Information Systems, Engineering, or Finance/Accounting; MS or MBA a plus. Preferred / Nice-to-Have Snowflake Snowpipe, Stream-&-Task, Dynamic Tables. Experience integrating SAP, Oracle E-Biz, or Workday Financials. Exposure to BI tools (Power BI, Tableau) and semantic layers (Cube, ThoughtSpot). Accounting / CPA coursework or hands-on consolidation system (OneStream, HFM). Great Expectations, Soda, or Monte Carlo for data observability. Seniority level
Seniority level
Not Applicable Employment type
Employment type
Contract Job function
Job function
Information Technology Industries
Manufacturing Referrals increase your chances of interviewing at The Jupiter Group, Inc by 2x Get notified about new Data Architect jobs in
Houston, TX . Houston, TX $150,000.00-$180,000.00 1 day ago Lead Data Architect - AI Driven Modeling & Governance
Lead Data Architect - Hybrid (Dallas or Houston, TX)
Sr. Principal IT Enterprise Architect - R&D/Engineering
Houston, TX $158,249.97-$232,099.95 5 days ago Houston, TX $180,000.00-$185,000.00 5 days ago Houston, TX $102,400.00-$204,100.00 1 week ago Part-Time Faculty - Computer Information Tech Cloud Computing (South)
Houston, TX $145,000.00-$160,000.00 1 month ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr