Analytics Data Engineer II/III

Indiana Health Information Exchange•Indianapolis, IN

5h•Hybrid

About The Position

The Indiana Health Information Exchange (IHIE) is one of the nation’s largest health information exchange organizations. IHIE has been around for over a decade, with its roots dating back 30 years. As a not-for-profit HIE, we enable hospitals, physicians, laboratories, payers, and other health service providers to avoid redundancy and deliver faster, more efficient, higher quality healthcare to patients in Indiana. Today, by making information available to approximately 50,000 healthcare providers in Indiana and neighboring states, we deliver services that make a real difference in health and healthcare. We are seeking two experienced, Oracle-focused Analytics Data Engineers (a mid-level/II and a senior-level/III) to support IHIE’s data roadmap and build high-quality data assets that power clinical insights, products, and customer-facing analytics. These roles require highly skilled engineers who understand Oracle performance tuning, healthcare data standards, and the practical realities of designing pipelines at scale. If you are talented, driven, collaborative, and enjoy solving complex data problems that make a difference, IHIE is a great place to grow. Summary: The Analytics Data Engineers II and III serve as technical contributors responsible for building and optimizing IHIE’s analytic datasets, data quality pipelines, and customer-facing data deliverables. These individuals are a subject matter expert in Oracle SQL, PL/SQL, data modeling, and healthcare data standards. They collaborate closely with Solution Engineering, Product, and business stakeholders to ensure data assets are accurate, performant, and aligned with organizational priorities. This is a hybrid position based in Indianapolis, Indiana, with a blend of in-office and remote work. At this time, we are only considering candidates that live in or near the Indianapolis area. Job Function Risk Level 3: Privileged user access with intentional access to PHI and sensitive data

Requirements

Adaptability and flexibility in a rapidly changing environment
Self-starter and self-motivated
Ambitious spirit – brings fresh ideas to the table and finds creative solutions to problems
Positive attitude with outstanding communication and listening skills
Bachelor’s or advanced degree in computer science, engineering, analytics, or a related field
Proven experience (5+ years) working with Oracle 12c/19c (or newer) in a production environment.
Advanced-level SQL and PL/SQL, including: Packages, procedures, triggers, functions, collections, bulk operations Error handing and logging frameworks
Proven experience (8+ years) working with Oracle 12c/19c (or newer) in a production environment.
Expert-level SQL and PL/SQL, including: Packages, procedures, triggers, functions, collections, bulk operations Error handing and logging frameworks
Strong experience with analytic/window functions, query optimization, partitioning, materialized views, DBMS packages, UTL_MATCH.
Experience designing data models and staging structures for high-volume, heterogeneous healthcare data.
Experience (3+ years) working with healthcare data is required.
Demonstrated experience with visualization tools (Tableau or similar) and reporting tools.
Excellent analytical, problem-solving, and critical-thinking skills, with a keen attention to detail and a commitment to delivering high-quality results
Strong communication and collaboration skills, with the ability to effectively communicate technical concepts and insights to both technical and non-technical stakeholders
Self-motivated, proactive, and adaptable, with a passion for learning and staying abreast of the latest developments in data analytics and technology
Familiarity with HL7, C-CDA, FHIR, USCDI, and other healthcare formats and standards.
Familiarity with clinical terminologies and ontologies like LOINC, ICD-10-CM/PCS, SNOMED-CT, RxNorm, etc.

Nice To Haves

Ability to read a variety of programming languages (Java, JavaScript, Python, etc.)
Experience with EDI/claims data (837/835)
Experience with IHIE data flows, INPC, CareWeb, or other HIE-related systems
Experience supporting customer-facing data products

Responsibilities

Collaborate with cross-functional teams to understand business requirements and recommend data solutions that address key challenges and opportunities.
Design, develop, and optimize PL/SQL packages, procedures, functions, and bulk-processing routines.
Utilize advanced analytics techniques and tools to analyze large datasets, identify trends, patterns, and correlations, and derive actionable insights.
Identify data quality issues related to clinical transactions, terminology mappings, and source system variations and collaborate with cross-functional teams to remediate.
Develop interactive dashboards, visualizations, and reports to communicate findings and insights effectively to stakeholders at all levels of the organization.
Directly engage or oversee data projects with customers or partners, including data onboarding, data exports, reports, dashboards, and visualizations.
Provide data expertise and guidance, as needed, for new business development opportunities.
Maintain a strong understanding of IHIE’s data flows, clinical data structures, and product ecosystem.