> Markdown version of [/jobs/ext/2271283-data-architect-wealth-management](https://www.wearedevelopers.com/jobs/ext/2271283-data-architect-wealth-management). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect- Wealth Management - **Company:** System One - **Location:** Naperville, IL, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Third Normal Form, Airflow, Amazon Web Services, Amazon S3, Big Data, Databases, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Vault Modeling, Data Warehousing, Amazon DynamoDB, Enterprise Architecture Framework, Identity and Access Management, Python (Programming Language), Machine Learning, Meta-Data Management, Software Architecture, Power BI, Data Streaming, Tableau (Software), Parquet, Data Ingestion, Sql Optimization, Cloudformation, Togaf, Data Lakes, Information Technology, Data Lineage, Collibra, Data Analytics, Apache Kafka, Data Management, Physical Data Models, Terraform, Serverless Computing - **Published:** August 27, 2026 - **Apply:** https://www.techcareers.com/job.asp?id=3367075666&tx=DT11303UTI&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54 ## About the Role * 10-12 years of experience in data engineering / data architecture, with a substantial portion in Banking & Financial Services. * Demonstrated experience in Wealth Management or closely adjacent areas (asset management, private banking, or brokerage), with working knowledge of financial instruments, portfolios, custody, advisory, and client/household data. * Proven track record designing large scale data platforms on AWS. * Strong data modeling expertise across dimensional, data vault, and normalized/3NF approaches, and knowing when to apply each. * Deep experience with data lake / lakehouse and data warehouse architecture, including ETL/ELT design. * Solid understanding of data governance, data quality, metadata management, and data lineage in a regulated environment. * Experience handling sensitive data with appropriate security, privacy, and compliance controls. * Strong stakeholder management and the ability to communicate architectural decisions to technical and non technical audiences. * AWS storage & compute: S3, Redshift, EMR, Athena, Glue, Lake Formation; lakehouse formats Parquet and Iceberg or Delta Lake. * Streaming and serverless orchestration: Kinesis, MSK (Managed Kafka), Lambda, Step Functions, MWAA (Managed Airflow). * Databases: RDS, Aurora, DynamoDB. * Security & access: IAM, KMS, encryption at rest/in transit, and fine grained access control. * Infrastructure as Code (CloudFormation and/or Terraform), advanced SQL, and Python. * BI / consumption tools: QuickSight, Tableau, or Power BI. Nice to Have Skills * AWS certifications (e.g., AWS Certified Data Analytics - Specialty, AWS Certified Solutions Architect). * Enterprise architecture framework experience (e.g., TOGAF). * Experience with data cataloging and governance tools (e.g., Collibra, Alation). * Familiarity with market data providers (e.g., Bloomberg, Refinitiv) and portfolio accounting / performance systems. * Exposure to machine learning / advanced analytics enablement. * Experience with data mesh or domain oriented data architecture. * Knowledge of relevant regulatory frameworks and reporting requirements in wealth management. ## Description * Design and maintain the end to end data architecture for the Wealth Management domain, including data lakes/lakehouses, warehouses, and streaming pipelines on AWS. * Define conceptual, logical, and physical data models for core wealth management entities such as clients, households, accounts, portfolios, holdings, transactions, and advisor relationships. * Establish architecture standards, patterns, and best practices for data ingestion, storage, transformation, and consumption across the organization. * Architect solutions for regulatory and compliance reporting (e.g., SEC, FINRA, Reg BI, SOX, and relevant privacy regimes), ensuring auditability and data lineage. * Lead the design of data governance, quality, cataloging, and master data management (MDM) frameworks. * Partner with security teams to enforce encryption, access controls, and PII/PCI handling for sensitive financial and client data. * Guide data engineering teams on implementation, review designs, and ensure alignment to the target architecture. * Evaluate and select tools and AWS services, balancing cost, performance, scalability, and maintainability. * Support real time and batch integration with source systems such as portfolio accounting, custody, CRM, market data feeds, and financial planning platforms. * Collaborate with business and analytics stakeholders to enable BI, reporting, and advanced analytics/ML use cases., System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services 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 full-time 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [OLAP for AI Applications and why you should care](https://www.wearedevelopers.com/videos/100212-olap-for-ai-applications-and-why-you-should-care) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)