> Markdown version of [/jobs/ext/1429225-senior-sql-server-healthcare-data-consultant](https://www.wearedevelopers.com/jobs/ext/1429225-senior-sql-server-healthcare-data-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior SQL Server & Healthcare Data Consultant - **Company:** PCG INTERNATIONAL INC - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Application Programming Interfaces (APIs), Data Analysis, Clinical Data Repository, Hospital Information Systems, Databases, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Profiling, Data Recovery, Database Development, Database Queries, Microsoft SQL Server, Power BI, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Transact-SQL, Data Processing, Freeform SQL, Azure Data Factory, Fast Healthcare Interoperability Resources, Health Level Seven International, Tools for Reporting - **Published:** July 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=343116d976fd1f27 ## About the Role * 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. ## Description 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., * 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. ## Related Videos - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [ZEISS & Microsoft - Building the Next Generation Medical Ecosystem in the Cloud](https://www.wearedevelopers.com/videos/424-zeiss-microsoft-building-the-next-generation-medical-ecosystem-in-the-cloud) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)