Company DescriptionCrystal 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 DescriptionThe Data Architect position requires a high level ofanalytical and creative skills, along with in-depth knowledge of data systemsand database methodology, design and modeling. The Data Architectwill be responsible for designing logical models for relational andmulti-dimensional data stores and subsequently building the physical databasemodel. The architect definesdata/information architecture standards, processes and data warehouse policiesand procedures. This role facilitates standard business analysis practices andtheir translation into functional technical requirements that are integratedinto the enterprise information system architecture. The Data Architect ensuresenterprise solution development is suitable to achieve consistency ofinformation assets across the application framework. DUTIES ANDRESPONSIBILITIESPerform source system analysis and meet withbusiness stakeholders in order to create appropriate requirement definitionartifacts.Work closely with Business Intelligence Analysts, DataAnalysts and Software Developers to ensure customer needs are being met in theareas of reporting and analytics.Design and develop highly scalable and optimizeddata models, by utilizing modeling software to document and maintain versionsto support Data Marts, Cubes, Data Warehouse, and Operational Data Stores(ODS).Develop data standards in terms of nomenclature,storage, design and deployments.Design ETL and ELT guidelines to ensure efficientand accurate data transfer within the entire BI System.Assist with optimizing source system replicationmodels and operationsImplement a robust data solution using availabledatabase tools.Design and maintain enterprise meta-data solution tocommunicate data definitions to the BI audience.Design and develop data quality rules for DataWarehouse and Data Mart solutions to ensure data integrity levels are met.Research new database technologies and recommendsolutions in order to improve performance, scalability, & storage.Must be able to communicate timely andeffectively in order to plan and coordinate team resources.Train, lead, and mentor staff that may includedatabase engineers, data architects, and DBAsProviding leadership in establishing anddocumenting data standardsCreating and testing database prototypesQualificationsJOB REQUIREMENTSBachelor’s degree in computer science,information systems or a related field, Masters preferred; or equivalent relevantexperienceMinimum 7 years of experience in computerscience, information systems or a related field, plus several years ofexperience working with major database platforms, such as Microsoft SQL Server,Oracle and IBM DB2. Microsoft SQL Serveris preferred.Experience with building and maintaining physicaland logical database modelsKnowledge of a typical Software Design Lifecycle(SDLC)Knowledge of Master & Meta data managementtools and techniquesExperience with MS SQL Server and the MS developmentstackKnowledge of clinical and financial systems withina Healthcare environment desiredKnowledge of Data profiling and data validationtoolsKnowledge of Data Matching, Data Monitoring, DataEnrichment & Data Standardization Additional InformationAll your information will be kept confidential according to EEO guidelines.