Enterprise Program Management Business Analyst Associate

About the Role

This Fellowship Program position is a full-time, temporary, limited term assignment not to exceed three years from the date of hire. It is intended for individuals that have graduated with a master's degree from an accredited college or university within the last 12 months. Target start date in January 2027.

The Enterprise Program Management (EPM) Business Analyst Associate is responsible for assisting with business analysis, data analysis, and business intelligence work in support of enterprise initiatives, strategic priorities, and organizational decision-making. The incumbent will support EPM activities and assist with the collection, analysis, interpretation, and presentation of data to support enterprise business process improvement, performance measurement, program management, and reporting activities. This position reports to the Director of Enterprise Program Management and will proactively work with the EPM team, TRS business units, TRS staff, and consultants.

Key Responsibilities

Data Analysis and Business Intelligence Support

• Assists with data integration, transformation, and reporting activities using SQL, Python, Databricks, Microsoft Fabric, and related technologies.
• Assists with identifying insights and supporting the development of recommendations based on data analysis, research, and stakeholder input.
• Assists with developing performance measures, metrics, and Key Performance Indicators (KPIs) to support strategic and operational objectives.
• Assists with forecasting, benchmarking, and trend analysis activities that support business planning, program evaluation, and continuous improvement efforts.
• Assists with benchmarking, research, and data collection efforts to support organizational initiatives and strategic planning activities.
• Supports the collection and organization of information used in strategic planning, program evaluation, and continuous improvement efforts.
• Assists with identifying data quality issues and participates in initiatives to improve data accuracy, consistency, and data governance practices.
• Validates data sources, calculations, and reporting outputs to support the integrity and reliability of analytical products.
• Supports the development and maintenance of enterprise reporting solutions, semantic models, dashboards, and automated reporting processes under the guidance of senior staff.
• Assists in the design, development, testing, and maintenance of dashboards, visualizations, and business intelligence solutions.
• Assists with developing data visualizations, dashboards, charts, scorecards, and reports that effectively communicate findings and support data-informed decision-making.
• Supports the development of data visualization using best practices to present information in a clear, intuitive, and actionable manner.
• Supports the creation and enhancement of Key Performance Indicators (KPIs), scorecards, and executive reporting tools.
• Participates in efforts to improve reporting processes and self-service analytics capabilities.

Survey Administration and Reporting Support

• Supports the planning and development of survey projects, including assisting with defining objectives, target audiences, timelines, and deliverables.
• Assists with writing, reviewing, testing, and proofreading survey instruments to help ensure clarity, accuracy, and usability.
• Supports survey design, configuration, and administration activities, including survey deployment, monitoring, troubleshooting survey-related issues, and respondent communications.
• Assists with evaluating surveys, methodologies, response rates, and performance metrics to improve future survey initiatives.
• Assists with delivering and communicating survey findings, results, and recommendations to stakeholders.
• Conducts research on emerging trends, best practices, and industry technologies and analytical tools related to survey administration and analysis.
• Collects, compiles, validates, and analyzes quantitative and qualitative data from multiple sources to support organizational decision-making.
• Assists with analyzing survey, operational, and program data to identify trends, patterns, risks, opportunities, and actionable insights.
• Assists with preparing recurring and ad hoc reports, dashboards, and presentations for stakeholders.
• Supports data interpretation and assists with the development of recommendations regarding the effective use of resulting information.

Business Analysis and Stakeholder Support

• Gathers, documents, and validates business requirements, reporting needs, and survey objectives under the guidance of senior staff.
• Collaborates with agency stakeholders to support business process analysis and identify opportunities for operational improvement, standardization, and increased efficiency.
• Assists stakeholders in identifying survey methodologies, data collection approaches, and reporting strategies that support business objectives.
• Assists in the analysis and evaluation of business processes, policies, procedures, goals, and objectives.
• Assists with developing recommendations for new or enhanced survey, reporting, and data collection practices.
• Works with the Senior Enterprise Program Management Business Analyst and the Director of Enterprise Program Management to support improvements to processes related to data collection, data management, data analysis, reporting, and business intelligence.
• Supports the development and implementation of surveys, dashboards, and reporting solutions using established business analysis, data analysis, and business intelligence practices.
• Conducts research on emerging trends, best practices, and industry technologies and analytical tools related to business analysis, program management, and organizational effectiveness.
• Participates in training, professional development, and mentorship opportunities to build knowledge and skills related to business analysis, data analytics, business intelligence, and program management.

Fellowship Curriculum

• Participates in trainings and projects related to the TRS Fellowship Program including webinars, quarterly check-ins, classes, or other learning activities, book group, projects, and the mentoring program.
• Meets TRS Fellowship Program deadlines and goals for completion of trainings and deliverables in a timely manner.
• Performs related work as assigned.

Qualifications

Required Education

• 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 within the last 12 months.

Required Experience

• None

Registration, Certification, Or Licensure

• None

Preferred Qualifications

• 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 academic 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, and data visualization principles, methodologies, and best practices.
• Data modeling, business intelligence concepts, reporting and analytics tools, data management practices, and performance measurement techniques.
• Data quality, data governance, and information management principles.
• Research methods, data collection techniques, and analytical approaches used to support business decision making.
• Survey design, administration, data collection methods, and survey analysis techniques.
• Dashboard design and data visualization best practices.
• Key Performance Indicator (KPI) and metric development concepts.
• Process improvement principles and methodologies.
• Microsoft 365 applications, including Excel, Word, PowerPoint, OneNote, Visio, Teams, and Outlook.

Skills In

• Using survey administration and experience management platforms, including Qualtrics.
• Using data platforms, including Databricks and Microsoft Fabric.
• Using programming languages, including SQL and Python, to query, analyze, and transform data.
• Using workflow automation tools, including Power Automate.
• Using data visualization tools and business intelligence tools, including Power BI.
• Developing and maintaining Power BI semantic models, datasets, and reporting solutions.
• Supporting automated reporting, data integration, and dashboard troubleshooting activities.
• Conducting business process analysis, process mapping, and the analysis, design, and documentation of business processes.
• Gathering, documenting, validating, and analyzing business requirements.
• Translating business requirements into dashboards, reports, surveys, data visualizations, and other analytical solutions.
• Collecting, validating, interpreting, and analyzing quantitative and qualitative data.
• Developing dashboards, reports, scorecards, and data visualizations.
• Identifying trends, patterns, risks, and opportunities from complex data sets.
• Synthesizing information from multiple sources and developing data-driven recommendations.
• Collecting and analyzing complex data, evaluating business needs and systems, and drawing logical conclusions.
• Organizing information and communicating complex concepts clearly and concisely through reports, presentations, dashboards, and data visualizations.
• Preparing and delivering reports, presentations, and recommendations to technical and non-technical audiences.
• Planning, organizing, and coordinating work assignments to effectively manage multiple priorities, deadlines, and competing demands.
• Building collaborative relationships with stakeholders across functional areas.
• Analyzing problems and developing practical and effective solutions.

Ability To

• Connect detailed data analysis, business requirements, and operational needs to broader organizational goals and decision-making needs.
• Apply analytical and critical thinking skills to evaluate business challenges, identify alternatives, and develop practical solutions.
• Research, analyze, interpret, and present complex information in a clear, meaningful, and actionable manner.
• Analyze and interpret business and technical information, including policies, procedures, regulations, business rules, and system documentation.
• Evaluate information, systems, processes, and data to draw logical conclusions and develop sound recommendations.
• Translate business needs into reporting, dashboard, survey, and analytical requirements.
• Support continuous improvement initiatives through data-driven analysis and recommendations.
• Learn and apply new technologies, tools, concepts, and methodologies.
• Plan, organize, prioritize, and manage multiple assignments while meeting deadlines in a fast-paced environment.
• Communicate effectively, both verbally and in writing, with technical and non-technical audiences.
• Establish and maintain effective working relationships with stakeholders at all organizational levels.
• Work independently and collaboratively in a professional team environment.
• Accept, incorporate, and respond constructively to feedback to support continuous learning and professional growth.
• Exercise sound judgment, attention to detail, and discretion while maintaining confidentiality and appropriately handling sensitive or proprietary information.