Enterprise Program Management Business Analyst Associate

Teacher Retirement System of Texas•Austin, TX

2d•$62,113 - $77,640•Onsite

About The Position

The Enterprise Program Management (EPM) Business Analyst Associate supports business analysis, data analysis, and business intelligence activities for enterprise initiatives, strategic priorities, and organizational decision-making. The role assists with collecting, analyzing, interpreting, and presenting information in support of business process improvement, performance measurement, program management, and reporting. The position works with the EPM team, TRS business units and staff, and consultants. It reports to the Director of Enterprise Program Management. This is a full-time, temporary Fellowship Program assignment that may not exceed three years from the date of hire. It is intended for individuals who graduated with a master's degree from an accredited college or university within the last 12 months. The target start date is January 2027.

Requirements

Master's degree from an accredited four-year college or university in Business Administration, Public Administration, Data Analytics, Management Information Systems, Computer Science, Industrial Engineering, or a closely related field, earned within the last 12 months.
Ability to research, analyze, interpret, and present complex information clearly and actionably.
Ability to translate business needs and requirements into reporting, dashboard, survey, and analytical solutions.
Ability to apply analytical and critical thinking, evaluate business challenges, and develop practical recommendations.
Ability to plan, prioritize, and manage multiple assignments and deadlines.
Ability to communicate effectively with technical and non-technical audiences and maintain effective relationships with stakeholders.
Ability to work independently and collaboratively, learn new tools and methods, and respond constructively to feedback.
Sound judgment, attention to detail, discretion, and ability to appropriately handle confidential or sensitive information.

Nice To Haves

Graduate-level coursework in Business Administration, Public Administration, Data Analytics, Information Systems, Computer Science, Industrial Engineering, or a related field.
Experience using data analysis and visualization tools such as Power BI, Tableau, Qualtrics, SQL, Python, R, or similar tools.
Experience with Databricks, Microsoft Fabric, Power BI semantic models, SQL, and Python through coursework, internships, academic projects, or professional experience.
Experience supporting data integration, workflow automation, or automated reporting solutions.
Experience conducting research, data collection, data analysis, reporting, or business process analysis through coursework, internships, projects, or professional experience.
Experience developing reports, dashboards, presentations, or analytical products.
Demonstrated interest in business intelligence, program management, strategic planning, organizational performance, or public sector administration.
Knowledge of business analysis, data analysis, reporting, data visualization, data modeling, business intelligence, data management, performance measurement, data quality, data governance, research methods, survey design and analysis, dashboard design, KPI development, process improvement, and Microsoft 365 applications.
Skills using Qualtrics, Databricks, Microsoft Fabric, SQL, Python, Power Automate, Power BI, and Power BI semantic models, datasets, and reporting solutions.
Skills in business process analysis and mapping; gathering, documenting, validating, and analyzing requirements; translating requirements into analytical solutions; analyzing quantitative and qualitative data; and developing dashboards, reports, scorecards, visualizations, and data-driven recommendations.

Responsibilities

Assist with data integration, transformation, reporting, and analysis using SQL, Python, Databricks, Microsoft Fabric, and related technologies.
Identify insights and support recommendations based on data analysis, research, and stakeholder input.
Assist in developing performance measures, metrics, and key performance indicators (KPIs).
Support forecasting, benchmarking, trend analysis, research, data collection, strategic planning, program evaluation, and continuous improvement activities.
Identify data quality issues, participate in improving data accuracy, consistency, and governance, and validate data sources, calculations, and reporting outputs.
Support development and maintenance of enterprise reporting solutions, semantic models, dashboards, visualizations, and automated reporting processes.
Assist with designing, developing, testing, and maintaining dashboards, charts, scorecards, reports, and business intelligence solutions.
Support improvements to reporting processes and self-service analytics capabilities.
Support survey planning and development, including objectives, audiences, timelines, deliverables, instrument writing and review, configuration, administration, deployment, monitoring, troubleshooting, and respondent communications.
Evaluate survey methodologies, response rates, and performance metrics, and help communicate survey findings, results, and recommendations.
Collect, compile, validate, and analyze quantitative and qualitative data from multiple sources; prepare recurring and ad hoc reports, dashboards, and presentations.
Gather, document, and validate business requirements, reporting needs, and survey objectives under senior staff guidance.
Collaborate with agency stakeholders on business process analysis and opportunities for operational improvement, standardization, and efficiency.
Assist in analyzing and evaluating business processes, policies, procedures, goals, and objectives, and recommend improvements to survey, reporting, and data collection practices.
Work with the Senior Enterprise Program Management Business Analyst and the Director of Enterprise Program Management on improvements to data collection, management, analysis, reporting, and business intelligence processes.
Conduct research into trends, best practices, technologies, and analytical tools related to survey administration, business analysis, program management, and organizational effectiveness.
Participate in training, professional development, mentorship, and TRS Fellowship Program activities, and meet program deadlines and deliverable goals.
Perform related work as assigned.