Analytics Data Engineer II/III
Indiana Health Information Exchange
full-time
Posted on:
Location Type: Hybrid
Location: Indianapolis • United States
Visit company websiteExplore more
About the role
- 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!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PL/SQLSQLOracle 12cOracle 19cdata modelingquery optimizationanalytic functionsvisualization toolsreporting toolsbulk operations
Soft skills
analytical skillsproblem-solving skillscritical-thinking skillsattention to detailcommunication skillscollaboration skillsself-motivatedproactiveadaptablepassion for learning