Business Intelligence Analyst

Summary

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 DescriptionOB SUMMARYThat 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 RESPONSIBILITIESCreating 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.QualificationsJOB REQUIREMENTSMinimum 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 ProgrammingBachelor'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 InformationAll your information will be kept confidential according to EEO guidelines.#J-18808-Ljbffr

Job 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 DescriptionOB SUMMARYThat 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 RESPONSIBILITIESCreating 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.QualificationsJOB REQUIREMENTSMinimum 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 ProgrammingBachelor'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 InformationAll your information will be kept confidential according to EEO guidelines.#J-18808-Ljbffr