Job Description Job Description UT Health San Antonio is growing rapidly with an upcoming half-billion-dollar Multi-Specialty and Research Hospital that provides intricate specialty care, innovative technologies, and Clinical trials that are not available elsewhere. Additionally, we are expanding our ambulatory system with a state-of-the-art ambulatory center and surgery center. Are you interested to be part of the growing Analytics Center of Excellence department with the mission to “Empower and augment users with actionable insights using Data & Analytics to improve health outcomes, enhance the patient and provider experience, and reduce costs to make lives better” by providing self-service, predictive, and proactive analytics that expected to have a lot of growth potential? The Epic BI Developer is a key member of the strategic Analytics Center of Excellence at UT Health San Antonio. We are seeking a candidate with strong experience in Epic-based reporting in the areas of RWB SQL, Radar, Slicer Dicer, Data marts, Power BI, Tableau etc., along with strong healthcare domain experience. S/he should be comfortable leveraging data to make informed business decisions while building internal and external relationships. This role requires a drive to lead overall data analytics management of the services offering to create innovative ways to analyze and understand data. Job Summary: Under limited supervision, Clinical Reporting Analyst-Intermediate will champion and actively involve in the ongoing design, development, and advancement of diverse BI/Data Analytics pursuits focused on data warehousing, data mining, data structuring, data analytics, advanced visualization, and related technologies in furthering the missions of UT Health San Antonio. Will be responsible for the design, and development of Epic-based reporting like RWB, Radar, and Slicer Dicer reporting and analytics. Will also be responsible for regulatory reporting like TIPPS, MIPS, and others. This role will operationalize business intelligence solutions and conduct advanced, timely, and relevant analytics in support of business partners/leaders to identify opportunities and highlight strengths and opportunities to meet organizational strategies, objectives, and goals. Provides technical leadership to less experienced team members and will lead medium size projects through all phases of the implementation lifecycle. This role helps us to build a strong analytics department that allows us to expand our reporting in Finance, Professional Billing, Hospital Billing, and Costing, etc. Knowledge, Skills and Abilities:
- Advanced understanding of Epic data models and software analytical tools. Intermediate
- Experience in EPIC Cogito, Reporting Workbench, Radar, and Slicer-Dicer
- Strong Work experience in SQL, GIT, and building Data marts, Datasets in tools like Tableau, Power BI are plus
- Proven ability to work independently. Advanced
- Advanced critical and analytical thinking proficiencies. Advanced
- Excellent verbal/written communication and follow-up skills. Advanced
- Demonstrated advanced troubleshooting competencies. Advanced
- Excellent organizational and project management skills. Intermediate
- Strong understanding of Data Warehousing Concepts. Advanced
Job Duties:
- Define complex and detailed statistical analyses and modeling of clinical and operational data with outputs that are clear and relevant to stakeholders, such as opportunity analyses, clinical trending, operational KPIs, predictive modeling, program evaluation, customer reporting, product development, and ad-hoc analytics.
- Participate in the design and development of statistical analyses and reports that explore and present large amounts of data to discover underlying patterns and trends related to volumes, operational efficiency, cohort analysis, and clinical performance.
- Analyze large datasets to discover trends, patterns, and actionable insights.
- Apply research and evaluation standards, descriptive statistics, and data management principles to translate complex data into meaningful content.
- Develop reports in Reporting Workbench(RWB SQL), Radar, Slicer Dicer, and also in Power BI and Tableau tools
- Present findings using verbal, written, and graphic communication techniques. Offer recommendations to support organizational performance improvement.
- Independently complete analysis, development, and enhancement of analytical and operational BI solutions to fulfill business needs.
- Apply understanding of dimensional data modeling techniques, data warehousing, design, and concepts to produce balanced scorecard design and design of dashboards and KPIs (Key Performance Indicators).
- Stay informed about Business Intelligence industry trends, technologies, and best practices that can be applied to achieve organizational objectives.
- Analyze large data sets of structured, semi-structured unstructured data to discover data insights and collaborate with business partners to deliver business value.
- Design interactive and/or advanced visualizations (Tableau) that enhance analytics storytelling to support business decisions.
- Navigate multiple business lines and draw holistic insights from large data sets.
- Interpret and develop complex SQL queries for both ad-hoc and ETL uses.
- Provides direction and guidance to less experienced team members.
- Performs all other duties as assigned.
Education: Bachelor’s degree in a scientific, technical, healthcare informatics, or mathematics field. four (4) years of comparable experience may be substituted for a degree. Experience: Three (3) years of experience in data analytics, data science, data warehousing, data lakes and marts, metadata management, and dimensional is required. Strong experience in EPIC Reporting tools like RWB SQL, Radar, and Slicer-Dicer is preferred. Strong experience in SQL development, GIT, Tabular Data models, and tools such as Power BI and Tableau and working experience in building tabular data models is required. Certifications: Certified in Epic Reporting Workbench or Epic Radar Preferred. Certified in Tableau Preferred. As specified by the department director, Epic certification for assigned Reporting Workbench or Radar is required within eighteen (18) months of hire. Epic certification must be maintained per Epic Corporation standards. As specified by the department director, additional certifications for assigned software analytical tools (such as Tableau) are required within thirty-six (36) months of hire. Certification must be maintained per Health-IT standards.
Git Key Performance Indicators (KPIs) Tableau Data Marts SQL ETL dataset Power BI