Data Architect
Crystal Run Healthcare
Data Architect
Crystal Run Healthcare
Multi-specialty medical group serving Hudson Valley
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
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
All your information will be kept confidential according to EEO guidelines.
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.
Explore more opportunities at Crystal Run Healthcare