BI Data Analyst

Crystal Run Healthcare is one of the fastest growing multi-specialty group practices in the country. We have over 350 exceptional physicians in over 40 medical specialties with multiple practice locations focused on the healthcare needs of the Hudson Valley and lower Catskill region.

Crystal Run Healthcare offers fully accredited, all-digital radiology and laboratory services, and is a national leader in the use and advancement of electronic health records (EHR). Crystal Run Healthcare is accredited by The Joint Commission, designated by the NCQA as a level 3 Patient Centered-Medical Home, has been selected by the Centers for Medicare and Medicaid Services as one of the first 27 Accountable Care Organizations (ACO) in the nation to participate in the Medicare Shared Savings Program (MSSP). Crystal Run has also been recognized by NCQA as one of six “Early Adopters” seeking ACO accreditation in the nation. Crystal Run has the first American Academy of Sleep Medicine accredited sleep center in the region, was one of the first 16 practices across the US to be certified through the Quality Oncology Practice Initiative for its oncology care, and has the only Urgent Care in the region that is both Joint Commission Accredited and a Certified Urgent Care Center as designated by the Urgent Care Association of America.

Crystal Run Healthcare is also a national leader in Healthcare Reform and offering integrated, coordinated care for all patients, including those with common medical conditions like diabetes, high blood pressure, coronary artery disease, and congestive heart failure. Our care management data proves that patients with these conditions receive better care, demonstrated by measures that exceed national quality benchmarks. Our primary care physicians work with all patients on prevention and wellness strategies and coordinate all appropriate health screening tests such as mammograms, pap smears, immunizations and colonoscopies. Simply put, patients treated at Crystal Run Healthcare feel better and have better results.

OB SUMMARY

That Data Analyst will be responsible for developing
database solutions in accordance with written specifications and guidance from
data warehouse architects. Strong
analytical, quantitative and problem-solving abilities are required for this
position, along with thorough knowledge of relational database theory and
practice. The Data Analyst will be
expected to examine source data systems to discover data element(s) necessary
to meet the required task objectives.

DUTIES AND
RESPONSIBILITIES

• Creating detailed reports
using data reporting tools such as SQL Server Reporting Services and
making recommendations based on the results.

• Analyzing complex data
systems and documenting data elements, data flow, relationships and
dependencies.

• Developing automated and
reusable routines for extracting requested information from database
systems.

• Working in partnership
with business analysts and data architects to build relational and dimensional
warehousing systems.

• Source system data
investigation and discovery using common database analytical tools.

• Follow departmental
standards and typical database structure and naming nomenclature.

• Maintenance of current
database processes to ensure consistent results over time.

JOB REQUIREMENTS

• Minimum three (3) years of
experience with creating database queries, stored procedures, SSIS package
creation, deployment and debugging in a healthcare IT/BI environment.

• Strong background in all
aspects of database technology, with an emphasis on the use of ETL, analytical
and reporting tools.

• Proficient
in SQL Programming

• Bachelor’s degree in
computer science, information systems or a related field, plus several
years of experience working with major database platforms, such as
Microsoft SQL Server, Oracle and IBM DB2. Microsoft SQL Server is preferred.

All your information will be kept confidential according to EEO guidelines.