Note: The job is a remote job and is open to candidates in USA. Palmer's Contracting Group (PCG) is a consulting firm that partners with healthcare organizations to address operational and technology challenges. They are seeking a Senior SQL Server & Healthcare Data Consultant to support hospital revenue recovery and operational stabilization initiatives by providing expertise in SQL Server and healthcare data analysis.
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
Skills
- 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
- 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
Benefits
- 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.
- The initial engagement is expected to span several months, with the possibility of extension.
Company Overview