Reporting & Data Integration Analyst

Wexford Health Sources, Inc.

Pittsburgh (Allegheny County)

On-site

USD 70,000 - 95,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health insurance
401(k) retirement savings plan with401
Paid time off
Paid holidays
Continuing education
CEUs
Dental and Vision insurance
Flexible pay options

Job summary

Wexford Health Sources, Inc. is seeking a Reporting & Data Integration Analyst to turn complex healthcare data into actionable insights. You will develop SQL queries, SSIS packages, and automated reports to support clinical and operational decisions.

Collaborating with clinical, IT, and operations teams, you will ensure data accuracy, maintain documentation, and uphold privacy standards while delivering reliable analytics across the organization.

Qualifications

  • Experience in systems analysis, reporting, data integration, or a related technical role.
  • Strong Microsoft SQL Server and T-SQL skills, including complex queries, stored procedures, and troubleshooting.
  • Hands-on experience developing and maintaining SSIS packages.
  • Advanced Microsoft Excel skills, including formulas, PivotTables, lookups, and Power Query.
  • Understanding of relational databases, data validation, and reporting processes.

Responsibilities

  • Develop, maintain, and troubleshoot SQL queries, stored procedures, and views to support reporting and data analysis.
  • Build and support SSIS packages to integrate data across multiple systems and ensure accuracy.
  • Create advanced Excel reports, dashboards, and automated reporting solutions for clinical and operational needs.
  • Collaborate with clinical, operational, and IT teams to translate reporting requirements into technical solutions.
  • Monitor data processes, resolve discrepancies, and improve reporting efficiency and data quality.

Skills

SQL
SSIS
Excel
PivotTables
Power Query
Relational databases
Data validation
Analytical thinking
Communication
Problem-solving
Organizational skills

Tools

SQL Server
SSIS
Power BI
SSRS
Cognos
Access

Job description

POSITION: Reporting & Data Integration Analyst
SCHEDULE: Monday-Friday 8am-4:30pm
FACILITY: WHS Corporate Office – onsite
LOCATION: Greentree, Pittsburgh, PA

Are you ready to turn complex data into meaningful insights that improve healthcare operations and drive smarter decisions?

Wexford Health Sources, Inc. has been a leader in correctional healthcare for over 30 years, delivering compassionate, patient-centered care to underserved populations. As a Reporting Analyst, you'll use your technical expertise to develop reliable reporting solutions, streamline data processes, and support informed decision-making across our organization.

Position Summary

As a Reporting Analyst – Reporting & Data Integration, you'll support healthcare reporting and operational analytics by developing SQL queries, managing data integration processes, and delivering accurate, actionable reports. Your responsibilities will include:

  • Developing, maintaining, and troubleshooting SQL queries, stored procedures, and views to support reporting and data analysis
  • Building and supporting SSIS packages to integrate data across multiple systems and ensure accuracy and reliability
  • Creating advanced Excel reports, dashboards, and automated reporting solutions to support clinical and operational needs
  • Collaborating with clinical, operational, and IT teams to translate reporting requirements into effective technical solutions
  • Monitoring data processes, resolving discrepancies, and identifying opportunities to improve reporting efficiency and data quality
  • Maintaining documentation, supporting recurring and ad hoc reporting, and ensuring compliance with healthcare privacy and security standards

You’ll go beyond analyzing data.
You'll transform information into insights that strengthen operations, improve efficiency, and support the delivery of quality healthcare.

Why Work with Wexford Health?
  • Performance check-ins with annual merit increase
  • Generous paid-time-off program that combines vacation and sick leave
  • Paid holidays
  • Comprehensive health insurance through Blue Cross/Blue Shield
  • Dental and Vision insurance
  • 401(k) retirement savings plan with company match
  • Company-paid short-term disability and life insurance
  • Non-taxed Healthcare and dependent care spending account
  • Continuing education options
  • Free CEUs
  • Pet Insurance
  • Flexible pay options including Wisely Card and PayPal
  • Discounted Tuition at University of North Alabama, Chamberlain University, Salem University, and Southern New Hampshire University
  • Partnership discounts on student loan refinancing, home/auto insurance, travel, electronics, entertainment, restaurants, health and wellness, and more!
What You’ll Need
  • Experience in systems analysis, reporting, data integration, or a related technical role
  • Strong Microsoft SQL Server and T-SQL skills, including complex queries, stored procedures, and troubleshooting
  • Hands-on experience developing and maintaining SQL Server Integration Services (SSIS) packages
  • Advanced Microsoft Excel skills, including formulas, PivotTables, lookups, and Power Query
  • Understanding of relational databases, data validation, and reporting processes
  • Strong analytical, problem-solving, organizational, and communication skills
  • Relevant education, technical training, or an equivalent combination of experience
Preferred Qualifications
  • Experience with Microsoft Access, Power BI, Cognos, or SQL Server Reporting Services (SSRS)
  • Familiarity with healthcare data, electronic health records, or correctional healthcare reporting
  • Experience with SQL Server Agent jobs and automated reporting workflows

Equal Opportunity Employer
We celebrate diversity and welcome all qualified candidates.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Healthcare Data Integration & Reporting Analyst
Healthcare Data Integration & Reporting Analyst

Wexford Health Sources, Inc. • Pittsburgh

On-site
USD 70,000 - 95,000
Health insurance
401(k) retirement savings plan with401
Paid time off
+5
Senior / Clinical Data and Coding Analyst
Senior / Clinical Data and Coding Analyst

Greater Baden Medical Services, Inc. • Brandywine (MD)

Hybrid
USD 80,000 - 110,000
Senior Data Analyst
Senior Data Analyst

Sccs4kids • Mission Viejo (CA)

Hybrid
USD 80,000 - 100,000
Business Intelligence Developer
Business Intelligence Developer

Powers Health • United States

On-site
USD 90,000 - 110,000
Medical, dental & vision coverage
Retirement savings plan
Paid Time Off (PTO)
+1
BI Data Analyst
BI Data Analyst

Crystal Run Healthcare • City of Middletown (NY)

On-site
USD 70,000 - 90,000
Data Analyst, Business Analytics Hybrid
Data Analyst, Business Analytics Hybrid

Fenix Recruiting • Brentwood (TN)

Hybrid
USD 70,000 - 100,000
401k
Flexible PTO
Medical, Dental, Vision
+2
Data Analyst I
Data Analyst I

Remote Jobs • Tulsa (OK)

Remote
USD 65,000 - 82,000
Data Intelligence - Analyst, Reporting
Data Intelligence - Analyst, Reporting

Ampcus, Inc • Baltimore (MD)

Hybrid
USD 65,000 - 90,000
Senior Decision Support Analyst
Senior Decision Support Analyst

Sysazzle, Inc • Los Angeles (CA)

On-site
USD 70,000 - 90,000
Database Report Writer
Database Report Writer

Compass Health Network • United States

Remote
USD 70,000 - 95,000