C

Crystal Run Healthcare

Multi-specialty medical group serving Hudson Valley

BI Data Analyst

Full-Time
No salary listed
Mid
Bachelor's
Middletown, NY, USA
In Person
Data & AnalyticsBusiness Intelligence

About the job

Requirements
  • At least three years of experience creating database queries, stored procedures, and SSIS packages, including package creation, deployment, and debugging, in a healthcare information technology or business intelligence environment.
  • Strong background in database technology, especially extract, transform, and load processes and analytical and reporting tools.
  • Proficiency in SQL programming.
  • A Bachelor's degree 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.
Responsibilities
  • Create detailed reports using data reporting tools such as SQL Server Reporting Services and make recommendations based on the results.
  • Analyze complex data systems and document data elements, data flow, relationships, and dependencies.
  • Develop automated and reusable routines for extracting requested information from database systems.
  • Partner with business analysts and data architects to build relational and dimensional data warehousing systems.
  • Investigate and discover source-system data using common database analytical tools.
  • Follow departmental standards and typical database structure and naming nomenclature.
  • Maintain current database processes to ensure consistent results over time.
Desired Qualifications
  • Microsoft SQL Server experience is preferred.

About the company

C

Crystal Run Healthcare

View

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

N/A

Total Funding

N/A

Headquarters

Middletown, Connecticut

Founded

1996

Get referred to Crystal Run Healthcare

See people who can refer or advise you

Simplify Jobs

Simplify's Take

What believers are saying

  • West Nyack and other locations still advertise weekend primary care and extended hours in 2026.
  • Optum’s ownership brings capital, negotiated contracts, and referral capture across UnitedHealthcare lives.
  • Value-based care integration can reduce leakage and improve margins if volumes stay stable.

What critics are saying

  • Optum is negotiating 2026 sales of orthopedics, general surgery, and urology practices.
  • News 12 reported 2024-2025 layoffs of lab staff and 100 business-office workers in Middletown.
  • Ongoing unbundling turns Crystal Run into a feeder network, not an independent employer.

What makes Crystal Run Healthcare unique

  • UnitedHealth folded Crystal Run into Optum in February 2023, giving payer-provider integration.
  • Crystal Run still operates 12 Hudson Valley sites with 50+ specialties and 375 clinicians.
  • Its primary-care-plus-specialty footprint lets Optum steer referrals, labs, and ambulatory volume internally.

Help us improve and share your feedback! Did you find this helpful?

Growth & Insights and Company News

6 month growth

3%

1 year growth

3%

2 year growth

3%
Mid Hudson News
Oct 21st, 2023
Crystal Run Healthcare physicians named in the 2023 Castle Connolly "Top Doctor's Guide"

Crystal Run Healthcare physicians named in the 2023 Castle Connolly "Top Doctor's Guide"

Ermer & Suter, PLLC
Apr 12th, 2023
Tuesday's Tidbits

“UnitedHealth Group has acquired Crystal Run Healthcare, a prominent physician group in New York.

PYMNTS
Apr 11th, 2023
UnitedHealth Group Acquires New York-Based Physician Group

UnitedHealth Group has reportedly acquired New York-based Crystal Run Healthcare.

STAT
Apr 10th, 2023
UnitedHealth’s physician buying spree continues with takeover of Crystal Run

UnitedHealth Group quietly acquired Crystal Run Healthcare, a physician group in New York that has been burned by some recent failures.

Hudson Valley Magazine
Sep 12th, 2022
Crystal Run Healthcare launches The Healthy Dose

A. Crystal Run Healthcare has launched a new podcast called The Healthy Dose, a health and wellness podcast.