Back to jobs

Senior SQL Server & Healthcare Data Consultant

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Write advanced T-SQL queries, stored procedures, views and data extracts

  • Validate and reconcile clinical, financial and billing data across sources

  • Identify missing, duplicated or mis-mapped records

  • Support claim reconstruction and revenue recovery work

  • Analyze charge capture and billing data for workflow or system failures

From the employer’s posting
Develop advanced SQL queries, stored procedures, views, and data extracts.
Reconcile information across clinical, financial, and operational data sources.
Identify missing, duplicated, inconsistent, or incorrectly mapped records.
Support claim reconstruction and revenue recovery activities.
Analyze charge capture and billing data to identify workflow or system failures.

What you’ll bring

All qualifications

Core experience

  • 8+ years of SQL Server, data analysis, database development, or healthcare data experience.
  • Experience developing complex queries, joins, stored procedures, views, and data-validation routines.
  • Strong experience working with healthcare clinical, financial, billing, or revenue cycle data.
  • Knowledge of hospital data models, including patient, encounter, charge, coding, claim, and payment information.
  • Experience reconciling information across multiple databases and source systems.
  • Strong understanding of data quality, data integrity, and financial reconciliation.

Preferred experience

  • Experience supporting hospital revenue cycle recovery, claim reconstruction, or billing remediation initiatives.
  • Experience with SSIS, SSRS, Azure Data Factory, or similar data integration and reporting tools.
  • Knowledge of healthcare claims and transaction formats, including 837 and 835 files.
  • Familiarity with HL7, FHIR, APIs, or healthcare interfaces.
Qualification wording
8+ years of SQL Server, data analysis, database development, or healthcare data experience.
Experience developing complex queries, joins, stored procedures, views, and data-validation routines.
Strong experience working with healthcare clinical, financial, billing, or revenue cycle data.
Knowledge of hospital data models, including patient, encounter, charge, coding, claim, and payment information.
Experience reconciling information across multiple databases and source systems.
Strong understanding of data quality, data integrity, and financial reconciliation.
Experience supporting hospital revenue cycle recovery, claim reconstruction, or billing remediation initiatives.
Experience with SSIS, SSRS, Azure Data Factory, or similar data integration and reporting tools.
Knowledge of healthcare claims and transaction formats, including 837 and 835 files.
Familiarity with HL7, FHIR, APIs, or healthcare interfaces.
Apply at PCG International

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Jul 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,009 similar postings that came down. Coming down is not always a hire.

PCG International is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • T-SQL
  • Azure
  • Power BI
  • SQL Server
  • SSIS
  • SSRS
Where the posting names them
Description PCG Consulting International partners with healthcare organizations to solve complex operational, technology, and business challenges that improve financial performance and patient care. PCG Consulting Group is seeking an experienced Senior SQL Server & Healthcare Data Consultant to support a large-scale hospital revenue recovery and operational stabilization initiative. This consultant will provide advanced SQL Server, healthcare data analysis, and data reconciliation expertise across clinical, financial, operational, and billing systems. The role will focus on extracting, validating, and analyzing healthcare data needed to identify revenue cycle breakdowns, support claim reconstruction, and restore reliable financial operations.
PCG Consulting International partners with healthcare organizations to solve complex operational, technology, and business challenges that improve financial performance and patient care. PCG Consulting Group is seeking an experienced Senior SQL Server & Healthcare Data Consultant to support a large-scale hospital revenue recovery and operational stabilization initiative. This consultant will provide advanced SQL Server, healthcare data analysis, and data reconciliation expertise across clinical, financial, operational, and billing systems. The role will focus on extracting, validating, and analyzing healthcare data needed to identify revenue cycle breakdowns, support claim reconstruction, and restore reliable financial operations. Working closely with Healthcare Data Architects, Paragon consultants, Revenue Cycle professionals, HIM and Coding teams, and integration specialists, the Senior SQL Server & Healthcare Data Consultant will help determine what data remains available, whether it is complete and accurate, and how it can be transformed into usable financial and claim-ready records.
This consultant will provide advanced SQL Server, healthcare data analysis, and data reconciliation expertise across clinical, financial, operational, and billing systems. The role will focus on extracting, validating, and analyzing healthcare data needed to identify revenue cycle breakdowns, support claim reconstruction, and restore reliable financial operations. Working closely with Healthcare Data Architects, Paragon consultants, Revenue Cycle professionals, HIM and Coding teams, and integration specialists, the Senior SQL Server & Healthcare Data Consultant will help determine what data remains available, whether it is complete and accurate, and how it can be transformed into usable financial and claim-ready records. Key Responsibilities
Key Responsibilities - Develop advanced SQL queries, stored procedures, views, and data extracts. - Analyze clinical, encounter, charge, billing, claims, and payment data.
- Develop reports and datasets for operational and financial analysis. - Troubleshoot SQL Server database and data-processing issues. - Document query logic, data definitions, reconciliation methods, and findings.
- The initial engagement is expected to span several months, with the possibility of extension. This engagement offers the opportunity to apply advanced SQL Server and healthcare data expertise to a complex hospital recovery initiative. You will work with experienced healthcare, revenue cycle, data, application, and technical professionals to recover critical information, improve data integrity, and support the restoration of accurate billing and reimbursement operations. Requirements
Requirements - 8+ years of SQL Server, data analysis, database development, or healthcare data experience. - Advanced proficiency with Microsoft SQL Server and T-SQL.
- 8+ years of SQL Server, data analysis, database development, or healthcare data experience. - Advanced proficiency with Microsoft SQL Server and T-SQL. - Experience developing complex queries, joins, stored procedures, views, and data-validation routines.
- Experience supporting hospital revenue cycle recovery, claim reconstruction, or billing remediation initiatives. - Experience with SSIS, SSRS, Azure Data Factory, or similar data integration and reporting tools. - Knowledge of healthcare claims and transaction formats, including 837 and 835 files.
- Familiarity with HL7, FHIR, APIs, or healthcare interfaces. - Experience with Power BI or other healthcare reporting and analytics tools. - Healthcare consulting experience.

Your next step

Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.

Applying through Paylocity

  • “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.

Already applied? Track this application

Job description

View original posting ↗

Description

 

PCG Consulting International partners with healthcare organizations to solve complex operational, technology, and business challenges that improve financial performance and patient care. PCG Consulting Group is seeking an experienced Senior SQL Server & Healthcare Data Consultant to support a large-scale hospital revenue recovery and operational stabilization initiative.


This consultant will provide advanced SQL Server, healthcare data analysis, and data reconciliation expertise across clinical, financial, operational, and billing systems. The role will focus on extracting, validating, and analyzing healthcare data needed to identify revenue cycle breakdowns, support claim reconstruction, and restore reliable financial operations.

Working closely with Healthcare Data Architects, Paragon consultants, Revenue Cycle professionals, HIM and Coding teams, and integration specialists, the Senior SQL Server & Healthcare Data Consultant will help determine what data remains available, whether it is complete and accurate, and how it can be transformed into usable financial and claim-ready records.


Key Responsibilities

  • Develop advanced SQL queries, stored procedures, views, and data extracts.
  • Analyze clinical, encounter, charge, billing, claims, and payment data.
  • Extract data from Paragon and related hospital information systems.
  • Validate data completeness, accuracy, consistency, and integrity.
  • Reconcile information across clinical, financial, and operational data sources.
  • Identify missing, duplicated, inconsistent, or incorrectly mapped records.
  • Support claim reconstruction and revenue recovery activities.
  • Assist with data profiling, cleansing, transformation, and normalization.
  • Analyze charge capture and billing data to identify workflow or system failures.
  • Support ETL processes and repeatable data recovery routines.
  • Collaborate with Data Architects to create logical and physical data mappings.
  • Partner with application, interface, revenue cycle, HIM, and coding teams.
  • Develop reports and datasets for operational and financial analysis.
  • Troubleshoot SQL Server database and data-processing issues.
  • Document query logic, data definitions, reconciliation methods, and findings.
  • Communicate data risks and recommendations to project leadership.


Engagement Details

  • Project-Based W2 consulting employment.
  • Work is expected to be performed primarily remotely.
  • Occasional onsite meetings or working sessions in the Chicago metropolitan area may be required.
  • Weekly hours may vary based on project phase, workstream priorities, and client needs.
  • The initial engagement is expected to span several months, with the possibility of extension.

This engagement offers the opportunity to apply advanced SQL Server and healthcare data expertise to a complex hospital recovery initiative. You will work with experienced healthcare, revenue cycle, data, application, and technical professionals to recover critical information, improve data integrity, and support the restoration of accurate billing and reimbursement operations.

Requirements

  • 8+ years of SQL Server, data analysis, database development, or healthcare data experience.
  • Advanced proficiency with Microsoft SQL Server and T-SQL.
  • Experience developing complex queries, joins, stored procedures, views, and data-validation routines.
  • Strong experience working with healthcare clinical, financial, billing, or revenue cycle data.
  • Knowledge of hospital data models, including patient, encounter, charge, coding, claim, and payment information.
  • Experience reconciling information across multiple databases and source systems.
  • Strong understanding of data quality, data integrity, and financial reconciliation.
  • Experience with ETL processes and large healthcare datasets.
  • Ability to translate technical findings into clear operational and business recommendations.
  • Strong analytical, troubleshooting, documentation, and communication skills.

Preferred Qualifications

  • Technical or database experience with the Paragon EHR and Patient Accounting platform.
  • Experience supporting hospital revenue cycle recovery, claim reconstruction, or billing remediation initiatives.
  • Experience with SSIS, SSRS, Azure Data Factory, or similar data integration and reporting tools.
  • Knowledge of healthcare claims and transaction formats, including 837 and 835 files.
  • Familiarity with HL7, FHIR, APIs, or healthcare interfaces.
  • Experience with Power BI or other healthcare reporting and analytics tools.
  • Healthcare consulting experience.
  • Experience supporting acute care hospitals or multi-hospital health systems.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

USA

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.