BI Data Analyst

  • Full-time

Company Description

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.

Job Description

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.

Qualifications

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.

Additional Information

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