Hybrid Analytics Data Engineer II/III

at Indiana Health Information Exchange

• Job title: Analytics Data Engineer II/III
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Java, JavaScript, Oracle, Python, SQL, Tableau
• Location requirements: Hybrid, Indianapolis, United States

About the role

• Analytics Data Engineer supporting IHIE's data roadmap by designing pipelines and optimizing datasets. Requires collaboration with teams to enhance healthcare data analytics in Indiana.

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.

Requirements

• 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 (for the mid-level/II data engineer)
• 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 (for the senior-level/III data engineer)
• 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.
• Preferred: Ability to read a variety of programming languages (Java, JavaScript, Python, etc.)
• Preferred: Experience with EDI/claims data (837/835)
• Preferred: Experience with IHIE data flows, INPC, CareWeb, or other HIE-related systems
• Preferred: Experience supporting customer-facing data products

Benefits

• medical/dental/vision
• 401(k) matching
• 20 days PTO your first year plus 9 company paid holidays
• Summer hours
• student loan repayment/529 account save-up programs
• a very casual work environment and dress code
• a dynamic, fun-loving company culture!