Data Architect- Wealth Management

This hands-on Data Architect role will define the data architecture that powers Wealth Management analytics while partnering with engineers, analysts, and business stakeholders. Join a collaborative Data & Analytics team building a modern cloud-native data platform on AWS.

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