Job Description
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