Snowflake Data Engineering Consultant (Banking)

Location: Onsite in San Antonio, Texas, United States

Company

hirify.global is a digital innovation and enterprise AI services provider helping startups and enterprises solve complex business and technology challenges.

What you will do

• Architect and build Kimball dimensional models around Jack Henry core banking structures, including accounts, transactions, customer profiles, and general ledger data.
• Design dbt transformation pipelines that integrate third-party feeds with core banking data.
• Develop, test, document, and maintain modular production dbt models with automated data quality checks.
• Process, flatten, and model JSON and relational API payloads in collaboration with Python developers.
• Optimize Snowflake virtual warehouses, clustering, query execution, and role-based access controls for banking analytics.

Requirements

• 3+ years of relevant experience in analytics or data engineering.
• Direct experience with Jack Henry data structures or similar core financial platforms.
• Deep expertise in Snowflake architecture, complex SQL, and semi-structured JSON/VARIANT data.
• Production experience building dbt models, automated data quality tests, and technical documentation.
• Strong knowledge of Kimball methodology, slowly changing dimensions, and financial data modeling.
• Hands-on familiarity with Python API ingestion workflows, GitHub, Postman, Azure, and hybrid Linux environments.

Culture & Benefits

• Advanced training and opportunities to apply technical knowledge to real business solutions.
• Work with startup and enterprise customers on complex digital challenges.
• Entrepreneurial environment promoting self-reliance, open communication, and collaboration.
• Full-time employment for a 12+ month engagement.