IT Report Developer II

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.

What You Will Do

• 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.

Additional Responsibilities

• 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.