Business Intelligence Analyst Associate - Decision Support Analysis

Minimum Qualifications:

Bachelor’s degree or equivalent experience and four (4) years of relevant work experience required, including extensive experience organizing, structuring, modeling, and contextualizing financial and business operations data in tools like Excel, Power Pivot, Power BI, Power Query, SQL, and Analysis Services.

Job Summary:

The Business Intelligence Analyst, Associate is responsible for providing meaning to the data in UTMB systems and developing methods to leverage that data in UTMB applications. Responsibilities may include assisting with standardizing and cleaning data, building prediction models, modeling outcomes, and developing metrics for complex data analysis projects that can be multi-disciplinary or interdepartmental. Addresses data requirements for analytic reporting and operating areas with expertise in specific data systems and/or analytical methodologies. Works with proficiency with a variety of tools (ex: SQL, Excel, Tableau, etc.) to extract data, write queries, develop programming logic, run reports, manipulate data, and analyze datasets to meet the needs of the organization.

Job Duties:

• Collects, aggregates, and analyzes data from multiple internal and external sources to drive insights into business performance. Utilizes business intelligence tools to create reports and dashboards, and produces actionable reports that show key performance indicators, identify areas of improvement in current operations, and display root cause analysis of problems.
• Develops summaries of findings and recommends actions; drives business decisions by providing quantitative and qualitative data analysis and reporting of patterns, insights, and trends to decision-makers.
• Assist with the development, implementation, and validation of new predictive models, conduct QA of models’ outcomes, and monitor performance regularly. 
• Uses analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profits of new business initiatives.
• Works with internal clients to develop and translate business requirements into project charters, business and technical requirements, and ultimately produce effective and insightful interactive analytics.
• Assist with compiling, cleaning, manipulating, and analyzing data related to department projects. Responds to data integrity and functional or interactive issues in existing and future dashboards quickly and effectively.
• Formulates validation strategies and methods to ensure accurate and reliable data.
• Adheres to internal controls and reporting structure.
• Perform other similar and related duties as required or directed. 
   

Knowledge/Skills/Abilities:

• Critical thinking skills to help predict the needs of various business units and leaders across UTMB, rather than requiring them to provide detailed prescriptive direction.
• Knowledge and familiarity with business intelligence tools such as Excel, Power Pivot, Power BI, Power Query, SQL, and Analysis Services to design and develop reporting analytics and visualizations.
• Knowledge and familiarity with Microsoft Office suite software (Word, Excel, PowerPoint, Outlook, Visio, etc.).
• Interpersonal and communication skills to effectively work and communicate with others.
• Ability to quickly demonstrate proficiency in new software tools.
• Analytical reasoning and problem-solving skills.
• Ability to document work and communicate progress to others.
• Ability to function with moderate supervision in a fast-paced environment.
• Ability to be detailed and accurate. 
   

Salary Range:

Actual salary commensurate with experience.