C

Crystal Run Healthcare

Multi-specialty medical group serving Hudson Valley

Data Architect

Data ManagementConfirmed live in the last 24 hours
Full-timeMiddletown, NY, USANo salary listedIn-person

About the Job

Requirements

  • A bachelor's degree in computer science, information systems, or a related field, or equivalent relevant experience.
  • A minimum of 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.
  • Experience building and maintaining physical and logical database models.
  • Knowledge of a typical Software Development Lifecycle (SDLC).
  • Knowledge of master and metadata management tools and techniques.
  • Experience with Microsoft SQL Server and the Microsoft development stack.
  • Knowledge of data profiling and data validation tools.
  • Knowledge of data matching, data monitoring, data enrichment, and data standardization.

Responsibilities

  • Design logical models for relational and multidimensional data stores and build the physical database model.
  • Define data and information architecture standards, processes, and data warehouse policies and procedures.
  • Facilitate standard business analysis practices and translate them into functional technical requirements integrated into the enterprise information system architecture.
  • Ensure enterprise solution development achieves consistency of information assets across the application framework.
  • Perform source system analysis and meet with business stakeholders to create appropriate requirement definition artifacts.
  • Work closely with Business Intelligence Analysts, Data Analysts, and Software Developers to ensure customer needs are met for reporting and analytics.
  • Design and develop scalable and optimized data models using modeling software to document and maintain versions supporting Data Marts, Cubes, Data Warehouses, and Operational Data Stores (ODS).
  • Develop data standards for nomenclature, storage, design, and deployments.
  • Design ETL and ELT guidelines to ensure efficient and accurate data transfer within the BI system.
  • Assist with optimizing source system replication models and operations.
  • Implement a robust data solution using available database tools.
  • Design and maintain an enterprise metadata 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 to improve performance, scalability, and storage.
  • Communicate in a timely and effective manner to plan and coordinate team resources.
  • Train, lead, and mentor staff, potentially including database engineers, data architects, and DBAs.
  • Provide leadership in establishing and documenting data standards.
  • Create and test database prototypes.

Desired Qualifications

  • A master's degree.
  • Microsoft SQL Server is preferred.
  • Knowledge of clinical and financial systems within a healthcare environment.

About the Company

Crystal Run Healthcare

Multi-specialty medical group serving Hudson Valley

Crystal Run Healthcare is a large, multi-specialty medical group in New York’s Hudson Valley and lower Catskills, with more than 375 physicians and advanced practice clinicians across 50+ medical and surgical specialties. It provides primary and specialty care through multiple practice locations, offering coordinated care across its network as part of Optum. The model centers on a broad range of clinical services delivered by a large team at many locations, with care integrated across clinics and specialties for patients. This makes Crystal Run Healthcare different from smaller practices by combining extensive specialty coverage, multiple locations, and an alignment with Optum to support care coordination and resources for patients and clinicians. The company’s goal is to redefine and transform health and well-being for the community, improving access, quality, and outcomes through its expansive network and community-focused initiatives like Transforming Health in the Hudson Valley.

Company size
501-1,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Middletown, CT
Founded
1996

Recently Posted Jobs

Explore more opportunities at Crystal Run Healthcare

See more jobs