Lead Data Integration Architect

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

-