Data Architect Wealth Management

ITCO Solutions

Naperville, IL

Apply

JOB DETAILS

SKILLS

AWS Lambda, Access Control, Accounts Payable, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Architectural Services, Asset Management, Banking Services, Best Practices, Brokerage, Business Intelligence, Cataloguing, Cloud Computing, Communication Skills, Cryptography, Customer Relationship Management (CRM), Customer/Client Research, Data Analysis, Data Lake, Data Modeling, Data Quality, Data Storage, Data Warehousing, DataArchitect Data Modeling Tool, Database Extract Transform and Load (ETL), Electronic Medical Records, Enterprise Architecture, Financial Planning, Financial Services, Information/Data Security (InfoSec), Machine Learning, Master Data Management (MDM), Metadata, PCI, Portfolio Accounting, Power BI, Power Management, Privacy Controls, Private Banking, Python Programming/Scripting Language, Quality Management, Regulatory Compliance, Regulatory Reports, SQL (Structured Query Language), Sarbanes-Oxley Act (SOX), Securities and Exchange Commission (SEC), Standards Development, TOGAF - The Open Group Architecture Framework, Tableau, Team Building, Team Player, Use Cases, Wealth Management, Work From Home

LOCATION

Naperville, IL

POSTED

Today

Data Architect- Wealth Management
Location: onsite client site Naperville IL, hybrid office/wfh
6+ months

Data Architect- Wealth Management

Position Description
Join a collaborative data and analytics team building a modern, cloud native data platform on AWS. In this hands on architecture role, you will shape the data foundations that power wealth management insights, working alongside engineers, analysts, and business stakeholders. You will have the autonomy to define standards and patterns while working with a modern lakehouse and streaming stack. This hybrid position offers a strong balance of technical depth, influence, and professional growth.

This role is located onsite at the client's office in Naperville, IL. This is a hybrid work scheduled.

Future Responsibilities:

. 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, Client, 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.

Requirements:

. 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.
#LI-1269610_CJ1
#LI-BS1
#LI-IA1
#LI-BP1
#LI-NB1
#LI-AP1
#LI-DM1
#LI-PT1
#LI-NT1
#LI-SG1
#LI-RB1

About the Company

ITCO Solutions

COMPANY SIZE

100 to 499 employees

INDUSTRY

Computer Software

Resume Resources

Free Resume Templates Free Resume Builder