Data Architect

Snowrelic Inc

Naperville (IL)

Hybrid

USD 130,000 - 180,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Snowrelic Inc in Naperville, IL is seeking a hands-on Data Architect for Wealth Management to define enterprise data architecture on a cloud-native AWS platform.

You will partner with engineers and analysts, build data lakes/warehouses, govern data, and ensure secure, scalable solutions for reporting and analytics across SEC/FINRA requirements.

Qualifications

10-12+ years of Data Engineering/Data Architecture experience.
Banking & Financial Services domain experience.
Wealth Management, Asset Management, Private Banking, or Brokerage experience.
AWS Data Platform Architecture experience.
Data Modeling (Dimensional, Data Vault, 3NF).
Data Lake/Lakehouse & Data Warehouse Architecture.
ETL/ELT Design.
Data Governance, Metadata, Data Quality & Lineage.
Advanced SQL & Python.
Infrastructure as Code (Terraform/CloudFormation).

Responsibilities

Design end-to-end AWS data architecture for Wealth Management platforms.
Build and maintain data lakes, lakehouses, warehouses, and streaming pipelines.
Develop conceptual, logical, and physical data models.
Design models for clients, households, accounts, portfolios, holdings, transactions, and advisor relationships.
Establish enterprise standards for data ingestion, transformation, storage, and consumption.
Design regulatory reporting solutions (SEC, FINRA, Reg BI, SOX).
Lead Data Governance, Data Quality, Metadata, Cataloging, and MDM initiatives.
Implement secure architecture with encryption, IAM, KMS, and PII/PCI compliance.
Guide engineering teams and review technical designs.
Evaluate AWS services based on scalability, performance, and cost.
Support batch and real-time integrations with portfolio, CRM, custody, and market data systems.
Enable BI, reporting, and ML/Analytics use cases.

Skills

Data architecture

Data engineering

Banking/Finance

Wealth management domain

AWS data platform

Data modeling

Data lake/lakehouse

ETL/ELT design

Data governance

SQL

Python

Terraform/CloudFormation

Tools

Terraform/CloudFormation

Job description

Data Architect Wealth Management

Location: Naperville, IL (Hybrid Onsite Client Office)

Duration: 6+ Months Contract with a possibility of Extension

Job Summary

Join a collaborative Data & Analytics team building a modern cloud‑native data platform on AWS. This hands‑on Data Architect role will define the data architecture that powers Wealth Management analytics while partnering with engineers, analysts, and business stakeholders. You'll establish enterprise data standards, governance, and scalable AWS‑based data solutions.

Key Responsibilities

Design end‑to‑end AWS data architecture for Wealth Management platforms.
Build and maintain data lakes, lakehouses, warehouses, and streaming pipelines.
Develop conceptual, logical, and physical data models.
Design models for clients, households, accounts, portfolios, holdings, transactions, and advisor relationships.
Establish enterprise standards for data ingestion, transformation, storage, and consumption.
Design regulatory reporting solutions (SEC, FINRA, Reg BI, SOX).
Lead Data Governance, Data Quality, Metadata, Cataloging, and MDM initiatives.
Implement secure architecture with encryption, IAM, KMS, and PII/PCI compliance.
Guide engineering teams and review technical designs.
Evaluate AWS services based on scalability, performance, and cost.
Support batch and real‑time integrations with portfolio, CRM, custody, and market data systems.
Enable BI, reporting, and ML/Analytics use cases.