> Markdown version of [/jobs/ext/2120344-snowflake-data-engineering-consultant](https://www.wearedevelopers.com/jobs/ext/2120344-snowflake-data-engineering-consultant). 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 Data Engineering Consultant

- **Company:** Ishir, Inc.
- **Location:** San Antonio, TX, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Data Analysis, Microsoft Azure, Cluster Analysis, Information Engineering, Data Integration, Data Structures, Data Warehousing, Linux, Dimensional Modeling, Github, JSON, Python (Programming Language), Linux System Administration, Parsing, Role-Based Access Control, SQL Databases, Postman, Snowflake, Semi-structured Data, Core Data, Star Schema, Software Version Control
- **Published:** August 19, 2026
- **Apply:** https://www.wayup.com/i-j-Snowflake-Data-Engineering-Consultant-ISHIR-721970680194329/

## About the Role

We are seeking an experienced Analytics/Data Engineer with strong expertise in Snowflake, SQL, dbt, Python, and dimensional data modeling, specializing in transforming complex banking and financial data into scalable enterprise analytics solutions. Skilled in modeling core banking data, integrating ancillary sources and API payloads, developing production-grade dbt pipelines with automated data quality testing, and optimizing Snowflake performance and security. Proven experience with Kimball methodologies, SCDs, semi-structured JSON/VARIANT data, GitHub, Postman, Azure, and hybrid Linux environments, with a strong understanding of financial data and core banking platforms such as Jack Henry., + 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

+ 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.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [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)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [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)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [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)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)