Snowflake Developer

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.

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