Lead Data Integration Architect

About this role

Job Description

CSCI Consulting is looking for a Lead Data Integration Architect to support a Public Sector client. The Lead Data Integration Architect will assess the current architecture, document data exchanges and system dependencies, identify gaps, and develop vendor-neutral future-state recommendations. This role requires strong experience with integration architecture, modern analytics platforms, cloud-based data environments, governed data sharing, and identity and access models.

The ideal candidate will have direct experience with the Indiana Department of Health (IDOH) databases and systems such as: DRIVE/Vital IQ, VitalChek, vital records systems, public health data, or similar government data environments.

Responsibilities

• Lead the architectural assessment of the current DRIVE/Vital IQ and replica environment

• Facilitate technical discovery sessions with IDOH teams, system owners, external partners, and data consumers

• Document the current-state architecture, data flows, interfaces, integration patterns, and system dependencies

• Inventory upstream and downstream systems, APIs, extracts, batch jobs, scheduled outputs, and data exchanges

• Analyze how data is created, modified, transmitted, accessed, shared, and consumed across internal and external stakeholders

• Assess existing API, ETL, batch, real-time, near-real-time, and event-driven integration patterns

• Identify undocumented interfaces, operational dependencies, architectural risks, inefficiencies, and constraints

• Develop current-state integration diagrams, data-flow diagrams, interface inventories, and dependency maps

• Evaluate modern analytics and data-platform options, including Snowflake, Microsoft Azure data services, cloud data warehouses, data lakes, data lakehouses, and Analytics Cloud Environments

• Assess opportunities for governed data sharing and secure self-service analytics

• Evaluate identity, authentication, authorization, role-based access, audit, encryption, privacy, and compliance requirements

• Assess data lineage, data quality, availability, latency, processing schedules, and service-level needs

• Define and compare vendor-neutral future-state architecture options

• Evaluate the feasibility and impacts of replacing or reducing reliance on the existing DRIVE replica

• Recommend appropriate real-time, near-real-time, batch, API-based, and data-sharing approaches

• Document the benefits, risks, dependencies, assumptions, limitations, and implementation considerations associated with each architecture option

• Develop a conceptual future-state architecture and modernization roadmap

• Support development of implementation sequencing, staffing assumptions, estimated levels of effort, and Rough Order of Magnitude cost estimates

• Contribute to the gap analysis, findings, executive summary, and presentation materials

• Present technical findings and recommendations to both technical and executive stakeholders

• Collaborate with project management, business analysis, security, governance, and cost-estimation resources

• Ensure all recommendations are secure, scalable, supportable, vendor-neutral, and aligned with IDOH’s long-term data-modernization objectives

Minimum Requirements

• Demonstrated experience in data integration architecture, data architecture, enterprise architecture, solution architecture, or a related technical discipline

• Experience assessing complex data environments containing multiple source systems, interfaces, downstream consumers, and external partners

• Strong knowledge of API design, management, and integration patterns

• Experience with ETL and ELT processes and technologies

• Experience designing or assessing batch, real-time, near-real-time, file-based, and event-driven integrations

• Experience with enterprise data exchanges and data-sharing frameworks

• Experience documenting current-state architecture, interfaces, integrations, data flows, dependencies, and data lineage

• Experience evaluating cloud-based data platforms and modern analytics environments

• Experience developing future-state architecture options and data-modernization recommendations

• Understanding of cloud data warehouses, data lakes, data lakehouses, and analytics platforms

• Knowledge of governed data-sharing and self-service analytics models

• Understanding of identity and access management, role-based access control, encryption, audit, privacy, security, and data-governance requirements

• Experience identifying architectural gaps, risks, inefficiencies, constraints, and modernization opportunities

• Experience leading technical discovery sessions, stakeholder interviews, workshops, and architecture reviews

• Ability to translate complex technical findings into clear, actionable recommendations

• Strong technical writing, diagramming, analytical, facilitation, and presentation skills

• Ability to communicate effectively with technical teams, business stakeholders, external partners, and executive leadership

• Creativity and adaptability in problem-solving

• Ability to work with clients to understand their needs

• Strong organizational and time-management skills

• Excellent written and verbal communication skills

• Professional presence

Preferred Skills

• Direct experience with IDOH’s DRIVE/Vital IQ environment

• Experience with VitalChek or similar vital-records service providers

• Experience supporting state vital records systems, including birth, death, marriage, or other vital-event data

• Previous experience supporting the Indiana Department of Health or another Indiana state agency

• Experience with public health, health and human services, or government data environments

• Experience with Snowflake architecture, data sharing, security, governance, or analytics

• Experience with Microsoft Azure data services and analytics platforms

• Experience with Analytics Cloud Environments or comparable governed cloud-data platforms

• Experience…