Sr. BI Engineer - Real World Data (lima)

BI Engineer

Qualifacts is a leading provider of behavioral health software and SaaS solutions for clinical productivity, compliance and state reporting, billing, and business intelligence. Its mission is to be an innovative and trusted technology and end-to-end solutions partner, enabling exceptional outcomes for its customers and those they serve. Qualifacts' comprehensive portfolio, including the CareLogic®, Credible™, and InSync® platforms, spans and serves the entire behavioral health, rehabilitative, and human services market supporting non-profit Certified Community Behavioral Health Clinics (CCBHC) as well as for-profit large enterprise and small business providers. Qualifacts has a loyal customer base, with more than 2,500 customers representing 75,000 providers serving more than 6 million patients. Qualifacts was recognized in the 2022 and 2023 Best in KLAS: Software and Services Report as having the top ranked Behavioral Health EHR solutions.

2 days per week in office.

The Opportunity

The BI Engineer designs, tests and develops data sets through the use of BI tools, technologies and systems. Analyzes complex data requirements and develops technical and/or process solutions to meet business needs. Works collaboratively with technical and product management team in all phases of projects, potentially including requirements validation, QA Support, Development and Deployment Support.

Your Responsibilities

• Design, develop, implement and maintain data sets to support our Real World Data/Evidence (RWD/RWE) business needs, following BI development best practices and innovative use of appropriate technologies and systems.
• Work collaboratively with technical and product management team to deliver technical solutions.
• Work effectively in all phases of application development projects, potentially including requirements validation, design, testing, development and deployment support.
• Execute ad hoc dimensional data modelling to create analytics models for internal and external stakeholders.
• Provide end-user support for RWD/RWE determination, including investigation and resolution of reported issues in a timely manner.

Qualifications

• Advanced work experience related to Real World Data/Real World Evidence.
• Experience utilizing 837 healthcare claims and EMR data (nice to have: 835 remittance, chargemaster, SDOH, lab, biomarker/genetic testing, NCPDP D.0 pharmacy, imaging).
• Familiarity with RWD research including persistency, compliance, line of therapy, patient journey, epidemiology, market sizing, physician targeting.
• Knowledge of healthcare billing codes such as ICD, CPT, HCPCS, and NPI.
• Proven ability to translate high-level requirements into actionable development plans and drive execution to completion.
• Strong experience with ETL Development tools (nice to have: Snowflake, DBT Core/Cloud, etc.).
• Ideal exp. with Apache Airflow.
• Advanced SQL.
• R/Python development experience.
• Hands-on experience in business intelligence, reporting, and analytics, with experience in creating algorithms, formulas and calculations.
• Advanced Knowledge of dimensional data modeling.

What We Offer You

• Economic bonus and merit review.
• Full Health Insurance (EPS and oncologic) for you and your direct dependents.
• Fully paid English lessons.
• All legal benefits (CTS, 30-day paid vacation per year, life insurance, etc.).

Qualifacts is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.