Analytics Data Engineer II/III
5 days ago
Indianapolis
Job DescriptionDescriptionThe 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 Essential Functions:Essential functions include the following. Other duties may be assigned. • 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., • 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 Education:, • Bachelor’s or advanced degree in computer science, engineering, analytics, or a related fieldSkills and Experience:, • For the mid-level/II data engineer:, • 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, • For the senior-level/III data engineer:, • 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, • For both roles:, • 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.), • Experience with EDI/claims data (837/835), • Experience with IHIE data flows, INPC, CareWeb, or other HIE-related systems IHIE is one of the nation’s largest and most advanced health information exchanges, helping to ensure health information is where it needs to be, when it needs to be there to improve care coordination and patient outcomes. IHIE was formed in 2004 and currently serves 120+ hospitals representing 38 health systems, nearly 19,000 practices and over 50,000 providers, and has processed more than 16 billion clinical data transactions. Learn more at .