Data Architect

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

The Data Architect position requires a high level of
analytical and creative skills, along with in-depth knowledge of data systems
and database methodology, design and modeling.
The Data Architect
will be responsible for designing logical models for relational and
multi-dimensional data stores and subsequently building the physical database
model. The architect defines
data/information architecture standards, processes and data warehouse policies
and procedures. This role facilitates standard business analysis practices and
their translation into functional technical requirements that are integrated
into the enterprise information system architecture. The Data Architect ensures
enterprise solution development is suitable to achieve consistency of
information assets across the application framework.

DUTIES AND
RESPONSIBILITIES

• Perform source system analysis and meet with
  business stakeholders in order to create appropriate requirement definition
  artifacts.

• Work closely with Business Intelligence Analysts, Data
  Analysts and Software Developers to ensure customer needs are being met in the
  areas of reporting and analytics.

• Design and develop highly scalable and optimized
  data models, by utilizing modeling software to document and maintain versions
  to 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 efficient
  and accurate data transfer within the entire BI System.

• Assist with optimizing source system replication
  models and operations

• Implement a robust data solution using available
  database tools.

• Design and maintain enterprise meta-data solution to
  communicate data definitions to the BI audience.

• Design and develop data quality rules for Data
  Warehouse and Data Mart solutions to ensure data integrity levels are met.

• Research new database technologies and recommend
  solutions in order to improve performance, scalability, & storage.

• Must be able to communicate timely and
  effectively in order to plan and coordinate team resources.

• Train, lead, and mentor staff that may include
  database engineers, data architects, and DBAs

• Providing leadership in establishing and
  documenting data standards

• Creating and testing database prototypes

Qualifications

JOB REQUIREMENTS

• Bachelor’s degree in computer science,
  information systems or a related field, Masters preferred; or equivalent relevant
  experience

• Minimum 7 years of experience 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.

• Experience with building and maintaining physical
  and logical database models

• Knowledge of a typical Software Design Lifecycle
  (SDLC)

• Knowledge of Master & Meta data management
  tools and techniques

• Experience with MS SQL Server and the MS development
  stack

• Knowledge of clinical and financial systems within
  a Healthcare environment desired

• Knowledge of Data profiling and data validation
  tools

• Knowledge of Data Matching, Data Monitoring, Data
  Enrichment & Data Standardization

Additional Information

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