Lead Data Integration Architect

Job not on LinkedIn

🔥 0 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

📊 Data Scientist

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CSCI Consulting

WebsiteLinkedInAll Job Openings

201 - 500 employees

💼 Consulting

🏢 Enterprise

Consulting • Enterprise

CSCI Consulting is a nationally-recognized consulting firm that specializes in management consulting, enterprise IT, and financial management services. The company serves clients in federal, state, and commercial markets. CSCI Consulting is dedicated to enhancing client projects with extensive capabilities in project life-cycle management, improving technical environments, and supporting financial transparency and audit readiness. The firm prides itself on a people-first culture, promoting teamwork, learning, and career growth among its employees.

📋 Description

• 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 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 • Assess API, ETL, batch, real-time, near-real-time, and event-driven integration patterns • Identify undocumented interfaces, operational dependencies, architectural risks, inefficiencies, and constraints • Develop integration diagrams, data-flow diagrams, interface inventories, and dependency maps • Evaluate Snowflake, Microsoft Azure data services, cloud data warehouses, data lakes, data lakehouses, and Analytics Cloud Environments • Assess governed data sharing and secure self-service analytics opportunities • 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 replacing or reducing reliance on the existing DRIVE replica • Recommend real-time, near-real-time, batch, API-based, and data-sharing approaches • Document benefits, risks, dependencies, assumptions, limitations, and implementation considerations for architecture options • Develop a conceptual future-state architecture and modernization roadmap • Support implementation sequencing, staffing assumptions, level-of-effort estimates, and Rough Order of Magnitude cost estimates • Contribute to gap analysis, findings, executive summary, and presentation materials • Present technical findings and recommendations to technical and executive stakeholders • Collaborate with project management, business analysis, security, governance, and cost-estimation resources • Ensure recommendations are secure, scalable, supportable, vendor-neutral, and aligned with IDOH’s long-term data-modernization objectives

🎯 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 • E-Verify employment eligibility required for newly hired employees

🏖️ Benefits

• 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