Snowflake Developer

Role: Snowflake Developer

Location: Sanantonio, TX - onsite from Day 1

Duration: 12 Months Contract

Snowflake Developer / Data Warehouse Contractor

Job Overview

Role Summary

We are seeking an experienced Analytics Engineer / Data Engineer on a contract basis to lead the ingestion, modeling, and transformation of core banking data into Snowflake.

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.

Required Qualifications & Skills

Candidate Screening Key Areas

When screening candidates, specifically confirm:

• 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
• Availability to start ASAP

Thanks & Regards,

Aditya Kumar

Recruitment Manager Talent Acquisition

KAnand Corporation

Email: