Snowflake Data Engineer

Job Type: Contract - 12+ Months (potential for extension)

Work Arrangement: Onsite preferred; local candidates strongly preferred

We are seeking an experienced Snowflake Data Engineer to support the ingestion, modeling, and transformation of core financial data into Snowflake
.

The ideal candidate will have strong experience with Snowflake, SQL, dbt, dimensional data modeling, and financial/core banking data
. You will work with data engineers and software developers to transform raw data and third-party API payloads into production-ready dimensional models and a unified enterprise analytics layer.

• Design and develop dimensional data models using Kimball methodology
  , including star and snowflake schemas.
• Model core banking data including accounts, transactions, customer profiles, and general ledger information.
• Develop dbt transformation pipelines to integrate and append data from external and third-party sources.
• Build, test, document, and maintain modular dbt models with automated data quality checks.
• Work with Python developers to process, flatten, and model raw JSON and relational API payloads.
• Develop complex SQL transformations and optimize Snowflake workloads for analytics.
• Support Snowflake performance optimization, including virtual warehouses, clustering, query optimization, and efficient data processing.
• Implement and maintain appropriate role-based access controls (RBAC) and data security practices.
• Collaborate with software and data engineering teams working across Linux and Azure environments.
• Use Git Hub for source control and Postman for API testing and validation.

• Hands-on experience with core banking systems or similar financial data platforms
  .
• Strong expertise in Snowflake architecture and advanced SQL
  .
• Experience working with semi-structured data
  , including JSON and Snowflake VARIANT data types.
• Proven experience developing production-grade dbt models, tests, and documentation
  .
• Strong understanding of dimensional data modeling
  , including Kimball methodology and Slowly Changing Dimensions (SCDs).
• Experience working with financial or banking data is highly preferred.
• Experience collaborating with Python-based API ingestion workflows
  .
• Familiarity with Git Hub, Postman, Linux, and Azure environments.
• Strong analytical, problem-solving, and communication skills.

• Experience with Jack Henry or comparable core banking platforms.
• Experience integrating loans, deposits, digital banking, compliance, or other financial data sources.
• Experience building enterprise analytics/data warehouse layers in Snowflake.
• Experience optimizing Snowflake environments for large-scale analytical workloads.

Candidates with strong Snowflake + dbt + financial/core banking data experience are encouraged to apply.