Enterprise Program Management Business Analyst Associate

Teacher Retirement System of Texas (TRS)•Austin, TX

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

About The Position

The Enterprise Program Management (EPM) Business Analyst Associate assists with business analysis, data analysis, and business intelligence in support of enterprise initiatives, strategic priorities, and organizational decision-making. The role supports EPM activities by helping collect, analyze, interpret, and present data for business process improvement, performance measurement, program management, and reporting. The position reports to the Director of Enterprise Program Management and works with the EPM team, TRS business units and staff, and consultants. This is a full-time, temporary Fellowship Program assignment limited to no more than three years from the hire date. It is intended for individuals who graduated with a qualifying master’s degree from an accredited college or university within the previous 12 months. The target start date is January 2027. The position supports data integration, transformation, reporting, dashboards, semantic models, surveys, research, and business process analysis. It also participates in the TRS Fellowship Program’s training, projects, mentoring, and other learning activities, and completes program goals and deliverables on time. Related work may be assigned.

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.
No prior experience is required.
No registration, certification, or licensure is required.
Knowledge of business analysis, data analysis, reporting, data visualization, data modeling, business intelligence, data management, performance measurement, data quality, and data governance principles.
Knowledge of research methods, data collection, survey design and administration, survey analysis, dashboard design, KPI development, and process improvement.
Knowledge of Microsoft 365 applications, including Excel, Word, PowerPoint, OneNote, Visio, Teams, and Outlook.
Skills in survey platforms such as Qualtrics; data platforms such as Databricks and Microsoft Fabric; SQL and Python; workflow automation tools such as Power Automate; and visualization and business intelligence tools such as Power BI.
Ability to develop and maintain Power BI semantic models, datasets, reports, dashboards, scorecards, and visualizations; support automated reporting, data integration, and dashboard troubleshooting.
Ability to conduct business process analysis and mapping; gather, document, validate, and analyze requirements; and translate business needs into analytical products and solutions.
Ability to collect, validate, interpret, and analyze quantitative and qualitative data; identify trends, patterns, risks, and opportunities; synthesize information; and develop data-driven recommendations.
Ability to communicate complex information clearly to technical and non-technical audiences through reports, presentations, dashboards, and visualizations.
Ability to organize and coordinate assignments, manage competing priorities and deadlines, and work in a fast-paced environment.
Ability to build collaborative relationships, work independently and as part of a team, learn new tools and methods, and respond constructively to feedback.
Ability to exercise sound judgment, attention to detail, and discretion, and appropriately handle sensitive or proprietary 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 with 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.

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 KPIs for strategic and operational objectives.
Support forecasting, benchmarking, trend analysis, research, and data collection for planning, program evaluation, and continuous improvement.
Identify data quality issues, participate in improving data accuracy and consistency, and support data governance practices.
Validate data sources, calculations, and reporting outputs.
Support the development and maintenance of enterprise reporting solutions, semantic models, dashboards, and automated reporting processes.
Design, develop, test, and maintain dashboards, visualizations, and business intelligence solutions with guidance from senior staff.
Develop visualizations, dashboards, charts, scorecards, and reports to communicate findings and support data-informed decisions.
Support KPI, scorecard, executive reporting, reporting-process, and self-service analytics improvements.
Support survey planning and development, including objectives, audiences, timelines, and deliverables.
Write, review, test, and proofread survey instruments; support survey configuration, deployment, monitoring, troubleshooting, and respondent communications.
Evaluate survey methodologies, response rates, and performance metrics, and help communicate survey results and recommendations.
Research trends, best practices, technologies, and analytical tools related to surveys, business analysis, program management, and organizational effectiveness.
Collect, compile, validate, and analyze quantitative and qualitative data from multiple sources.
Prepare recurring and ad hoc reports, dashboards, and presentations; interpret data and help develop recommendations.
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 improvement, standardization, and efficiency.
Support stakeholders in selecting survey methodologies, data collection approaches, and reporting strategies aligned with business objectives.
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.
Participate in professional development, training, mentorship, and TRS Fellowship Program activities, and meet program deadlines and deliverable goals.
Perform related work as assigned.