Certified EPIC Business Intelligence Developer III (Mostly Remote)

UTHealth Houston's Epic Operating team is looking for a Certified Epic Business Intelligence Developer (BID) III to join their team.  You must be familiar with writing SQL code and also have a data model certification.  You will be responsible for analyzing, providing specifications for, and writing individual reports for assigned applications to support the needs of end users, senior leadership, and the Epic project team. Serves as the primary Epic data model resource for the Epic Cogito Clarity application and has the responsibility of system support and maintenance, analysis, design, and change control of all reporting components used to build and manage assigned functional reporting area(s). Responsible for validating existing foundation system reports and identifying, in advance, optimization and performance enhancement opportunities. Works closely with all levels of staff and customers to translate business needs into technical requirements, key performance indicators, design specifications, and implementation plans in order to meet business and operational needs.

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 adapt to a wholly remote schedule for the right candidate.  That being said, currently, UTHealth Houston requires employees to either reside in the State of Texas or relocate to Texas within three months of accepting a role.  You will be eligible for all UTHealth Houston benefits, including excellent healthcare coverage (employer paid) and a pension plan administered by the State of Texas.   

What we do here changes the world. UTHealth Houston is Texas’s resource for healthcare education, innovation, scientific discovery, and excellence in patient care. That’s where you come in.

Once you join us, you won't want to leave. It’s because we reward our team for the excellent service they provide. Our total rewards package includes the benefits you’d expect from a top healthcare organization (benefits, insurance, etc.), plus:  

• 100%25 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) 
• Build your future with our awesome retirement/pension plan! 

We take care of our employees! As a world-renowned institution, our employees’ wellbeing is important to us. We offer work/life services such as... 

• 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 Summary:

Responsible for analyzing, providing specifications for, and writing individual reports for assigned applications to support the needs of end users, senior leadership, and the Epic project team. Serves as the primary Epic data model resource for the Epic Cogito Clarity application and has the responsibility of system support and maintenance, analysis, design, and change control of all reporting components used to build and manage assigned functional reporting area(s). Responsible for validating existing foundation system reports and identifying, in advance, optimization and performance enhancement opportunities. Works closely with all levels of staff and customers to translate business needs into technical requirements, key performance indicators, design specifications, and implementation plans in order to meet business and operational needs.

Position Key Accountabilities:

• Translates business requirements into business intelligence solutions utilizing tools such as, but not limited to, Business Objects, Crystal Reports, WebI, Universes, Cubes, SSMS, etc.
• Interfaces and communicates with customers to define deliverables, issues, questions, needs, trends, and timing.
• Modifies existing solutions as necessary and continually evaluates existing solutions for effectiveness and efficiency.
• Works with application teams to help guide integration of models into workflows.
• Serves as a primary participant in a collaborative relationship with leadership and peers to develop and implement processes to promote an integrated delivery system, to assist end users and to provide a positive patient experience.
• Generates routine and ad-hoc reports (SQL, Crystal Reports, WebI) to complete data requests.
• Reviews peer reporting for validity, quality, and standardization.
• Identifies and reviews the appropriate technological solutions for various needs to continually improve the business intelligence experience.
• Assists with training and knowledge transfer of Business Intelligence Developer best practices to other staff members.
• Helps to maintain an enterprise business intelligence library and supports the archiving of unused solutions.
• Supports Epic's reporting solutions: Radar, Reporting Workbench, Epic-released universes and cubes.
• Fosters a continual relationship with the training and application teams to help support the reporting solutions developed by the BI team.
• Assists with Epic upgrades/updates by serving as a subject matter expert for the Epic Clarity data models.
• Continues to pursue professional development in order to stay abreast of best practice.
• Researches and recommends healthcare data management industry strategies and software tools available to implement those strategies.
• Works closely with other members of the BI team to understand data structures and to set/follow best practices within BI.
• Innovates to challenge the status quo and create new analytical and developmental techniques.
• Performs other duties as assigned.

Certification/Skills:

• Superior communication skills, both oral and written, including specific skills of presentation and the effective communication of complex subjects to non-technical groups.
• Superior customer relations skills, including leading and participating in group sessions and reaching consensus.
• Familiarity with project lifecycle and project management methodologies for software management.
• Ability to plan and manage projects of various sizes; their tasks, dependencies, team members, other resources, and timeline.
• Possess the analytical skills to collect information from diverse sources, apply professional principles in performing various analyses, and summarize the information and data in order to solve problems or design related systems and programs that cross department/divisional lines.
• Manages Human Resources activities of the department in regard to recruiting and selection, hiring and termination, training, professional development, mentoring, counseling, performance evaluations, and salary planning.
• Work may involve handling biohazardous, chemical, and radiological materials, as well as operating associated equipment. Required safety training and appropriate engineering and administrative controls, including the use of personal protective equipment, must be followed.
• EPIC Certification by EPIC required

Minimum Education:

Bachelor's Degree in Computer Science, Business, or a related field required. May substitute required education with equivalent years of experience beyond the minimum experience requirement.

Minimum Experience:

5 years of experience in a health care-related field required. Experience with business intelligence tools: Microsoft BI stack, SAP Business Objects, Qlikview, Spotfire, Tableau, or Crystal Reports required. Experience with SQL query tools such as Oracle, Business Objects, Microsoft SQL, Tableau, etc. required 3 years of visualization developer experience supporting one or more Epic Clarity Data Models preferred. Large-scale health care systems planning and implementation experience on application software products preferred

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. To the extent that a position requires the holder to research, work on, or have access to critical infrastructure as defined in Texas Business and Commerce Code §117.001(2), the ability to maintain the security or integrity of the infrastructure is a minimum qualification to be hired for and to continue to be employed in that position. Personnel in such positions, and similarly situated state contractors, will be routinely reviewed to determine whether things such as criminal history or continuous connections to the government or political apparatus of a foreign adversary might prevent the applicant, employee, or contractor from being able to maintain the security or integrity of the infrastructure. A foreign adversary is a nation listed in 15 C.F.R. §791.4.

Residency Requirement:

Employees must permanently reside and work in the State of Texas.