Report Developer II
Position #: 260009EE
Shift: Days
Status: Full-time
Work Days of the Week: M-F
UH Facility: University Hospitals
Location: Shaker Heights, OH
Remote Work: Hybrid
Salary: $74,090 – $115,898 /year
Job Description & Qualifications
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.
- 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%
Additional Salary Detail:
The salary range and/or hourly rate listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of posting of this job advertisement and may be modified in the future. When determining a team member’s base salary and/or rate, several factors may be considered as applicable (e.g., location, specialty, service line, years of relevant experience, education, credentials, union negotiated contracts, budget and internal equity). This figure does not include, unless otherwise stated incentive pay or shift differential pay or the value of University Hospitals’ comprehensive benefits package, which includes healthcare, dental, vision, retirement plan options, and additional offerings. Click here to view complete wellness and benefits details.
For over 150 years, University Hospitals has been dedicated to our mission To Heal. To Teach. To Discover. Starting as a small Cleveland hospital in 1866, UH has grown into 18 hospitals and 40 health centers, serving 1 million people annually.
UH delivers exceptional care, advances medical innovation, and trains future healthcare leaders. Now, you have the opportunity to add your talents to this legacy of care. At UH, you’ll join a collaborative team in an inspiring environment where your skills and ideas will be valued. Together, we can continue to shape the future of healthcare and deliver on the promise of our mission for generations to come.
Equal Opportunity Employer – Veterans and individuals with disabilities.
University Hospitals is a national leader in healthcare that takes pride in calling Northeast Ohio home. With more than 150 locations throughout Cleveland and the surrounding metropolitan areas, UH provides unique opportunities to deliver world-class care in the communities where our employees live, work, and play.
We want you to make a career with us and we are here to support you – both in and out of work. Our comprehensive benefits program offers choice and flexibility to meet you where you are in your life.
- Medical Plans
- Dental Plans
- Vision Plan
- Paid Short and Long Term Disability
- Life and Account Insurance
- Additional Voluntary Benefits
- Wellness Programs and Plans
- Financial Health Resources
- Career Development Resources
- And More!
*Benefits may vary based on FTE Status and Position Type.
View complete wellness and benefits details on our Why Choose Us page.
We want you to make a career with us and we are here to support you – both in and out of work. Our comprehensive benefits program offers choice and flexibility to meet you where you are in your life.
- Medical Plans
- Dental Plans
- Vision Plan
- Paid Short and Long Term Disability
- Life and Account Insurance
- Additional Voluntary Benefits
- Wellness Programs and Plans
- Financial Health Resources
- Career Development Resources
- And More!
*Benefits may vary based on FTE Status and Position Type.
Working at University Hospitals
Careers at UH offers opportunities to provide care locally in the Cleveland area with the power to impact healthcare nationwide. As leaders in our industry, our staff share a commitment to be the difference in the lives of our patients and our communities from Northeast Ohio and beyond. Look at this video to discover how we’re building an organization for the future today.
Nightshift Module
Night shift provides a unique and rewarding opportunity for caregivers who thrive in a close-knit, supportive environment. With fewer distractions and a calmer atmosphere, you’ll have the chance to foster meaningful relationships with both colleagues and patients. The quieter pace allows for more in-depth patient connections, greater autonomy, and the opportunity to refine your skills. Whether it’s the flexibility to fit your lifestyle, the teamwork and problem-solving that come with a close-knit team, or the financial benefits of shift differential pay, night shift offers a space where you can grow both personally and professionally. If you excel in a late-night environment and appreciate the independence and collaboration it offers, our night shift team is the perfect fit for you!
Hear from our team about why they enjoy working the night shift and how it has shaped their careers.
Sara H.
Multi Modality
I like nightshift because the smaller staff helps me build connections and friendships with the staff around me. Helping us to better communicate without any issues, including doctors. I can work independently, keeping my thinking skills sharp. Even when it is quiet, it is never boring.
