Report Developer II

University Hospitals; Shaker Heights (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

University Hospitals is seeking a Report Developer II to design, develop, and test enterprise reports, dashboards, and BI data models for clinical and business needs. You will work with analysts to translate requirements into scalable solutions and ensure governance, security, and data quality across the reporting lifecycle.

The role requires expertise in BI tools (Power BI/Tableau), SQL, ETL, and experience with healthcare data sources.

Qualifications

• 3+ years experience in a data-focused role handling data analysis, integration, and reporting for clinical and business operations.
• 3+ years experience with report creation using BI tools such as Power BI and Tableau, plus knowledge of data visualization principles.
• 2+ years experience with SQL and relational databases.
• 2+ years experience with ETL processes, including data extraction and loading.
• 1+ years experience with programming languages (e.g., Python, DAX, Power Query) to build custom reporting solutions.
• 3+ years experience with healthcare enterprise data sources and enterprise dashboards.
• 1+ years experience with version control systems (Azure DevOps/GitHub).
• 2+ years experience with Epic EMR reporting tools: Reporting Workbench, SlicerDicer, Radar Dashboards, Clarity/Caboodle, Cogito SQL.

Responsibilities

• Leads requirement analysis sessions with stakeholders and designs scalable reporting solutions.
• Develops ETL programs to import data for ad hoc reporting.
• Maintains documentation and uses version control for traceability.
• Writes and tests complex queries to support reporting needs and optimize performance.
• Performs QA testing and leads UAT to validate reports before production release.
• Maintains and optimizes reporting platforms and supports multiple database types.
• Participates in code reviews and adheres to deployment guidelines.
• Implements governance controls such as dataset certification and row-level security.

Skills

Power BI

Tableau

SQL

ETL processes

Python

DAX

Power Query

Azure DevOps/GitHub

Education

Bachelor's Degree in Computer Science, Computer Engineering, Business Management, Mathematics or related field

High School Equivalent / GED

Tools

Epic EMR reporting tools (Reporting Workbench, SlicerDicer, Radar Dashboards, Clarity/Caboodle, Cogito SQL)

Job description

Job Description - Report Developer II (260009EE)

A Brief Overview

The Report Developer II is a self-motivated, highly technical individual who collaborates with customers, analysts, and peers to design, develop, modify, and test reports that meet business and clinical needs. This role is responsible for creating and delivering interactive dashboards, business intelligence (BI) data models, and semantic layers to support enterprise-wide reporting requirements. The position requires a solid understanding of complex, large-scale data models for healthcare clinical and business systems as well as the underlying processes that drive them.

What You Will Do

• Leads requirement analysis sessions with business and clinical stakeholders, translates moderately complex operational and regulatory needs into detailed technical specifications, and designs scalable reporting solutions aligned with governance and visualization standards.
• Develops ETL programs to import, extract, and load data from diverse organizational sources for ad hoc reporting.
• Maintains comprehensive documentation of report enhancements, logic modifications, and data transformations, leveraging version control and metadata management to ensure traceability and compliance across the report lifecycle. Ensures all materials are kept up-to-date to ensure accuracy and alignment with current tools and processes. Makes content easily accessible for end users and stakeholders, supporting organizational knowledge bases and compliance standards.
• Writes and tests complex queries in modern analytics tools to support reporting needs, adhering to naming and formatting conventions. Optimizes code and applies strategies to improve performance and scalability for enterprise reporting workloads.
• Performs QA testing and leads user acceptance testing (UAT) to validate report accuracy prior to production release. Establishes and maintains documentation standards for data extractions, output specifications, and reporting requirements.
• Maintains and optimizes reporting platforms, provides advanced data retrieval support across multiple database types, and troubleshoots complex issues. Participates in system upgrades and proactively addresses scalability and performance challenges to ensure stability and efficiency.
• Participates in team code reviews and version control processes to ensure code quality and consistency. Commits changes to repositories and adheres to branching and deployment guidelines when migrating content to production.
• Implements governance controls such as dataset certification, row-level security, and usage monitoring to ensure compliance and data stewardship. Leads the creation of business glossary entries, metadata repositories, and participates in stewardship councils.
• Performs gap analysis assessment and develops plans to address impacts from system changes when implementing new functionality. Leads upgrades and migrations with effective risk mitigation and ensures smooth transition to new features.
• Assesses and recommends tools for clinical intelligence, cloud reporting, and analytics to enhance existing systems and align with business needs.
• Supports and deploys AI-driven solutions within the enterprise reporting environment, including integrating AI capabilities into data models, dashboards, and analytics workflows to enhance automation, insights, and decision-making.
• Provides input to development of end-user training materials and participates in training efforts. Supports end user community by participating in community forums such as Office Hours, Lunch and Learns and Knowledge seminars. Trains new members of the team, acting as mentor or coach for junior team members by providing guidance and support.

Additional Responsibilities

• Provides 24/7 on-call support as assigned.
• Performs other duties as assigned.
• Complies with all policies and standards.
• For specific duties and responsibilities, refer to documentation provided by the department during orientation.
• Must abide by all requirements to safely and securely maintain Protected Health Information (PHI) for our patients. Annual training, the UH Code of Conduct and UH policies and procedures are in place to address appropriate use of PHI in the workplace.

Education

• High School Equivalent / GED (Required) and
• Bachelor's Degree in Computer Science, Computer Engineering, Business Management, Mathematics or related field (Preferred)

Work Experience

• 3+ years Experience working in a data-focused role with primary responsibilities centered on data analysis, integration, and reporting to support clinical and business operations and decision making. (Required)
• 3+ years Experience with report creation using BI tools such as Power BI and Tableau. Understanding of data visualization principles. Familiarity with publishing and sharing reports within an organization. (Required)
• 2+ years Experience in SQL and relational databases. (Required)
• 2+ years Experience with ETL processes, including extracting data from multiple sources, transforming it and loading it into reporting or analytics environments. (Preferred)
• 1+ years Experience with programming languages (e.g., Python, DAX, Power Query) to build custom reporting solutions and automate processes. Skilled in scripting with PowerShell and Python for data extraction, transformation, and workflow automation. (Preferred)
• 3+ years Experience working with diverse healthcare enterprise data sources including EMR/EHR systems, financial and cost accounting platforms, and quality reporting tools to deliver enterprise-level dashboards, KPIs, and self-service reporting solutions. (Preferred)
• 1+ years Experience using modern version control systems (e.g. Azure DevOps/GitHub (repos/pipelines) or similar tools for managing SQL scripts, report definitions, and BI assets. (Required)
• 2+ years Experience with Epic EMR reporting tools: Reporting Workbench, SlicerDicer, Radar Dashboards, Clarity/Caboodle, and Cogito SQL. (Preferred)

Knowledge, Skills, & Abilities

• Demonstrated knowledge of database structures, relationships, and reporting protocols, with practical experience in Microsoft cloud technologies and analytics, and proficiency or familiarity with BI tools such as Power BI and Tableau. (Required proficiency)
• Working knowledge of medical terminology, clinical workflows, and healthcare data standards (e.g., HL7, FHIR, ICD-10, CPT), along with HIPAA and data privacy regulations. Familiarity with financial and operational healthcare data, including claims, billing, reimbursement, and key performance indicators. (Preferred proficiency)
• Ability to investigate, interpret, and synthesize complex data to support healthcare data workflows and operations decision-making. (Required proficiency)
• Must work at a high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols. (Required proficiency)
• Ability to write queries that are complex and optimized for performance (leveraging CTEs, window functions, query plans and query tuning). (Required proficiency)
• Strong understanding of data warehousing principles and their application in reporting, including fact and dimension tables, star and snowflake schemas, and data modeling techniques. (Preferred proficiency)
• Must work at a high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols. Ability to understand and work with normalized and denormalized schemas. (Required proficiency)
• Strong understanding of data governance principles, metadata management, security and report lifecycle management. (Preferred proficiency)
• Strong written and verbal communication skills for technical and non-technical audiences. (Required proficiency)
• Ability to work effectively both independently and within a fast-paced team environment. (Required proficiency)

Licenses and Certifications

• Epic certifications (e.g., Clarity/Caboodle/Cogito Fundamentals) (Preferred within 2 Years)

Physical Demands

• Standing Occasionally
• Walking Occasionally
• Sitting Constantly
• Lifting Rarely up to 20 lbs
• Carrying Rarely up to 20 lbs
• Pushing Rarely up to 20 lbs
• Pulling Rarely up to 20 lbs
• Climbing Rarely up to 20 lbs
• Balancing Rarely
• Stooping Rarely
• Kneeling Rarely
• Crouching Rarely
• Crawling Rarely
• Reaching Rarely
• Handling Occasionally
• Grasping Occasionally
• Feeling Rarely
• Talking Constantly
• Hearing Constantly
• Repetitive Motions Frequently
• Eye/Hand/Foot Coordination Frequently

Travel Requirements

• 10%