Top Data Architect Jobs in Chicago, IL

Design scalable, secure data architectures on Google Cloud, lead discovery and migration from legacy systems, define ETL/ELT patterns, enforce governance and security, optimize performance, collaborate with stakeholders, and document architecture and migration progress.

Lead database design, data modeling, schema evolution, migrations, and ETL/ELT pipelines across MySQL, PostgreSQL, and Google Cloud databases. Build streaming and batch ingestion, enable CI/CD for data deployments, troubleshoot pipelines, produce runbooks, and mentor/lead offshore DB/ETL engineers while collaborating with onshore architects.

Lead design and implementation of scalable data architectures using Capsenta. Build and maintain data models, ontologies, and graph databases; manage databases; integrate data sources; optimize performance; enforce data governance; document solutions; collaborate with engineers and stakeholders; and stay current on semantic and knowledge-graph technologies.

Design, build, and optimize Spark ETL pipelines using Scala/Python and Oracle SQL. Lead and mentor a team of engineers, collaborate with stakeholders on scalable data solutions, ensure data integrity, security, and performance, and stay current on emerging technologies to drive improvements.

Design and operationalize FHIR-compliant data models and scalable integration solutions to harmonize EHR, HIE, and claims data. Build validation frameworks and automated rules to ensure clinical accuracy and longitudinal integrity. Produce clear documentation and collaborate with engineering and cross-functional teams to support analytics, operational, and research initiatives.

Senior, hands-on role defining enterprise data architecture and standards across cloud platforms (Snowflake, Databricks, Azure). Design data models, integration patterns, governance, and pipelines to support analytics and AI/ML. Lead platform decisions, ensure security, metadata, and MDM; mentor teams and drive architecture reviews and documentation.

Lead enterprise data architecture on Snowflake, define Medallion Architecture and data modeling standards, guide dbt/Python pipeline frameworks, enforce HIPAA-compliant governance, optimize performance and cost, and mentor engineers while collaborating with analytics, clinical, and product stakeholders.

Lead definition and evolution of cloud data architecture and analytics platform using a lakehouse approach. Design secure, scalable AWS data platforms, medallion data layers, data modeling standards, ETL/ELT and streaming pipelines, governance, observability, and AI/ML enablement. Drive tool selection, cross-team architecture reviews, mentor engineers, and enforce data security, compliance, and operational excellence across the organization.

The Data Architect/Data Governance Lead supports the Medicaid Enterprise Data Warehouse by leading data architecture, metadata management, and governance processes, ensuring compliance and scalability.

Design and own an enterprise-scale, multi-cloud data and analytics platform for the VA. Lead migration and modernization, implement governance/security/compliance for sensitive PII/PHI, enable AI/ML capabilities, support ingestion and interoperability across VA systems, and produce architecture and compliance documentation while collaborating with engineers, analysts, and stakeholders.

Own and implement the canonical data model and governance for a multi-tenant MEP SaaS platform. Architect data for AI/ML readiness (RAG, embeddings, vector search), design polyglot persistence and lake/lakehouse pipelines, lead staged modernization and migrations, produce hands-on prototypes and in-repo guardrails, and partner with platform, DB engineering, and ML teams to ensure data quality, lineage, and observability.

Design and implement enterprise data architectures and lakehouse/warehouse solutions using Microsoft Fabric, Databricks or similar platforms. Lead data modeling, ETL/ELT pipelines, cloud integration, CI/CD, and stakeholder-facing consulting engagements to deliver scalable, secure analytics systems.

Lead cloud data architecture and modeling for a federal court modernization program. Design and implement secure, scalable cloud data platforms (lake/lakehouse/warehouse), define data models, govern metadata and lineage, enable ETL/ELT and CDC ingestion, support migration and archival strategies, ensure compliance with federal security and data governance, and partner with engineering, governance, and BI teams to deliver analytics and AI/ML-ready data products.

Define and govern enterprise data architecture, models, canonical and semantic layers, field-level mappings, and data governance. Partner with IT, Data Engineering, Security, and product teams to ensure data quality, lineage, integrations (Boomi), and platform alignment (Salesforce, Snowflake, NetSuite). Lead M&A data activities, perform hands-on data profiling and validation, and drive adoption of enterprise data standards to support analytics, AI, and automation initiatives.

Lead and own end-to-end delivery of enterprise Data & AI programs, define data strategy and architecture (lakehouse/warehouse), drive modernization, governance, data quality, metadata/lineage, and AI adoption. Manage client relationships, account growth, program budgets, delivery teams, and stakeholder communications to ensure on-time, on-budget outcomes.

Lead design and implementation of end-to-end ELT pipelines and transformation layers (dbt) to produce curated, reporting-ready datasets. Define data models, governance, metadata, lineage, and engineering standards. Partner with cross-functional teams to translate requirements, optimize performance and costs (cloud DW like Snowflake), and grow a data architecture practice that supports BI, self-service analytics, and AI agents.

Lead design and implementation of a medallion lakehouse on Microsoft Fabric, build ingestion pipelines, data models and BI dashboards, create AI/LLM tools for business users, enforce data governance, mentor data teams, and partner with stakeholders to enable self-serve analytics across marketing, product, finance, and clinical functions.

Senior hands-on Cloud Data Architect responsible for designing scalable, secure Snowflake-based data platforms and lakehouse solutions, enabling enterprise analytics and AI-native applications. Lead architecture, create design artifacts and blueprints, define scope and sizing, translate business requirements into technical solutions, collaborate with security and data teams, mentor junior staff, and guide implementation.

Design and deliver Databricks-centric data architectures, lead pre-sales and billable engagements, build end-to-end data engineering pipelines for AI/ML and BI, mentor teams, ensure data governance/security/quality, and resolve data system issues while producing solution documentation and presentations.

As a Salesforce Technical Architect focused on Data & AI, you'll design and implement solutions using Salesforce Data 360, oversee technical projects, collaborate with various stakeholders, and mentor junior staff to drive AI innovations.

Customer-facing specialist guiding enterprise cloud data engineering and lakehouse transformations. Architect and optimize large-scale data pipelines, perform performance and load testing, support pre-sales POCs and workload sizing, lead adoption workshops, and mentor peers to drive Databricks platform adoption.

Lead data architecture pursuits and complex client engagements, including workshops, requirements analysis, future-state architecture, implementation roadmaps, platform integration, and proof-of-concept development. Communicate complex solutions to technical and executive audiences, lead globally distributed teams, modernize legacy architectures, and provide thought leadership across data management, governance, modeling, cloud, and analytics technologies.

The Data Architect will design data architecture, drive strategy for data warehousing, oversee reporting projects, and mentor the team while ensuring compliance with standards.

Lead the data team in building a data vault and warehouse on Snowflake, manage tasks, and ensure quality data through sprint cycles.

Support and architect clients' Azure data platforms and Power BI environments within Managed Services. Design Databricks Lakehouse and Delta Lake solutions, build and maintain data pipelines, advise on governance/licensing, resolve escalations, mentor junior staff, communicate with clients, create documentation, and promote best practices for HIPAA-compliant healthcare data solutions.