Remote Clinical Reporting Analyst (6-Month Contract)

Solving IT, International; Chicago (IL); On-site; USD 83,000 - 103,000; Part time

Benefits offered by this job

Remote work

Job summary

Solving IT, International seeks a Clinical Reporting Systems Analysis Specialist to bridge business and technology teams. You will gather requirements, translate them into functional specs, and modernize enterprise reports and dashboards using SQL, Tableau, SSRS, and SSIS.

You will work with data engineers, vendors, and stakeholders to improve data quality, migrate assets to enterprise platforms, and perform testing to ensure accuracy and reliability of clinical reporting and analytics.

Qualifications

• Five or more years of experience in data analysis, data mining, and requirements gathering.
• At least three years of intermediate-to-advanced T-SQL experience within Microsoft SQL Server, including complex joins and subqueries, stored procedures and CTEs.
• At least three years of hands-on Tableau dashboard development experience.
• At least three years of advanced SSRS report-development experience (drill-down, drill-through, dynamic groupings).
• At least three years of SSIS experience with debugging and performance tuning improvements.

Responsibilities

• Lead requirements-gathering sessions with business and technology stakeholders.
• Translate business processes and reporting needs into clear functional and technical requirements.
• Develop and enhance complex SSRS reports and Tableau dashboards.
• Write and optimize advanced T-SQL queries and stored procedures.
• Partner with developers and data engineers throughout design, development, testing, and implementation.
• Perform functional, regression, and negative testing for break fixes, enhancements, and new solutions.
• Develop test cases, validate business rules, document results, and support user acceptance testing.
• Analyze existing reports, data sources, and processes to identify improvement opportunities.
• Review and troubleshoot SSIS packages, including data flows and performance issues.
• Support integration of Utilization Management reporting into the enterprise data mart.
• Document business requirements, data lineage, and business logic.

Skills

SQL

Tableau

SSRS

SSIS

Data warehousing

Functional testing

Agile

Data quality

Data governance

ETL

Education

Bachelor’s degree or equivalent professional experience

Tools

Teradata SQL

SQL Server

Job description

6-month W2 Contract to start ; we cannot work 1099 or C2C

Pay rate Target: $65.00; flexible for the right candidate

Remote

There is no sponsorship now or in the future on this position

Clinical Reporting Systems Analysis Specialist

Position Overview

We are seeking a Clinical Reporting Systems Analysis Specialist to serve as a key liaison between business and technology teams. This role will gather and translate business requirements, develop and enhance enterprise reports and dashboards, analyze complex healthcare data, and improve reporting and operational processes.

The specialist will work closely with business stakeholders, developers, data engineers, and vendors to modernize reporting solutions, automate manual processes, improve data quality, and migrate reporting assets into enterprise-supported platforms. The ideal candidate combines strong business analysis skills with hands-on experience in SQL, Tableau, SSRS, SSIS, data warehousing, and functional testing.

Key Responsibilities

• Lead requirements-gathering sessions with business and technology stakeholders.
• Translate business processes, workflows, and reporting needs into clear functional and technical requirements.
• Develop and enhance complex SSRS reports and Tableau dashboards.
• Write and optimize advanced T-SQL queries, stored procedures, CTEs, temporary tables, and other database objects.
• Partner with developers and data engineers throughout design, development, testing, and implementation.
• Perform functional, regression, and negative testing for break fixes, enhancements, and new solutions.
• Develop test cases, validate business rules, document results, and support user acceptance testing.
• Analyze existing reports, data sources, and operational processes to identify opportunities for improvement.
• Review and troubleshoot SSIS packages, including data flows, metadata, properties, and performance issues.
• Support the integration of Utilization Management reporting into the enterprise data mart.
• Document business requirements, process flows, data lineage, business logic, decisions, and action items.
• Support production reporting environments, release activities, defect resolution, and ongoing enhancements.
• Manage multiple priorities in a fast-paced, cross-functional environment.

Reporting Modernization Responsibilities

• Analyze and migrate reporting assets from legacy or temporary environments into enterprise-supported platforms.
• Modernize reporting solutions, automate manual processes, and reduce technical debt.
• Identify opportunities to improve the performance, reliability, scalability, and governance of data integration processes.
• Consolidate reporting tools and standardize data sources in support of the enterprise reporting strategy.
• Improve data quality through validation, reconciliation, and clearly documented business rules.
• Coordinate with internal teams and external vendors on data integrations, file transfers, and reporting dependencies.

Required Qualifications

• Five or more years of experience in data analysis, data mining, and requirements gathering.
• At least three years of intermediate-to-advanced T-SQL experience within Microsoft SQL Server, including:
• Complex joins and subqueries
• Stored procedures
• CTEs and temporary tables
• Indexes and query optimization
• Troubleshooting and performance tuning
• At least three years of hands-on Tableau dashboard development experience.
• At least three years of advanced SSRS report-development experience, including:
• Drill-down and drill-through functionality
• Dynamic groupings
• Document maps
• Using a single dataset across multiple report controls
• At least three years of SSIS experience, with the ability to review, debug, and recommend improvements to SSIS packages.
• At least three years of functional, regression, and negative testing experience.
• Experience gathering and documenting requirements in an Agile environment.
• Experience supporting enterprise data warehouse or data-mart environments.
• Experience documenting complex business logic, data mappings, and data lineage.
• Experience with ETL design, troubleshooting, and performance optimization.
• Experience implementing reporting or process-automation solutions.
• Strong understanding of data quality, governance, reconciliation, and validation practices.
• Experience supporting production reporting environments and release-management activities.
• Excellent written and verbal communication skills.
• Strong analytical and problem-solving abilities with exceptional attention to detail.
• Ability to learn quickly and manage multiple competing priorities.

Preferred Qualifications

• Bachelor’s degree or equivalent professional experience.
• Experience with Teradata SQL.
• Healthcare reporting or analytics experience involving:
• Clinical reporting
• Health Services or Medical Management
• Population Health
• HEDIS, Stars, or other healthcare quality programs
• SNP Models of Care
• Medical and coding terminology
• Experience with healthcare reporting-modernization initiatives.
• Experience migrating reports and data assets between platforms or environments.
• Experience supporting vendor data integrations and Secure File Transfer Protocol processes.