A Brief Overview

The Report Developer I supports the creation and maintenance of operational and analytical reports using modern BI tools such as Power BI, Tableau, or Epic Cogito (Reporting Workbench, Radar Dashboards, and SlicerDicer). This role focuses on building standard reports, validating data, and assisting with dashboard development under guidance. Candidates should have foundational SQL skills, exposure to data visualization principles, and familiarity with connecting business intelligence (BI) tools to common data sources. Basic scripting knowledge (Python or PowerShell) and awareness of cloud analytics concepts are a plus.

What You Will Do

• Designs and develops basic reports and dashboards using reporting platform tools and basic SQL queries. Selects appropriate data sources from approved datasets, performs basic data validation checks (e.g., record counts, field consistency), and ensures integrity when building structured reports. Ensures report products are efficient and adhere to naming and formatting conventions.
• Collaborates with subject matter experts to gather basic reporting requirements, clarify business use cases and metrics, and translate them into simple technical specifications with support from senior team members as needed.
• Writes and tests simple queries in modern analytics tools to support reporting needs, adhering to naming and formatting conventions.
• Assists in documenting workflows and data definitions for reports, including report specifications, data definitions, workflow diagrams, data mapping, testing and validation procedures, and end-user guides.
• 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.
• Supports end-user inquiries by providing guidance on report navigation, filters, and exports; escalates complex issues to senior team members.
• Distributes reports according to agreed timelines and specifications using methods such as email subscriptions, shared network folders, dashboards, or scheduled exports. Coordinates with server administrators, DBAs, and vendors to schedule automated SQL agent jobs and related processes.
• Supports and maintains reporting platforms by performing routine monitoring, troubleshooting basic environment issues, and assisting with preparations for service packs and upgrades.
• 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.

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.

Education

• High School Equivalent / GED (Required) and
• Bachelor's Degree in Computer Science, Computer Engineering, Business Management, Mathematics or related field (Preferred)

Work Experience

• less than 1 year Experience working in a data-focused role with primary responsibilities centered on data analysis, integration, and reporting to support clinical and business operations and decision making. (Preferred)
• less than 1 year Experience with report creation using BI tools such as Power BI and Tableau. Understanding of data visualization principles. Familiarity with publishing and sharing reports within an organization. (Preferred)
• less than 1 year Experience in SQL and relational databases. (Preferred)
• less than 1 year Exposure to ETL/ELT processes and data loading techniques. (Preferred)
• less than 1 year Experience working with diverse healthcare enterprise data sources including EMR/EHR systems, financial and cost accounting platforms, and quality reporting tools to deliver enterprise-level dashboards, KPIs, and self-service reporting solutions. (Preferred)
• less than 1 year Experience using modern version control systems (e.g. Azure DevOps/GitHub (repos/pipelines) or similar tools for managing SQL scripts, report definitions, and BI assets. (Preferred)
• less than 1 year Experience with Epic EMR reporting tools: Reporting Workbench, SlicerDicer, Radar Dashboards, Clarity/Caboodle, and Cogito SQL. (Preferred)

Knowledge, Skills, & Abilities

• Demonstrated knowledge of database structures, relationships, and reporting protocols, with practical experience in Microsoft cloud technologies and analytics, and proficiency or familiarity with BI tools such as Power BI and Tableau. (Preferred proficiency)
• Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols. (Preferred proficiency)
• Ability to write queries that are efficient and utilize optimized joins, subqueries, and indexing strategies. (Preferred proficiency)
• Detail-oriented and organized, with good analytical and problem solving ability. (Preferred proficiency)
• Ability to work effectively both independently and within a fast-paced team environment. (Preferred proficiency)
• Strong written and verbal communication skills for technical and non-technical audiences. (Preferred proficiency)
• Notable client service and relationship-building skills to effectively engage and support clients. (Preferred proficiency)
• Working knowledge of medical terminology, clinical workflows, and healthcare data standards (e.g., HL7, FHIR, ICD-10, CPT), along with HIPAA and data privacy regulations. Familiarity with financial and operational healthcare data, including claims, billing, reimbursement, and key performance indicators. (Preferred proficiency)

Licenses and Certifications

• Epic certifications (e.g., Clarity/Caboodle/Cogito Fundamentals) (Preferred within 2 Years)

Physical Demands

• Standing Occasionally
• Walking Occasionally
• Sitting Constantly
• Lifting Rarely up to 20 lbs
• Carrying Rarely up to 20 lbs
• Pushing Rarely up to 20 lbs
• Pulling Rarely up to 20 lbs
• Climbing Rarely up to 20 lbs
• Balancing Rarely
• Stooping Rarely
• Kneeling Rarely
• Crouching Rarely
• Crawling Rarely
• Reaching Rarely
• Handling Occasionally
• Grasping Occasionally
• Feeling Rarely
• Talking Constantly
• Hearing Constantly
• Repetitive Motions Frequently
• Eye/Hand/Foot Coordination Frequently

Travel Requirements

• 10%