Snowflake Data Engineering Consultant Job at ISHIR, San Antonio, TX

  • ISHIR
  • San Antonio, TX

Job Description

Job Title - Snowflake Data Engineering Consultant

Duration -12+ Months

Work Mode-  Onsite

Work Location- San Antonio,TX

Position Summary:
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.

PRINCIPAL DUTIES AND RESPONSIBILITIES (May perform any or all of the following):

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

    Qualifications & Experience Required (3+ Years)
  • 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.

    ABOUT ISHIR

ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.

We are not just consultants, we are partners in our clients' success, assisting them with re(gaining) competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.

At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences and the right technologies.

As an ISHIR employee, you will get the advanced training you need to be successful, and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.

ISHIR attracts a special type of individual—someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration

Job Tags

Full time

Similar Jobs

The Menta Education Group

Instructional Assistant Bachelor's Degree Level Job at The Menta Education Group

 ...interventions to students to assist in managing behaviors Think quickly, independently, and tactfully Qualifications Bachelor's Degree preferably in a discipline such as Education, Psychology, Sociology, Social Work, Criminal Justice, Human Services, Kinesiology... 

Automation Personnel Services

Farm Hand at Poultry Farm Job at Automation Personnel Services

 ...Job Description Job Description FARM HELPER Automation Personnel Services is looking for a Farm Helper for a company based in Ashland, AL. In this role, you will have the opportunity to work hand in hand with chickens at a hatchery. This company offers a wide... 

American Leadership Academy

K-12 Grade Teachers and School Administrator - High Point, NC Area Job at American Leadership Academy

 ...potential. Our ideal candidate for this position is an experienced K-12 grade English. Math, Science, History Teacher, and School Administrator. School Admin is responsible for coordinating with staff members/students/parents. They must also maintain accurate records... 

Affordable Language Services

SPANISH MEDICAL INTERPRETERS in the Greater Cincinnati area Job at Affordable Language Services

 ...Spanish Interpreters Needed For In-Person Appointments Become a Lango Pro and serve your community by providing independent contract...  ...Highlights: Diverse work environment across multiple fields (medical, educational, social, legal, etc.). Competitive pay. Flexible... 

Milbank Tweed

Conflicts Analyst Job at Milbank Tweed

 ...Conflicts Analyst Milbank LLP is seeking a dynamic, highly organized, and motivated individual for the role of Conflicts Analyst in the Conflicts Department, supporting the firm globally, and working alongside the Legal Risk & Compliance team. This is an exciting opportunity...