LEAD DATA INTEGRATION ARCHITECT
Csciconsulting
lead
Sign in to applyFree account, takes a minute.
Job description
<h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Job Description</span></h3>
<p><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">CSCI Consulting is looking for a <strong>Lead Data Integration Architect</strong> 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.</span></p>
<p><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">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.<br></span></p>
<h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Responsibilities</span></h3>
<ul>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Lead the architectural assessment of the current DRIVE/Vital IQ and replica environment</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Facilitate technical discovery sessions with IDOH teams, system owners, external partners, and data consumers</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Document the current-state architecture, data flows, interfaces, integration patterns, and system dependencies</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Inventory upstream and downstream systems, APIs, extracts, batch jobs, scheduled outputs, and data exchanges</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Analyze how data is created, modified, transmitted, accessed, shared, and consumed across internal and external stakeholders</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Assess existing API, ETL, batch, real-time, near-real-time, and event-driven integration patterns</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Identify undocumented interfaces, operational dependencies, architectural risks, inefficiencies, and constraints</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Develop current-state integration diagrams, data-flow diagrams, interface inventories, and dependency maps</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Evaluate modern analytics and data-platform options, including Snowflake, Microsoft Azure data services, cloud data warehouses, data lakes, data lakehouses, and Analytics Cloud Environments</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Assess opportunities for governed data sharing and secure self-service analytics</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Evaluate identity, authentication, authorization, role-based access, audit, encryption, privacy, and compliance requirements</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Assess data lineage, data quality, availability, latency, processing schedules, and service-level needs</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Define and compare vendor-neutral future-state architecture options</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Evaluate the feasibility and impacts of replacing or reducing reliance on the existing DRIVE replica</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Recommend appropriate real-time, near-real-time, batch, API-based, and data-sharing approaches</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Document the benefits, risks, dependencies, assumptions, limitations, and implementation considerations associated with each architecture option</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Develop a conceptual future-state architecture and modernization roadmap</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Support development of implementation sequencing, staffing assumptions, estimated levels of effort, and Rough Order of Magnitude cost estimates</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Contribute to the gap analysis, findings, executive summary, and presentation materials</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Present technical findings and recommendations to both technical and executive stakeholders</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Collaborate with project management, business analysis, security, governance, and cost-estimation resources</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Ensure all recommendations are secure, scalable, supportable, vendor-neutral, and aligned with IDOH’s long-term data-modernization objectives</span></li>
</ul>
<h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Minimum Requirements</span></h3>
<ul>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Demonstrated experience in data integration architecture, data architecture, enterprise architecture, solution architecture, or a related technical discipline</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience assessing complex data environments containing multiple source systems, interfaces, downstream consumers, and external partners</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Strong knowledge of API design, management, and integration patterns</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with ETL and ELT processes and technologies</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience designing or assessing batch, real-time, near-real-time, file-based, and event-driven integrations</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with enterprise data exchanges and data-sharing frameworks</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience documenting current-state architecture, interfaces, integrations, data flows, dependencies, and data lineage</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience evaluating cloud-based data platforms and modern analytics environments</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience developing future-state architecture options and data-modernization recommendations</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Understanding of cloud data warehouses, data lakes, data lakehouses, and analytics platforms</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Knowledge of governed data-sharing and self-service analytics models</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Understanding of identity and access management, role-based access control, encryption, audit, privacy, security, and data-governance requirements</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience identifying architectural gaps, risks, inefficiencies, constraints, and modernization opportunities</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience leading technical discovery sessions, stakeholder interviews, workshops, and architecture reviews</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Ability to translate complex technical findings into clear, actionable recommendations</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Strong technical writing, diagramming, analytical, facilitation, and presentation skills</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Ability to communicate effectively with technical teams, business stakeholders, external partners, and executive leadership</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Creativity and adaptability in problem-solving</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Ability to work with clients to understand their needs</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Strong organizational and time-management skills</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Excellent written and verbal communication skills</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Professional presence</span></li>
</ul>
<h3><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Preferred Skills</span></h3>
<ul>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Direct experience with IDOH’s DRIVE/Vital IQ environment</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with VitalChek or similar vital-records service providers</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting state vital records systems, including birth, death, marriage, or other vital-event data</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Previous experience supporting the Indiana Department of Health or another Indiana state agency</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with public health, health and human services, or government data environments</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with Snowflake architecture, data sharing, security, governance, or analytics</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with Microsoft Azure data services and analytics platforms</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience with Analytics Cloud Environments or comparable governed cloud-data platforms</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience assessing data replicas, reporting databases, integration hubs, or enterprise data-distribution environments</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting cross-agency or external-partner data exchanges</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience developing technology roadmaps, conceptual migration strategies, staffing models, level-of-effort estimates, and ROM cost estimates</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Experience supporting architecture assessments used to inform a subsequent modernization effort, system replacement</span></li>
<li style="color: rgb(0, 45, 64);"><span style="color: rgb(0, 45, 64);">Relevant architecture, cloud, data, integration, or security certifications</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Ability to work in a team environment, as well as independently</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Strong customer and vendor relationship skills</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Demonstrated ability to comply with data standards and policies</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);" data-darkreader-inline-color="">Motivation to learn new technologies and methodologies that demonstrate value</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);">Past experience working with a state government agency</span></li>
<li style="color: rgb(0, 45, 64);" data-darkreader-inline-color=""><span style="color: rgb(0, 45, 64);">Indiana Department of Health experience is a plus!</span></li>
</ul><div class="content-conclusion"><h2><span style="font-family: montserrat light, arial, sans-serif; color: #00aae7;" data-contrast="none">About CSCI</span></h2>
<p><span style="font-family: merriweather, georgia, serif; color: #002d40;"><span data-contrast="none">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 s</span><span data-contrast="none">ervices for customers to providing an environment where associates thrive both personally and professionally. At CSCI, work and fun aren’t diametrically opposed!</span></span></p>
<p><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">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!</span></p>
<h3><span style="font-family: merriweather, arial, sans-serif; color: #002d40;" data-contrast="none">Benefits of Working at CSCI</span></h3>
<ul>
<li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Competitive salaries</span></li>
<li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Generous Paid Time Off (PTO) package</span></li>
<li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Paid holidays aligned to the Federal calendar</span></li>
<li style="color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;"><span data-contrast="none">Full health benefits including medical, dental, vision, and life insurance</span><span data-ccp-props="{"335551550":6,"335551620":6}"> </span></span></li>
<li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">401(k) retirement plan</span></li>
<li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;" data-contrast="none">Team building events</span></li>
<li style="font-family: merriweather, georgia, serif; color: #002d40;" data-leveltext="" data-font="Symbol" data-listid="40" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #002d40;"><span data-contrast="none">Professional development support</span><span data-ccp-props="{"335551550":6,"335551620":6}"> </span></span></li>
</ul>
<p> </p>
<hr>
<h3><span style="font-family: montserrat light, arial, serif; color: #b4bebe;" data-contrast="none"><br>Legal</span></h3>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">CSCI complies with all applicable Federal, state, and local employment regulations. Please reach out to </span><a style="color: rgb(180, 190, 190);" href="mailto:HR@csciconsulting.com"><span data-contrast="none"><span data-ccp-charstyle="Hyperlink">HR@csciconsulting.com</span></span></a><span data-contrast="none"> with any questions.</span><span data-ccp-props="{"335551550":6,"335551620":6}"> </span></span></p>
<h4><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none"><br>Equal Employment Opportunity</span></h4>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;">All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. CSCI provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act. </span></p>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;">If you require an accommodation, please contact CSCI Human Resources for further assistance. For questions regarding the qualifications listed above, please contact the CSCI Recruiting Team.</span></p>
<h4><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none"><br>E-Verify</span></h4>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">CSCI participates in E-Verify to confirm the employment eligibility of all newly hired employees. For more information, please visit </span><a style="color: rgb(180, 190, 190);" href="http://www.dhs.gov/E-Verify"><span data-contrast="none"><span data-ccp-charstyle="Hyperlink">www.dhs.gov/E-Verify</span></span></a><span data-contrast="none">.</span><span data-ccp-props="{}"> </span></span></p>
<h4><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none"><br>California Consumer Privacy Act (CCPA) Notice</span></h4>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">As part of the application and recruitment process, CSCI Consulting, Inc. may collect personal information as described under the California Consumer Privacy Act (CCPA). </span></p>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">This information is collected solely for employment-related purposes, including evaluating your qualifications, processing your application, and complying with legal obligations.</span><span data-ccp-props="{}"> </span></span></p>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">By applying to this position, you acknowledge that you have read and understand the following notice regarding the collection of your personal information as a job applicant:</span><span data-ccp-props="{}"> </span></span></p>
<ul>
<li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">Categories of Information Collected: Personal identifiers, employment history, educational information, and any other information provided in your application or as part of the interview process.</span></li>
<li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">Purposes for Collecting Information: To review your application, assess your qualifications, and manage the hiring process.</span></li>
<li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">Retention and Security: Information collected will be retained indefinitely and will be securely stored and handled in accordance with CCPA guidelines and CSCI Consulting, Inc. policies.</span></li>
<li style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-leveltext="" data-font="Symbol" data-listid="41" data-list-defn-props="{"134233528":true,"335551500":0,"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1"><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">Rights of Applicants: Under CCPA, California residents have the right to request information about the personal data we collect, delete it, and request restrictions on certain uses. However, some information may be retained as required by law.</span><span data-ccp-props="{}"> </span></span></li>
</ul>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;"><span data-contrast="none">For further information, or to exercise your rights under the CCPA, please contact CSCI’s HR team.</span><span data-ccp-props="{}"> </span></span></p>
<h3><span style="font-family: montserrat light, arial, sans-serif; color: #b4bebe;" data-contrast="none"><br>Disclaimer</span></h3>
<p><span style="font-family: merriweather, georgia, serif; color: #b4bebe;" data-contrast="none">The above declarations are not intended to be an all-inclusive list of the duties and responsibilities of the job described, nor are they intended to be such a listing of the skills and abilities required to do the job. Rather, they are intended only to describe the general nature of the job.</span></p></div>
Skills
DRIVE/Vital IQVitalChekSnowflakeMicrosoft Azure data servicesAnalytics Cloud Environments