Sql data analyst [h1.location_city]

Job Description

Job Description

At Habitat Health, we envision a world where older adults experience an independent and joyful aging journey in the comfort of their homes, enabled by access to comprehensive health care. Habitat Health provides personalized, coordinated clinical and social care as well as health plan coverage through the Program of All-Inclusive Care for the Elderly ("PACE") in collaboration with our leading healthcare partners, including Kaiser Permanente.

Habitat Health offers a fully integrated experience that brings more good days and a sense of belonging to participants and their caregivers. We build engaged, fulfilled care teams to deliver personalized care in our centers and in the home. And we support our partners with scalable solutions to meet the health care needs and costs of aging populations.

Habitat Health is growing, and we're looking for new team members who wish to join our mission of redefining aging in place. To learn more, visit https : / / www.habitathealth.com.

Role Scope :

• Use SQL to analyze clinical, operational, financial, and administrative data generated in Epic's electronic health record (EHR) and practice management (PM) systems and stored in Epic's back-end Clarity data model.
• Leverage Epic's in-app reporting tools including Slicer Dicer, Reporting Workbench (RWB), and Radar to answer data questions from internal Habitat customers in the simplest / easiest / most scalable way possible.
• Enable leadership to make evidence-based decisions by designing, building, and maintaining business intelligence dashboards and data pipelines using tools such as Power BI, SQL, and Git
• Work with engineering to design and develop ETL processes that support consistent KPI reporting via Data Marts with clear documentation that codifies our standard "business rules" layer
• Develop rigorous data quality tests, QC best practices, code reviews / Git pull requests, dashboard release processes, and proper documentation to ensure your work is accurate and clearly communicated
• Develop detailed clinical logic and code sets for patient cohorts and quality measures including diagnosis groupers, hospital admissions, readmissions, ED visits, SNF visits etc. across a wide range of clinical facts and dimensions
• Build externally facing reports including PACE-specific measures and CMS / Medicaid regulatory and audit reporting in a scalable manner
• Work closely with other data team members to ensure you benefit from all the great work happening around you!

Qualifications :

Nice to have :

Compensation :

We take into account an individual's qualifications, skillset, and experience in determining final salary. This role is eligible for medical / dental / vision insurance, short and long-term disability, life insurance, flexible spending accounts, 401(k) savings, paid time off, and company-paid holidays. The expected salary range for this position is $90,000- $105,000 and is bonus-eligible. The actual offer will be at the company's sole discretion and determined by relevant business considerations, including the final candidate's qualifications, years of experience, skillset, and geographic location.

Vaccination Policy, including COVID-19

At Habitat Health, we aim to provide safe and high-quality care to our participants. To achieve this, please note that we have vaccination policies to keep both our team members and participants safe. For covid and flu, we require either proof of vaccination or declination form and required masking while in participant locations as a safe as an essential requirement of this role. Requests for reasonable accommodations due to an applicant's disability or sincerely held religious beliefs will be considered and may be granted based upon review. We also require that team members adhere to all infection control, PPE standards and vaccination requirements related to specific roles and locations as a condition of employment.

Our Commitment to Diversity, Equity, and Inclusion :

Habitat Health is an Equal Opportunity employer and is committed to creating a diverse and inclusive workplace. Habitat Health applicants are considered solely based on their qualifications, without regard to race, color, religion, creed, sex, gender (including pregnancy, childbirth, breastfeeding or related medical conditions), gender identity, gender expression, sexual orientation, marital status, military or veteran status, age, national origin, ancestry, citizenship, physical or mental disability, medical condition, genetic information or characteristics (or those of a family member), or other status protected by applicable law.

Habitat Health is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Habitat Health will take steps to provide people with disabilities and sincerely held religious beliefs with reasonable accommodations in accordance with applicable law. Accordingly, if you require a reasonable accommodation to fully participate in the job application or interview process, to perform the essential functions of the position, and / or to receive all other benefits and privileges of employment, please contact us at careers@habitathealth.com.

Beware of Scams and Fraud

Please ensure your application is being submitted through a Habitat Health sponsored site only. Our emails will come from @habitathealth.com email addresses. If you feel that you have been the victim of a scam such as this, please report the incident to the Federal Trade Commission by selecting the 'Rip-offs and Imposter Scams' option : https : / / reportfraud.ftc.gov / # / .