Data Analyst
Essen Health Care is an integrated healthcare delivery organization that provides high quality, compassionate, and accessible medical care to many of the most under-served residents of New York State. Guided by a population health model of care delivery, Essen’s patient-centric approach is focused on meeting patient needs in all care settings. Founded in 1999, Essen clinicians provide care in all five boroughs of New York City. With 150 primary and specialty care physicians and almost 100 advanced clinicians, Essen Health Care is one of the largest, most comprehensive private medical groups in New York City, and is recognized for excellence in patient satisfaction and clinical care. With five clinical divisions, patient care is provided in medical offices, 16 urgent care centers, hospitals, and nursing homes, as well as directly to patients in their homes. The Care Management division cares for the community by addressing social determinants of health through RNs, care managers and care coordinators. Essen clinicians provide quality care for nearly 30,000 patient lives across our five clinical divisions. Essen was one of the initial practices to have achieved ‘Level 3 Patient Centered Medical Home’ designation in New York by the National Committee for Quality Assurance. In 2018, Essen Health Care was nominated for the Heritage Innovation Award. Essen continues to expand and grow in the five boroughs while extending its breadth of services and continuing to provide the communities with leading edge care.
Essen is currently seeking a Full-time Data Analyst for our IT Department. The selected candidate will be responsible for gathering and analyzing healthcare data from multiple sources (e.g. insurance processing, clinical operations, and patient behavior) to extract trends and business insights. Then evaluates encounter data and identifies errors created by operational processes, claims and eligibility processes. Must research the analysis and categorize the encounter. The primary responsibility for this position is to fully support the ongoing healthcare business intelligence and data analytics objectives. To succeed in this role, you should be analytical, resourceful and works under moderate supervision.
Essen is seeking an individual who is skilled in the use of Power BI, Excel, SharePoint and SQL databases for data analysis with scripting via Python.
The selected candidate will be responsible to perform daily Physicians duties including but not limited to:
- Provides consulting and analytic services to leadership, operations and finance.
- Monitors encounter data from various databases and creates monthly, quarterly and ad-hoc reports
- Deliver reports in pre-defined formats based on submitted and agreed upon requirements
- Analyze, present and explain information in accessible and actionable way (i.e. budgeting reports, cost and claims or clinical data)
- Summarizes large volumes of encounter data in analytical reports that include tables and graphs for management review and use
- Reviews and ensures accuracy of all ad-hoc and automated reports and corrects discrepancies
- Programs using Excel and SQL or other appropriate software to generate reports based on input/direction from management and other report users
- Collaborates with other departments and vendors to identify missing data, errors or other anomalies; works with them to correct these encounter data errors, gather necessary information and provide guidance on regulatory reporting needs
- Building models and analyzing data to discover discrepancies and patterns
- Pull and integrate data from disparate sources (i.e. budgeting reports, cost and claims or clinical data)
- Collaborate with management and internal teams to implement and evaluate improvements
- Expert knowledge of MS Excel
- Strong knowledge of SQL – Formulate analytic questions as database queries
- Strong hands-on familiarity with eClinicalWorks (ECW)
The successful candidate will have the following Qualifications:
- Bachelor’s degree in health services research, actuarial science, statistics, or economics OR minimum four (4) years of data analyst or related experience, including proficiency with analytical software.
- At least 1-year experience Data Mining complex sets and formulating custom reports.
- Experience performing data analysis from ECW, Claims, Rosters, etc. in a health care or health plan organization, required.
- Formal informatics training a plus.
- Strong analytic and reporting skills required.
- Effective oral, written and interpersonal communication skills required.
ESSEN HEALTH CARE IS PROUD TO BE AN EQUAL OPPORTUNITY EMPLOYER
Essen Health care is proud to be an equal opportunity employer, and we seek candidates who desire to work in and serve an ethnically diverse population.