Under limited supervision, the Business Intelligence Analyst will champion and provide leadership, and support for 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.
This role will provide help and build support to their counterparts in the area of Revenue Cycle of both Inpatient and Outpatient practice and 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. Strong experience and background in health systems business domain knowledge and Epic Cogito and tools are preferred.
.
• Develop and maintain Epic Cogito-based reports, dashboards, and data extracts to support Revenue Cycle operations, including Professional and Hospital Billing.
• Collaborate with Revenue Cycle leadership, operational stakeholders, and IT teams to understand reporting needs and translate them into effective BI solutions.
• Ensure data integrity and accuracy by validating reports and working with Data Governance teams to align with enterprise standards.
• Optimize performance of existing BI solutions by troubleshooting report queries, improving efficiency, and implementing best practices for data extraction and visualization.
• Support Epic upgrades and new module implementations by assessing reporting impacts, testing, and validating BI content.
• Develop and maintain documentation and training materials to assist end users in understanding and utilizing reporting tools effectively.
• Stay updated on Epic reporting best practices, new Cogito functionalities, and industry trends to continuously improve analytics capabilities.
• 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.
• 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 KPI’s (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.
• Health Care BI & Data Analytics Experience
• Advanced understanding of Epic data models and software analytical tools. Intermediate
• Strong experience in SQL,SSIS
• Experience in tools like Tableau, Power BI, EPIC Cogito Stack
• Proven ability to work independently.
• Proven ability to successfully execute multiple assignments simultaneously in a matrixed environment.
• Demonstrated critical and analytical thinking proficiencies.
• Strong written and verbal communication skills.
• Demonstrated troubleshooting competencies.
• Excellent organizational management skills.
• Strong understanding of Data Warehousing Concepts.
EDUCATION:
• Bachelor’s Degree in a scientific, technical, healthcare informatics, or mathematics field.
LICENSE AND CERTIFICATION:
Certified in Epic Cogito Data Warehouse & Caboodle Data Model. Epic certification must be maintained per Epic Corporation standards
• Certified in Tableau or Power BI or Any Analytics Tools preferred.
• Preferred with sophisticated analytics tools and programming languages (SAS, R, Python, Java, Spark, Hadoop, Alteryx, SQL); proficiency with data visualization tools (Tableau, Power BI, QlikView, and others)