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 analysis skills and query data sources to design new reporting and analytic tools to share and train department to utilize in other practical functions.
• Performs other duties as assigned.

SECURITY AND EEO STATEMENT
Security
This position is security-sensitive and subject to Texas Education Code 51.215, which authorizes UT Southwestern to obtain criminal history record information. To the extent this position requires the holder to research, work on, or have access to critical infrastructure as defined in Section 113.001(2) of the Texas Business and Commerce Code, the ability to maintain the security or integrity of the critical infrastructure is a minimum qualification to be hired and to continue to be employed in the position.

EEO Statement
UT Southwestern Medical Center is committed to an educational and working environment that provides equal opportunity to all members of the University community. As an equal opportunity employer, UT Southwestern prohibits unlawful discrimination, including discrimination on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity, gender expression, age, disability, genetic information, citizenship status, or veteran status.

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!