> Markdown version of [/jobs/ext/4014080-snowflake-developer](https://www.wearedevelopers.com/jobs/ext/4014080-snowflake-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Snowflake Developer

- **Company:** JSM Consulting
- **Location:** San Antonio, TX, United States
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Data Analysis, Microsoft Azure, Data Integration, Data Structures, Data Warehousing, Linux, Dimensional Modeling, Github, JSON, Python (Programming Language), Parsing, Role-Based Access Control, SQL Databases, Postman, Snowflake, Semi-structured Data, Core Data, Star Schema, Software Version Control
- **Published:** October 29, 2026
- **Apply:** https://www.thejobnetwork.com/job/54d3aa24-866f-47a0-bfe5-1a4caee32053/snowflake-developer

## About the Role

" Core Banking Domain: Direct experience working with Jack Henry core banking system data structures or similar core financial platforms.
" Snowflake & SQL: Deep expertise in Snowflake architecture, complex SQL, and handling semi-structured data (parsing JSON/VARIANT payloads).
" dbt Expertise: Proven track record building production dbt models, data quality tests, and documentation.
" Dimensional Modeling: Strong background in Kimball methodology, slowly changing dimensions (SCDs), and financial data modeling.
" Technical Stack Familiarity: Hands-on experience working alongside Python API ingestion workflows, GitHub version control, Postman API testing, and hybrid Linux/Azure environments

## Description

Job Description We are seeking an experienced Analytics Engineer / Data Engineer on a contract basis to lead the ingestion, modeling, and transformation of our core banking data into Snowflake. Our software team operates in a hybrid environment (on-premise Linux and Azure) using Python, GitHub, and Postman to integrate third-party vendor APIs. In this role, your primary objective will be modeling raw Jack Henry core banking data landed in Snowflake, transforming it into production-grade dimensional models using dbt and SQL, and appending key ancillary data sources (loans, deposits, digital banking, and compliance feeds) to create a unified enterprise analytics layer.

Key Scope of Work & Deliverables
" Jack Henry Core Data Modeling: Architect and build dimensional data models (Kimball star schema/snowflake schema) around Jack Henry core banking structures (accounts, transactions, customer profiles, general ledger).
" Ancillary Data Integration: Design dbt transformation pipelines that join and append external third-party data feeds to the Jack Henry core data foundation.
" dbt Pipeline & Testing: Develop, test, and document modular dbt transformation models, incorporating automated data quality checks and version control via GitHub.
" API Payload Transformation: Collaborate with our Python developers to process, flatten, and model raw JSON/relational API payloads landed from Jack Henry and other vendor interfaces.
" Snowflake Performance & Security: Optimize virtual warehouses, role-based access controls (RBAC), clustering, and query execution for banking analytics.