Senior SPA Analytics Analyst

WHY UT SOUTHWESTERN?
With over 75 years of excellence in Dallas-Fort Worth, Texas, UT Southwestern is committed to excellence, innovation, teamwork, and compassion. As a world-renowned medical and research center, we strive to provide the best possible care, resources, and benefits for our valued employees. Ranked as the number 1 hospital in Dallas-Fort Worth according to U.S. News & World Report, we invest in you with opportunities for career growth and development to align with your future goals. Our highly competitive benefits package offers healthcare, PTO and paid holidays, on-site childcare, wage, merit increases and so much more. We invite you to be a part of the UT Southwestern team where you'll discover a culture of teamwork, professionalism, and a rewarding career!

JOB SUMMARY
The Senior SPA Analytics Analyst works with the Award Closeout team which oversees the final reconciliation of the research award agreements. It is important to understand financial acumen and the relationship of funding, revenue and expenditures. This position works with diverse analytical strategies across the financial and award systems to tie these concepts together. The Closeout team collaborates with pre and post-award functions throughout Sponsored Programs. Successful metrics in driving the team's closed population is one measure for this role. The ability to identify anomalies and exceptions and root cause financial analysis can provide strength for position.

BENEFITS
UT Southwestern is proud to offer a competitive and comprehensive benefits package to eligible employees. Our benefits are designed to support your overall wellbeing, and include:

• PPO medical plan, available day one at no cost for full-time employee-only coverage
• 100% coverage for preventive healthcare-no copay
• Paid Time Off, available day one
• Retirement Programs through the Teacher Retirement System of Texas (TRS)
• Paid Parental Leave Benefit
• Wellness programs
• Tuition Reimbursement
• Public Service Loan Forgiveness (PSLF) Qualified Employer
• Learn more about these and other UTSW employee benefits!

EXPERIENCE AND EDUCATION
Required

• Education
  Bachelor's Degree in accounting, finance, healthcare statistics or similar field.

• Experience
  5 years job related experience in the Research Administration or Healthcare sector manipulating large relational databases.
  Experience with advanced excel tools SQL, SAS, Stata, SPSS, or similar statistical/data management tools.
  Superior working knowledge of MS Office applications and familiarity with data warehouse or Power BI preferred.

JOB DUTIES

• Designs, executes, and investigates automation of analytical strategies to improve organizational research data decisions.
• Identifies trends in expenditures and revenue using multiple data sources.
• Focus on common errors which typically occur within our processes to find root cause in order to build corrections and fix, preserving data integrity of the various systems relied upon for details.
• Works on cross-functional teams to develop novel methods for analyzing and presenting data to understand common problems across teams in order to rectify, reclassify or restate properly.
• Works with research administration or clinical finance experts to help develop explanatory models and predict impact of specific programs and trends for various University rankings and national surveys.
• Generates recommendations and presents analytic output to leadership to inform strategic and tactical decision making and guides process improvement using business intelligence.
• Conducts research and analyzes drivers of variances large and small which cause change in monthly, quarterly and annual reporting.
• Uses data