Note: The job is a remote job and is open to candidates in USA. Solving IT is seeking a Clinical Reporting Systems Analyst to serve as a liaison between business and technology teams. The role focuses on gathering requirements, developing and enhancing healthcare reports and dashboards, analyzing complex data, modernizing reporting solutions, improving data quality, and supporting enterprise reporting platforms.
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
- 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
Skills
- 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
- Bachelor's degree or equivalent professional experience
- Experience with Teradata SQL
- Healthcare reporting or analytics experience involving:
- Medicare or Medicaid
- Medicare Advantage
- Utilization Management
- 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
Benefits
- Remote work
Company Overview