> Markdown version of [/jobs/ext/2266884-snowflake-developer](https://www.wearedevelopers.com/jobs/ext/2266884-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:** Jack Henry & Associates, Inc.
- **Location:** San Antonio, TX, United States
- **Contract:** Temporary contract
- **Skills:** Application Programming Interfaces (APIs), 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, Api Management
- **Published:** August 27, 2026
- **Apply:** https://www.dice.com/job-detail/4b2b6627-0ee7-413e-8081-ae34829ea8bc

## About the Role

Direct experience with Jack Henry core banking data structures or similar core financial platforms

Snowflake & SQL

Deep expertise in Snowflake architecture, complex SQL, and semi-structured data

JSON / VARIANT

Hands-on experience parsing and handling JSON/VARIANT payloads

dbt

Production experience building dbt models, data quality tests, and documentation

Dimensional Modeling

Strong knowledge of Kimball methodology, SCDs, and financial data modeling

Python/API Workflows

Hands-on experience working alongside Python API ingestion workflows

GitHub

Experience with GitHub and version control

Postman

Experience with API testing using Postman

Linux / Azure

Experience working in hybrid Linux/Azure environments, * Total Snowflake experience

 * Total SQL experience
 * Total dbt experience
 * Hands-on Jack Henry or comparable core banking experience
 * Hands-on Kimball / dimensional modeling experience
 * SCD implementation experience
 * Experience with JSON/VARIANT data in Snowflake
 * Experience integrating API/vendor data
 * Python, GitHub, and Postman experience
 * Experience with banking/financial data
 * Willingness to work onsite in San Antonio, Texas

## Description

The software team operates in a hybrid environment using on-premise Linux and Azure, with Python, GitHub, and Postman for third-party vendor API integrations.

The primary focus will be to model raw Jack Henry core banking data in Snowflake, transform it into production-grade dimensional models using dbt and SQL, and integrate ancillary data sources such as loans, deposits, digital banking, and compliance feeds to create a unified enterprise analytics layer.

Key Scope of Work & Deliverables

 1. Jack Henry Core Data Modeling
 + Architect and build dimensional data models using Kimball star schema / snowflake schema.
 + Model accounts, transactions, customer profiles, general ledger, and other core banking structures.
 2. Ancillary Data Integration
 + Design dbt transformation pipelines to join and append external third-party data feeds to the Jack Henry core data foundation.
 3. dbt Pipeline & Testing
 + Develop, test, and document modular dbt models.
 + Implement automated data quality checks.
 + Use GitHub for version control.
 4. API Payload Transformation
 + Collaborate with Python developers to process, flatten, and model raw JSON/relational API payloads.
 + Work with data received from Jack Henry and other vendor interfaces.
 5. Snowflake Performance & Security
 + Optimize Snowflake virtual warehouses.
 + Implement RBAC.
 + Manage clustering and optimize query execution for banking analytics.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)