Indiana Health Information Exchange

Data Engineer II

Indiana Health Information Exchange

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

JavaJavaScriptOraclePythonSQLTableau

About the role

  • 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 an experienced Oracle-focused Analytics Data Engineer II to support IHIE’s data roadmap and build high-quality data assets that power clinical insights, products, and customer-facing analytics. This role requires 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 Oracle Data Engineer II serve as technical contributor responsible for building and optimizing IHIE’s analytic datasets, data quality pipelines, and customer-facing data deliverables. This individual is a subject matter expert in Oracle SQL, PL/SQL, data modeling, and healthcare data standards. This individual collaborates closely with Solution Engineering, Product, and business stakeholders to ensure data assets are accurate, performant, and aligned with organizational priorities.************Job Function Risk Level 3: **Privileged user access with intentional access to PHI and sensitive data

Requirements

  • **IHIE Attributes:**
  • - 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 field
  • **Skills and Experience:**
  • - 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
  • - 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
  • - Experience supporting customer-facing data products
Benefits
  • In exchange for your drive and analytics experience, we offer an excellent benefits package including 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, and a dynamic, fun-loving company culture!****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 www.ihie.org.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Oracle 12cOracle 19cSQLPL/SQLdata modelingdata quality pipelinesanalytic functionsquery optimizationvisualization toolsreporting tools
Soft Skills
adaptabilityself-motivatedproblem-solvingcritical-thinkingcommunication skillscollaboration skillsattention to detailpositive attitudecreativityflexibility