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 experience with 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 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 DRIVE/Vital IQ environment Experience with VitalChek or similar vital-records service providers <span st