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 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.
• 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.
• Advanced understanding of Epic data models and software analytical tools.
• Proven ability to work independently.
• Advanced critical and analytical thinking proficiencies.
• Excellent verbal/written communication and follow-up skills.
• Demonstrated advanced troubleshooting competencies.
• Excellent organizational and project management skills.
• Strong understanding of Data Warehousing Concepts.
Education:
• Bachelors degree in a scientific, technical, healthcare informatics, or mathematics field.
Experience:
• Five (5) years of experience in data analytics, data science, data warehousing, data lakes and marts, metadata management, and dimensional is required.
• Experience working with Epic Clarity and Caboodle data models, reporting tools, and clinical data is highly preferred.
• Experience supporting Epic Inpatient applications is preferred.
Additional Licenses/Certifications:
• Certified in Tableau or Power BI or relevant visualization tools preferred.
• Proficiency with sophisticated analytics tools and programming languages (SAS, R, Python, Java, Spark, Hadoop, Alteryx, SQL); proficiency with data visualization tools (Tableau, QlikView, and others) is preferred.
• Certified in Epic Cogito Data Warehouse & Caboodle Data Model. Epic certification must be maintained per Epic Corporation standards is preferred.