University Hospitals Hiring for IT Report Developer II, Cleveland Medical Center Full Time

Position Summary/Essential Duties:
The Developer II is a self-motivated highly technical individual who works with customers and peers to design, develop, modify and test s 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 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 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 ing.

Designs, develops and supports “self-service” ing 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 s 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 ing team members on their code development.

Perform quality assurance testing of s and dashboards, and facilitate user acceptance testing (UAT) sessions. Ensure quality of the s 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 s and facilitates user acceptance testing (UAT). Ensure quality of the s prior to releasing to production. Develops and maintains documentation templates and standards for documentation of data extraction and output specifications, s 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, ing, and analysis.

Qualifications

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

2+ years’ experience in IT Healthcare desired.

Experience with data cube development and ing 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 s required.

Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and ing 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.