Data Architect- Wealth Management

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

System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions 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 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.