Data Architect

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Extract
Transform
Load
Agile
Artificial Intelligence
Auditing
Data Warehouse Architecture
Banking
Real-time
Regulatory Compliance
Sarbanes-Oxley
Management
Microsoft Azure
Pandas
Performance Tuning
SQL
Scripting
Credit Risk
Data Engineering
Data Modeling
ELT
Finance
NumPy
Basel
Python
Snow Flake Schema
Storage
Streaming
Treasury
Workflow
Writing

Job Details

Responsibilities

  • Design scalable Snowflake data warehouse architecture aligned with banking compliance (Basel III, CCAR, SOX, GDPR). This architecture should result in a Unified Data Model utilizing Azure, Snowflake and multiple sources of data within the bank.
  • Develop robust Python-based ETL/ELT pipelines for structured and semi-structured data.
  • Implement real-time and batch ingestion patterns using Snowpipe, Streams, and Tasks.
  • Define data modeling standards (star/snowflake schema) for financial domains like loans, treasury, and customer 360.
  • Build reusable data pipeline components with proper logging, auditing, and error handling.

Required Skills

Snowflake (Required):

  • Deep hands-on experience with Snowflake architecture (storage, compute, virtual warehouses).
  • Expertise with Snowpipe, Streams & Tasks, Materialized Views, and performance optimization.
  • Proficient in writing Snowflake SQL and managing secure role-based access.
  • Familiarity with Cortex AI is a huge plus.

Python (Required):

  • Strong data engineering experience using Pandas, NumPy, and Snowflake Python Connector.
  • Experience integrating Python scripts in orchestrated workflows.
  • Familiarity with financial data (transactions, balances, credit/risk models) is a strong plus.

Azure (Nice to Have):

  • Experience with Azure Data Factory or Azure Blob Storage integration into Snowflake is a bonus.

Elective Skills

  • Experience in banking or a financial industry or another FHLB.
  • Experience in a highly regulated and secure environment

Experience working in an Agile environment

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.