Back to Jobs search

Data Architect- Wealth Management

System One • Naperville, IL • 13h ago

Job Title: Data Architect Wealth Management

Duration : 6+ Months Contract

Location : Naperville IL

Work Mode : Hybrid

Position Description

Join a collaborative Data & Analytics team building a modern, cloud-native data platform on AWS. In this hands-on architecture role, you will shape the data foundations that power Wealth Management insights, working alongside engineers, analysts, and business stakeholders. You will have the autonomy to define standards and patterns while working with a modern lakehouse and streaming stack. This hybrid position offers a strong balance of technical depth, influence, and professional growth.

Responsibilities

Design and maintain the end-to-end data architecture for the Wealth Management domain, including data lakes/lakehouses, warehouses, and streaming pipelines on AWS.

Define conceptual, logical, and physical data models for core wealth management entities such as clients, households, accounts, portfolios, holdings, transactions, and advisor relationships.

Establish architecture standards, patterns, and best practices for data ingestion, storage, transformation, and consumption across the organization.

Architect solutions for regulatory and compliance reporting (e.g., SEC, FINRA, Reg BI, SOX, and relevant privacy regimes), ensuring auditability and data lineage.

Lead the design of data governance, quality, cataloging, and master data management (MDM) frameworks.

Partner with security teams to enforce encryption, access controls, and PII/PCI handling for sensitive financial and client data.

Guide data engineering teams on implementation, review designs, and ensure alignment with the target architecture.

Evaluate and select tools and AWS services, balancing cost, performance, scalability, and maintainability.

Support real-time and batch integration with source systems such as portfolio accounting, custody, CRM, market data feeds, and financial planning platforms.

Collaborate with business and analytics stakeholders to enable BI, reporting, and advanced analytics/ML use cases.

Required Skills

10-12 years of experience in Data Engineering/Data Architecture, with significant experience in Banking & Financial Services.

Demonstrated experience in Wealth Management or closely related domains (Asset Management, Private Banking, or Brokerage), with working knowledge of financial instruments, portfolios, custody, advisory, and client/household data.

Proven experience designing and implementing large-scale AWS-based data platforms.

Strong expertise in data modeling, including Dimensional Modeling, Data Vault, and Normalized (3NF) approaches.

Deep experience with Data Lake/Lakehouse and Data Warehouse architecture, including ETL/ELT design.

Strong understanding of Data Governance, Data Quality, Metadata Management, and Data Lineage in regulated environments.

Experience handling sensitive data with security, privacy, and compliance controls.

Excellent stakeholder management and communication skills, with the ability to present architectural decisions to both technical and non-technical audiences.

Hands-on experience with AWS services:

Redshift

EMR

Athena

Glue

Lake Formation

Parquet

Iceberg or Delta Lake

Experience with Streaming and Serverless technologies:

Kinesis

MSK (Managed Kafka)

Lambda

Step Functions

MWAA (Managed Airflow)

Database experience:

Amazon RDS

Aurora

DynamoDB

Security:

IAM

KMS

Encryption at Rest/In Transit

Fine-Grained Access Control

Infrastructure as Code:

CloudFormation and/or Terraform

Strong SQL and Python programming skills.

Experience with BI tools such as QuickSight, Tableau, or Power BI.

Nice-to-Have Skills

AWS Certifications (AWS Certified Data Analytics - Specialty, AWS Certified Solutions Architect, etc.)

TOGAF or other Enterprise Architecture framework experience.

Experience with Data Catalog and Governance tools such as Collibra or Alation.

Familiarity with market data providers such as Bloomberg or Refinitiv.

Experience with Portfolio Accounting and Performance Management platforms.

Exposure to Machine Learning and Advanced Analytics enablement.

Experience implementing Data Mesh or Domain-Oriented Data Architecture.

Knowledge of regulatory frameworks and reporting requirements within Wealth Management.

Ref: #404-IT Pittsburgh

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Similar Jobs

Vice President of Converting Business Unit

Ellsworth Corporation • Elk Grove Village, IL • 9h ago

Management & Administrative

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13595741 \ Ellsworth Corporation\ \ Job Description: What does a cell phone in you...

9h ago

Go to Apply

Data Architect- Wealth Management

System One • Naperville, IL • 13h ago

Management & Administrative

Data Architect Location: Hybrid, Naperville, IL Duration: 6+ Months with Extention Job Summary Join a collaborative Data & Analytics team building a modern cloud-native data platform on AWS. This hands-on Data Archit...

13h ago

Go to Apply

Data Architect - Wealth Management

System One • Naperville, IL • 13h ago

Management & Administrative

W2 only - NO C2C candidates, NO 3rd parties For immediate consideration, please connect with me on LinkedIn at https://www.linkedin.com/in/dpotapenko and then email your resume, work authorization status, current locatio...

13h ago

Go to Apply

Data Architect- Wealth Management

System One • Naperville, IL • 13h ago

Management & Administrative

13h ago

Go to Apply

Account Manager

Wolter Inc. • Sugar Grove, IL • 16h ago

Management & Administrative

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13595773 THIS POSITION IS BASED OUT OF OUR SUGAR GROVE, IL BRANCH LOCATION Are you...

16h ago

Go to Apply

Customer Service Associate

Walgreens • Prospect Heights, IL • 1d ago

Management & Administrative

Job Description: Models and delivers a distinctive and delightful customer experience. Registers sales on assigned cash register, provides customers with courteous, fair, friendly, and efficient checkout service. Custome...

1d ago

Go to Apply

Purchasing Agent

Veterans Affairs, Veterans Health Administration • Hines, IL • 1d ago

Management & Administrative

Summary OUR MISSION: To fulfill President Lincoln's promise "To care for him who shall have borne the battle, and for his widow, and his orphan" - by serving and honoring the men and women who are America's Veterans. How...

1d ago

Go to Apply

Operations Manager

Caracas Transportation Inc • South Elgin, IL • 1d ago

Management & Administrative

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13593484 Plan, direct, coordinate transportation, storage, and distribution activi...

1d ago

Go to Apply

Operations Manager

Caracas Transportation Inc • South Elgin, IL • 1d ago

Management & Administrative

1d ago

Go to Apply

Entry Level Service Tech

Apex Systems • Hanover Park, IL • 1d ago

Management & Administrative

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13590262 Job Description: Warehouse Associate | Hanover Location:Hanover Park, IL...

1d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)