Snowflake Analytics Engineer — Dimensional Modeling & dbt

JSM Consulting Inc.

San Antonio (TX)

Hybrid

USD 110,000 - 150,000

Part time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

JSM Consulting Inc. seeks an experienced Analytics/Data Engineer on a contract basis to transform Jack Henry core banking data into production-grade dimensional models in Snowflake. The role involves ingestion, modeling, and collaboration with Python teams to process API payloads from vendor interfaces.

The candidate will design dbt pipelines, implement data quality checks, and optimize Snowflake performance with RBAC and secure data handling in a hybrid Linux/Azure environment.

Qualifications

  • Direct experience with Jack Henry core banking data structures or similar core financial platforms.
  • Deep expertise in Snowflake architecture, complex SQL, and handling semi-structured data (JSON/VARIANT).
  • Proven track record building production dbt models, data quality tests, and documentation.
  • Strong background in Kimball dimensional modeling, SCDs and financial data modeling.
  • Hands-on experience with Python API ingestion workflows, GitHub version control, Postman API testing, and hybrid Linux/Azure environments.

Responsibilities

  • Architect and build dimensional data models (Kimball star/snowflake schema) around Jack Henry core banking structures.
  • Design dbt pipelines that join and append external third-party data feeds to the core data foundation.
  • Develop, test, and document modular dbt transformation models with automated data quality checks and GitHub versioning.
  • Collaborate with Python developers to process, flatten, and model raw API payloads from Jack Henry and vendor interfaces.
  • Optimize Snowflake workloads, RBAC, clustering, and query performance for banking analytics.

Skills

Core Banking Domain
Snowflake & SQL
dbt Expertise
Dimensional Modeling
Python

Tools

dbt
GitHub
Postman
Linux
Azure

Job description

JSM Consulting Inc. seeks an experienced Analytics/Data Engineer on a contract basis to transform Jack Henry core banking data into production-grade dimensional models in Snowflake. The role involves ingestion, modeling, and collaboration with Python teams to process API payloads from vendor interfaces.

The candidate will design dbt pipelines, implement data quality checks, and optimize Snowflake performance with RBAC and secure data handling in a hybrid Linux/Azure environment.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Developer
Snowflake Developer

JSM Consulting Inc. • San Antonio (TX)

Hybrid
USD 110,000 - 150,000
Senior Snowflake Data Engineer - DBT & Data Quality
Senior Snowflake Data Engineer - DBT & Data Quality

Valiant Technologies LLC • Dallas (TX)

On-site
USD 91,000 - 124,000
Data Modeler
Data Modeler

Veridic Solutions • Spring (TX)

On-site
USD 96,000 - 193,000
Analytics Engineer: Snowflake + dbt Data Modeling
Analytics Engineer: Snowflake + dbt Data Modeling

Cracker Barrel Old Country Store, Inc. • Lincoln (NE)

Hybrid
USD 110,000 - 165,000
Medical benefits on day 1
Dental and Vision benefits on day 1
401k with company match at 90 days
+3
Senior Analytics Engineer: DBT, Snowflake & Star Schema
Senior Analytics Engineer: DBT, Snowflake & Star Schema

Kelly • Spring (TX)

On-site
USD 120,000 - 150,000
Senior Snowflake DBT Engineer - Build Data Pipelines
Senior Snowflake DBT Engineer - Build Data Pipelines

Ethereum Technologies • Dallas (TX)

On-site
USD 89,000 - 126,000
Data Analytics Engineer – dbt & Snowflake
Data Analytics Engineer – dbt & Snowflake

Kelly • Spring (TX)

On-site
USD 120,000 - 150,000
Senior Snowflake Data Engineer | DBT & SQL Expert
Senior Snowflake Data Engineer | DBT & SQL Expert

Quantum Technologies. LLC • Dallas (TX)

On-site
USD 89,000 - 126,000
Senior Analytics Engineer: Snowflake AI & dbt Lead - Hybrid
Senior Analytics Engineer: Snowflake AI & dbt Lead - Hybrid

Southside Bancshares, Inc. • Tyler (TX)

Hybrid
USD 110,000 - 170,000
Senior Snowflake DBT Engineer – ELT & Data Modeling Leader
Senior Snowflake DBT Engineer – ELT & Data Modeling Leader

Compunnel Inc. • Irvine (CA)

On-site
USD 120,000 - 150,000