Data Architect

Crystal Run Healthcare; City of Middletown (NY); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Confidentiality in accordance with EEO guidelines

Job summary

Crystal Run Healthcare in Middletown, NY is seeking an experienced Data Architect to design and manage complex data models. This role involves working closely with Business Intelligence Analysts and Software Developers to ensure effective data management and reporting.

Candidates should have a Bachelor’s degree, with a preference for a Master’s, and a minimum of 7 years in relevant experience, particularly with Microsoft SQL Server. A deep understanding of healthcare data systems is desired, along with strong communication and leadership skills.

Qualifications

• Minimum of 7 years of experience in data-related roles.
• Experience with major database platforms.
• Knowledge of Software Design Lifecycle (SDLC) and data management tools.

Responsibilities

• Design relational and multi-dimensional data stores.
• Collaborate with analysts and developers for data solutions.
• Implement data standards and optimize data transfer.

Skills

Data modeling

ETL/ELT guidelines

Database technologies

Communication skills

Education

Bachelor’s degree in computer science or related field

Master’s preferred

Tools

Microsoft SQL Server

Oracle

IBM DB2

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 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

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.