Data Architect- Wealth Management Job at System One, Naperville, IL

eXczcVhzeC92cytmWWVkOWg5Z3U5ZzN1NFE9PQ==
  • System One
  • Naperville, IL

Job Description

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 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.
Must-Have Skills
  • 10–12+ years of Data Engineering/Data Architecture experience
  • Banking & Financial Services domain
  • Wealth Management, Asset Management, Private Banking, or Brokerage experience
  • AWS Data Platform Architecture
  • 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)
AWS Technologies
  • Storage & Analytics: S3, Redshift, EMR, Athena, Glue, Lake Formation
  • Lakehouse: Parquet, Iceberg, Delta Lake
  • Streaming: Kinesis, MSK (Kafka)
  • Serverless: Lambda, Step Functions, MWAA (Airflow)
  • Databases: RDS, Aurora, DynamoDB
  • Security: IAM, KMS, Encryption
BI Tools
  • QuickSight
  • Tableau
  • Power BI
Nice-to-Have
  • AWS Certifications
  • TOGAF
  • Collibra or Alation
  • Bloomberg or Refinitiv
  • Portfolio Accounting Systems
  • Machine Learning / Advanced Analytics
  • Data Mesh Architecture
  • Wealth Management Regulatory Reporting Experience
#M1
#DI-CB2

#L1 - KB1

Ref: #404-IT Pittsburgh

Job Tags

Similar Jobs

Essential Therapy Solutions, LLC

Speech Language Pathology Assistant Job at Essential Therapy Solutions, LLC

 ...by the SLP. Document client progress and maintain accurate records. Prepare materials and equipment for therapy sessions. Assist with administrative tasks, such as scheduling and billing. Participate in meetings and training sessions as required. Communicate... 

Mayo Clinic

Billing and Follow Up Rep- Hybrid Job at Mayo Clinic

 ...successful career with Mayo Clinic. Benefits Highlights Medical:Multiple plan options. Dental:Delta Dental or reimbursement...  ...campuses for on-site expectations based on business needs. The Billing and Follow Up Representative is an experienced level position... 

Carstensen Contracting, Inc.

Heavy Haul Truck Driver Job at Carstensen Contracting, Inc.

 ...Job Description Carstensen Contracting Inc. has an open position for a Heavy Haul Truck Driver. Our company drivers primary focus is to transport/deliver heavy excavation equipment safely and effectively to our various jobsites throughout the Midwest. The ideal candidate... 

Royal Caribbean Group

Confectioner Job at Royal Caribbean Group

 ...charge of producing the wide variety of delights available to our guest onboard our ships; items include: sweets cold and frozen, ice creams, ice cakes, pudding, chocolates, and more! Advanced pastry cooking methods, knowledge of mix techniques, and experience in a high... 

Emerson

Maintenance Journeyman Electrician - 2nd Shift Foundry Job at Emerson

 ...casting foundry in South Milwaukee, WI is looking a Maintenance Electrician to join our 2nd shift team. This role plans, installs and...  ...Completed a State Indentured Electrician apprenticeship - Journeyman status Strong electrical abilities with good problem solving...