• Design, develop and maintain Business Intelligence solutions using Microsoft Fabric • Build and optimize Lakehouse, Data Warehouse and analytics solutions • Develop data pipelines and transformation workflows • Create semantic models and reporting solutions using Power BI • Integrate data from multiple enterprise systems • Ensure data quality, performance and scalability across analytics platforms • Collaborate with business stakeholders to understand reporting and analytics requirements • Work closely with Data Engineers, Architects and Analytics teams • Follow engineering best practices, including CI/CD and version control • Contribute to solution architecture and technical improvements • For Lead-level candidates: provide technical leadership, mentor engineers and support solution design and customer discussions

• Design, develop, and maintain data transformation workflows using dbt. • Build and optimize ETL/ELT pipelines that ingest, cleanse, and transform data from multiple sources. • Develop and maintain data preparation workflows using Alteryx. • Create and maintain Python scripts to automate data processing and pipeline tasks. • Ensure data pipelines are scalable, reliable, and well documented. • Monitor scheduled jobs and troubleshoot pipeline failures, data quality issues, and performance bottlenecks. • Perform root cause analysis and implement long-term solutions for recurring production issues. • Maintain operational documentation and runbooks. • Design, develop, and maintain dashboards and reports using MicroStrategy. • Translate business requirements into intuitive and effective reporting solutions. • Optimize dashboards for usability and performance. • Support existing reports by resolving issues, improving functionality, and ensuring successful data refreshes.

• Reporting to the Director, BI and Data Operations, the Business Intelligence Analyst will contribute to data-driven insights and actionable recommendations that support organizational priorities • Work cross-functionally with teams across the organization to understand the challenges each team faces and determine how data and process improvements can best address them • Build and maintain Salesforce reports and dashboards based on business requirements and user needs, gathered directly from stakeholders across the organization • Leverage AI tools such as Claude to create reports, analyses, data visualizations, and tools that extend beyond traditional Salesforce capabilities • Identify and resolve data quality issues as they arise, utilizing tools such as Salesforce, Claude, Excel, and Tableau • Collaborate with our Data Operations team as needed to investigate and address root causes • Evaluate business processes, gather and document requirements, and work with peers within the Data and Technology team to implement solutions that drive efficiency • Lead ongoing reviews and improvements of priority business processes across departments, partnering closely with department leads to understand needs and drive alignment • Serve as both project lead and project team member depending on the initiative, managing projects independently from planning through completion, including regular communication of project status with relevant stakeholders • Manage competing priorities and resources while monitoring deliverables to ensure timely completion • Conduct user acceptance testing and incorporate feedback to validate that solutions meet business needs before deployment • Translate data findings and process knowledge to support the Technology Enablement team in producing formal documentation • Conduct meetings and presentations to share findings and next steps, and effectively communicate insights to stakeholders ranging from individual contributors to senior leadership • Coach and guide end users on Salesforce reporting and interpreting data outputs to build data literacy across the organization.

Role Description UTHealth Houston is seeking an Epic Business Intelligence Analyst II to work with our Epic operations team. You will be responsible for overseeing and coordinating the triage of analytics requests and deciding which reporting tools to use as new data needs arise, including but not limited to: - Clarity and Caboodle reports - Extract Framework: Metrics - Benchmarking - Radar - Analytics Catalog - Registry Framework - Data marts - Reporting Workbench - SlicerDicer - Tableau Works closely with all levels of staff and customers to translate business needs into requirements, key performance indicators, design specifications, and implementation plans to meet UTHealth Houston's needs. This role requires someone who is already certified in Cogito Fundamentals and Cogito Tools Administration. The analyst serves as a data modeling resource for our clinical areas. This is a remote role for the most part. There may be times when an employee needs to come in for launches or specific meetings, but we can accommodate a fully remote schedule for the right candidate. That being said, UTHealth Houston currently strongly prefers that employees either reside in the State of Texas or relocate to Texas within three months of accepting a role. Qualifications - Certification in Epic Cogito Fundamentals and Cogito Tools Administration - Bachelor's Degree in Computer Science, Business, or a related field required - 4 years of experience in a healthcare-related field required - 1 year of experience supporting one or more Epic modules preferred - Large-scale healthcare systems planning and implementation experience on application software products preferred Requirements - Superior communication skills, both oral and written - Superior customer relation skills - Familiarity with project lifecycle and project management methodologies for software management - Ability to plan and manage projects of various sizes - Analytical skills to collect information from diverse sources - Manages Human Resources activities of the department Benefits - 100% paid medical premiums for our full-time employees - Generous time off (holidays, preventative leave day, both vacation and sick time – all of which equate to around 37-38 days per year) - The longer you stay, the more vacation you’ll accrue! - Longevity Pay (Monthly payments after two years of service) - Awesome retirement/pension plan - Free financial and legal counseling - Free mental health counseling services - Gym membership discounts and access to wellness programs - Other employee discounts, including entertainment, car rentals, cell phones, etc. - Resources for child and elder care - Plus many more! Position Key Accountabilities - Maintains expertise and seeks additional knowledge in the support and optimization of Epic Cogito analytics suite of tools - Establishing processes, including request, triage, prioritization, testing, publishing, and validating data requests - Works cohesively with stakeholders to provide system support including analysis, build, and testing of requested changes - Reviewing upgrade documentation related to analytics tools and content - Creates and modifies existing reports and distributes analytics content to data consumers - Demonstrates timely, effective, and efficient troubleshooting of software and workflow issues - Maintaining the Analytics Catalog and associated metadata records - Meets build deadlines as communicated by EHR Business Intelligence Application Manager - Develops and maintains system documentation - Assists EHR Business Intelligence Application Manager in developing build timelines and project plans - Performs unit testing of application configurations and builds - Follows established guidelines for system change control - Creates and maintains documentation for change management - Collaborates across teams to ensure process design, interface development, testing, and end-user training - Independently performs basic project management activities - Develops applications-specific reports - Performs other duties as assigned Physical Requirements - Exerts up to 50 pounds of force occasionally and/or up to 20 pounds frequently and/or up to 10 pounds constantly to move objects Security Sensitive This position is a security-sensitive position pursuant to Texas Education Code §51.215 and Texas Government Code §411.094. Residency Requirement We prefer employees who permanently reside and work in the State of Texas.