Report Developer II

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.