Data Architect- Wealth Management

Data ArchitectLocation: Hybrid, Naperville, IL Duration: 6+ Months with ExtensionJob 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 experienceBanking & Financial Services domainWealth Management, Asset Management, Private Banking, or Brokerage experienceAWS Data Platform ArchitectureData Modeling (Dimensional, Data Vault, 3NF)Data Lake/Lakehouse & Data Warehouse ArchitectureETL/ELT DesignData Governance, Metadata, Data Quality & LineageAdvanced SQL & PythonInfrastructure as Code (Terraform/CloudFormation)AWS Technologies:Storage & Analytics: S3, Redshift, EMR, Athena, Glue, Lake FormationLakehouse: Parquet, Iceberg, Delta LakeStreaming: Kinesis, MSK (Kafka)Serverless: Lambda, Step Functions, MWAA (Airflow)Databases: RDS, Aurora, DynamoDBSecurity: IAM, KMS, EncryptionBI Tools:QuickSightTableauPower BINice-to-Have:AWS CertificationsTOGAFCollibra or AlationBloomberg or RefinitivPortfolio Accounting SystemsMachine Learning / Advanced AnalyticsData Mesh ArchitectureWealth Management Regulatory Reporting Experience#M1 #DI-CB2 #L1 - KB1 Ref: #404-IT Pittsburgh