University Hospitals Hiring for IT Report Developer II, Cleveland Medical Center – Hybrid Work Arrangement Job at Cleveland, OH Full Time

Position Summary/Essential Duties:
The Report Developer II 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 complex large scale data models for healthcare clinical and business systems and the underlying associated processes. The Report Developer II maintains a thorough understanding of all major data sources internal to the organization.

Develop requirements and specifications in coordination with Database Administration team and UH Architects for data marts and data warehouses to support clinical and business analytics. Gather appropriate specifications for data collection and transformation requirements and build report prototypes rapidly and accurately.

Writes data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources throughout the organization to support ad hoc reporting.

Designs, develops and supports “self-service” reporting options (i.e building tabular data models).

Create functional and technical documentation including “as-built” documents, dashboard design specifications, operating manuals, release notes and security requirements for reports created and maintained. Update documentation on an annual basis or when changes occur.

Writes stored procedures and indexes, and completes code reviews in conjunction with DBA and/or development team and provides guidance to reporting team members on their code development.

Perform quality assurance testing of reports and dashboards, and facilitate user acceptance testing (UAT) sessions. Ensure quality of the reports prior to releasing to production.

Provides technical support in retrieving data from a variety of database types and languages utilizing T-SQL as may be required.

Perform quality assurance testing of reports and facilitates user acceptance testing (UAT). Ensure 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.

Proactively identifies and addresses scalability and performance bottlenecks to support data volumes.

Where appropriate, evaluate and recommend new tools in clinical intelligence, reporting, and analysis.

Qualifications

Experience & Knowledge:
Minimum 3 years report development and analytics experience using Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) required.

2+ years’ experience in IT Healthcare desired.

Experience with data cube development and reporting is required.

Experience with Microsoft SSIS is required.

Knowledge and understanding of standardized Data Warehousing Concepts required.

Thorough understanding of stored procedures, T-SQL, functions, and SQL Queries required.

Must demonstrate ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports required.

Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols.

Knowledge of programming languages MS SQL, .Net Framework and other related systems required.

Strong written and verbal communication skills are required.

Must have strong analytical skills with an ability to organize and communicate thoughts clearly.

Experience pulling data from many different types of databases for analysis including Microsoft SQL Server, Oracle, Sybase, and Microsoft Access is desired.

Education:
High School diploma or GED required.

Bachelor degree in Computer Science, Computer Engineering, Business Management, Mathematics or related field is preferred.