Description
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 assessing data replicas, reporting databases, integration hubs, or enterprise data-distribution environments
- Experience supporting cross-agency or external-partner data exchanges
- Experience developing technology roadmaps, conceptual migration strategies, staffing models, level-of-effort estimates, and ROM cost estimates
- Experience supporting architecture assessments used to inform a subsequent modernization effort, system replacement
- Relevant architecture, cloud, data, integration, or security certifications
- Ability to work in a team environment, as well as independently
- Strong customer and vendor relationship skills
- Demonstrated ability to comply with data standards and policies
- Motivation to learn new technologies and methodologies that demonstrate value
- Past experience working with a state government agency
- Indiana Department of Health experience is a plus!
About CSCI
CSCI is an award-winning information technology and financial management consulting firm founded on one simple philosophy: “Do what is right, always.” We apply this philosophy across all elements of our growing business, from delivering world-class services for customers to providing an environment where associates thrive both personally and professionally. At CSCI, work and fun aren’t diametrically opposed!
At CSCI, our goal is to hire people with proven track records and retain them with an energizing, diverse company culture. We value each associate’s natural drive to excel, and we provide them with the freedom to do things their way. CSCI seeks the best and brightest in the industry—those who are ready to move their lives and career forward. Join us today and get excited about Mondays again!
Benefits of Working at CSCI
- Competitive salaries
- Generous Paid Time Off (PTO) package
- Paid holidays aligned to the Federal calendar
- Full health benefits including medical, dental, vision, and life insurance
- 401(k) retirement plan
- Team building events
- Professional development support
Legal
CSCI complies with all applicable Federal, state, and local employment regulations. Please reach out to HR@csciconsulting.com with any questions.
Similar jobs
Est. 120,000 USD
Job Description CSCI Consulting is looking for a Financial Systems Functional Analyst to support a Department of War (DoW / DoD) financial system implementation initiative. In this role, the consultant will combines fede…
Est. 115,000 USD
Job Description CSCI Consulting is seeking an Implementation Integration Lead to support its Department of War (DoW / DoD) client. This role serves as the primary coordination and communication bridge between project lea…
Est. 120,000 USD
Job Description CSCI Consulting is looking for a SAP Basis Administrator to support our DoW client. In this role, the consultant will support a large-scale enterprise modernization initiative focused on transforming lega…
Est. 105,000 USD
Job Description CSCI Consulting is seeking a Data Integration & Interface Analyst to support its Department of War (DoW / DoD) client. This role is responsible for helping define, validate, test, and stabilize missio…
Est. 120,000 USD
Job Description CSCI Consulting is looking for a SAP Transportation Management (TM) Event SME to support our DoW client. In this role, the consultant will support a large-scale enterprise modernization initiative focused…
Est. 76,000 USD
Job Description CSCI is seeking a Budget Analyst to support Department of War (DoW) Financial Management and budget execution operations. The Budget Analyst will provide budget formulation, execution, funds management, f…
Est. 85,000 USD
Job Description CSCI Consulting is seeking a PMO Support Analyst to support its Department of War (DoW / DoD) client. This role will partner closely with project leadership to execute core PMO functions, maintain project…
Est. 120,000 USD
Job Description CSCI is on the hunt for a dynamic Senior Network Engineer to join our client's Engineering Support Services program in Pearl Harbor, HI. This hybrid role offers the perfect blend of flexibility and advent…
Est. 95,000 USD
Job Description CSCI Consulting is seeking a Quality Assurance (QA) Analyst to support its Department of War (DoW / DoD) client. This role is responsible for validating that configured functionality, integrations, calcul…
Est. 85,000 USD
Job Description CSCI Consulting is seeking a Data Transmission Analyst to support its Department of War (DoW / DoD) client. This role is responsible for ensuring inbound and outbound data files, feeder files, interface t…
Est. 85,000 USD
Job Description CSCI Consulting is seeking a Knowledge Management Analyst to support its Department of War (DoW / DoD) client. This role is responsible for capturing, organizing, governing, and maintaining program knowle…
Est. 120,000 USD
Job Description CSCI Consulting is looking for a OneStream Developer to support its Department of War (DoW / DoD) client. This role will support the design, development, and implementation of a OneStream financial manage…
Est. 90,000 USD
At CSCI Consulting, we’re always looking for talented, driven individuals who share our commitment to superior service and innovative solutions. Don’t see the right role today? Submit a general application to stay on our…
Est. 105,000 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 146,750 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 155,900 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 136,700 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 155,900 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 124,000 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 124,000 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 117,500 USD
This position supports a federal client and requires US citizenship for Public Trust eligibility Attain Talent is searching for talented cloud engineers for our GovCon client. This role will focus on architecting resilie…
Est. 141,700 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 125,000 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 155,900 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 167,900 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 197,750 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 151,800 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…
Est. 124,000 USD
Company Overview: For more than 50 years, NISC has developed and implemented enterprise-level and customer-facing software solutions for over 960+ utilities and broadbands across North America. Our mission is to deliver…
Est. 138,100 USD
We are seeking an AI Tool Support Engineering Lead to lead comprehensive user support and program management for AFS AI Code Assist, an AI-powered coding assistant that leverages Large Language Models (LLMs) to help deve…
Est. 166,800 USD
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…