Report Developer, Institutional Relations and Development (Hybrid)

University Hospitals•Shaker Heights, OH

2d•Hybrid

About The Position

The Report Writer is a self-motivated highly technical individual who works with customers and peers to design, develop, modify and test reports that meet the customers' needs. This role requires a solid understanding of corporate information and complex large scale data models for healthcare corporate and business systems and the underlying associated processes. The Report Writer maintains a thorough understanding of all major data sources internal to the organization.

Requirements

High School Equivalent / GED (Required)
2+ years report writing experience (Required)
Experience using report writing best practices (optimization, use of joins and sub-queries). (Required proficiency)
Ability to format custom reports. (Required proficiency)
Detail-oriented and organized, with good analytical and problem solving ability. (Required proficiency)
Notable client service, communication, presentation and relationship building skills. (Required proficiency)
Ability to function independently and as a team player in a fast-paced environment. (Required proficiency)
Must have strong written and verbal communication skills. (Required proficiency)
Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols. (Required proficiency)

Nice To Haves

Bachelor's Degree in Computer Science, Computer Engineering, Business Management, Mathematics or related field (Preferred)
1+ years experience in Healthcare Philanthropy (Preferred)
Experience pulling data from Microsoft SQL Server databases for reports (Preferred proficiency)
Working knowledge of philanthropic terminology and workflow (Preferred proficiency)
In depth understanding and experience with SQL Server Reporting services. (Preferred proficiency)
Knowledge of programming languages, MS SQL, .Net Framework and other related systems. (Preferred proficiency)

Responsibilities

Designs and develops reports using Microsoft SQL Reporting Services platform (SSRS), MS Excel, Pivot tables, SharePoint and other intuitive graphical add-on tool sets.
Ensures report products are efficient and meet all regulatory and security requirements.
Develops data extraction and output specifications for reports based on analysis of end user’s requirements.
Gathers specifications from internal customers to understand requirements analyze data and provide valid report designs.
Identifies appropriate data sources for customer requests and ensures data integrity when pulling information into structured reports.
Implements report subscriptions and methods for report distribution based on agreed timelines and according to specifications.
Coordinates with vendors and DBA team in scheduling jobs and processes.
Retrieves data from a variety of database types utilizing available tools as required.
Actively supports and maintains the reporting platform including troubleshooting environment issues and preparation for service packs and upgrades in conjunction with the DBA team.
Proactively identifies and address scalability and performance bottlenecks to support the database environment.
Performs quality assurance testing of reports and facilitates user acceptance testing (UAT).
Ensures quality of the reports prior to releasing to production.
Develops and maintains documentation templates and standards for documentation of data extraction and output specifications, reports and other requirements.
Performs other duties as assigned.
Complies with all policies and standards.
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.