PUMA and STIP Data Coordinator - Transportation Program Specialist 1 or Transportation Program Specialist 2

Minnesota Department of Transportation; Roseville (MN); Hybrid; USD 56,000 - 82,000; Full time

Job summary

Minnesota Department of Transportation’s Metro District in Roseville is seeking a PUMA and STIP Data Coordinator to support program management, data systems, and budget reconciliation.

The role requires experience with data analysis, project tracking, and collaboration with internal and external partners; hybrid office/telework, and multi-level posting. The incumbent will coordinate across PUMA, CHIMES, PPMS, and SWIFT systems.

Qualifications

• Two years of professional experience for TPS2; one year for TPS1.
• Data entry, data analysis, or data management in a professional setting.
• Strong organizational skills to manage multiple tasks and detailed records.
• Ability to interpret policies and apply technical guidance.
• Effective communication and coordination with internal/external partners.

Responsibilities

• Initiate and authorize projects and program work under CHIP and STIP.
• Analyze project data to ensure STIP/CHIP compliance and accuracy.
• Review and modify construction financial data for SRC budget reconciliation.
• Coordinate with Metro District, Central Office, and partners on program information.

Skills

Data entry

Data analysis

Data management

Organization

Written communication

Excel

Word

Outlook

Partnership coordination

Education

Bachelor's degree in Business, Accounting/Finance, or Data Analysis

Tools

PUMA/P6

CHIMES

PPMS

SWIFT

Excel

Job description

• Telework Eligible: Yes
• Education/License Verification
• Driver’s License Verification

Working Title: PUMA and STIP Data Coordinator Job Class: Transportation Program Specialist 2 OR Transportation Program Specialist 1 Agency: Transportation Dept

• Job ID: 96986
• Location: Roseville
• Telework Eligible: Yes
• Full/Part Time: Full-Time
• Regular/Temporary: Unlimited
• Who May Apply: Open to all qualified job seekers
• Date Posted: 09/12/2026
• Closing Date: 09/25/2026
• Hiring Agency/Seniority Unit: Transportation Dept / Transportation-MAPE
• Division/Unit: Metro / Planning Prgm Mgmt & Transit
• Work Shift/Work Hours: Not Applicable Shift
• Days of Work: Monday - Friday
• Travel Required: No
• Salary Range - Transportation Program Specialist 1: $24.40 - $35.30 / hourly; $50,947 - $73,706 / annually
• Salary Range - Transportation Program Specialist 2: $26.89 - $39.22 / hourly; $56,146 - $81,891 / annually
• Job Class Option: Traffic Management
• Classified Status: Classified
• Bargaining Unit/Union: 214 - MN Assoc of Professional Empl/MAPE
• FLSA Status: Nonexempt
• Designated in Connect 700 Program for Applicants with Disabilities: Yes

The work you'll do is more than just a job.

At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.

NOTE: THIS POSTING REPRESENTS ONE MULTI-LEVEL POSTING. IF THIS POSITION IS NOT FILLED BY QUALIFIED APPLICANTS AT THE TRANSPORTATION PROGRAM SPECIALIST 2 (TPS-2) LEVEL, THE POSITION MAY BE FILLED AT THE TRANSPORTATION PROGRAM SPECIALIST 1 (TPS-1) LEVEL.

This position is located at district headquarters in Roseville and has the flexibility to work in the office or a hybrid schedule that includes in office and teleworking time. If working a hybrid schedule, the incumbent will be required to make a telework arrangement with their supervisor. The incumbent will be expected to work in the office as determined by policy and discussion with their supervisor.

This position provides professional assistance in the initiation and authorization of projects and programmatic work that is encompassed by MnDOT's Capital Highway Investment Plan (CHIP) and State Transportation Improvement Program (STIP). Related work can include planning-level investment analysis about the array of projects being considered for inclusion in the STIP and CHIP. This position assists with analysis of project data to ensure compliance and accuracy with STIP and CHIP processes.

This position helps to manage Metro District's Program information and is a key user of the underlying support systems; such as Project Unification Management Application (PUMA) Project Scheduling (P6), the Capital Highway Investment Management Enterprise System (CHIMES), Program and Project Management System (PPMS), as well as elements of the Statewide Integrated Financial Tools (SWIFT) system. This position assists with review and modification of construction financial data to ensure the quality and accuracy of State Road Construction (SRC) budget reconciliation.

This position is the initial point of coordination for project tracking and funding information, serving Metro District, Central Office, Metropolitan Council and other partners. This position works in Metro District's Program Management unit which actively monitors 350-400 highway construction projects representing over $1.5 billion in transportation investments.

The Minnesota Department of Transportation does not sponsor applicants for work visas or Optional Practical Training Extensions for STEM Students. Individuals must be legally authorized to work in the US at the start of employment.

Minimum Qualifications

Minimum qualifications for the TPS1 position is as follows:

One year of professional experience OR Two years of advanced clerical OR Two years of technical experience.

Minimum qualifications for the TPS2 level is as follows:

Two years of professional experience.

Experience at both the TPS1 and TPS2 levels must demonstrate the following:

• Experience performing data entry, data analysis, or data management in a professional setting, including working with large datasets or multiple data systems to ensure accuracy and consistency.
• Strong organizational skills sufficient to manage multiple tasks, maintain detailed records, and keep complex program information current.
• Experience preparing written documentation such as reports, forms, spreadsheets, or summaries used for program tracking or decision-making.
• Ability to interpret and apply policies, procedures, or technical guidance related to programs, projects, or funding.
• Ability to effectively communicate and coordinate with internal and external partners to obtain information, resolve discrepancies, or support joint project work.
• Ability to organize, administer, and document meetings with detailed and organized agendas, schedule invites, and minutes.
• Proficiency with standard office software (for example: Excel, Word, Outlook) sufficient to maintain data, track progress, and produce reports.

Note: A Bachelor's or Master's degree in Business, Accounting/Finance, or Data Analysis substitutes for one year of professional experience at both the TPS1 and TPS2 levels.

Preferred Qualifications

• Knowledge of transportation project development, scheduling, and estimating sufficient to analyze capital investment estimates and data and identify errors.
• Familiarity with the State Transportation Improvement Program (STIP) process and the tools used to develop the STIP including the Capital Highway Information Management Enterprise System (CHIMES).
• Expertise in the use of Microsoft Excel to maintain and track data.

Additional Requirements

It is our policy that the successful candidate pass a background check prior to employment. The background check may consist of the following components:

• SEMA4 Records Check/employment verification
• Criminal History Check
• Employment Reference Check
• Education/License Verification
• Driver’s License Verification

Working together to improve the state we love.

What do Minnesota's State employees have in common?

• A sense of purpose in their work
• Connection with their coworkers and communities
• Opportunities for personal and professional growth

Benefits

As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.

Your benefits may include:

• Paid vacation and sick leave
• 12 paid holidays each year
• Low-cost medical, dental, vision, and prescription drug plans
  • Fertility care, including IVF
  • Diabetes care
  • Dental and orthodontic care for adults and children
• 6 weeks paid leave for parents of newborn or newly adopted children
• Pension plan that provides income when you retire (after working at least three years)
• Employer paid life insurance to provide support for your family in the event of death
• Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
• Tax-free expense accounts for health, dental, and dependent care
• Resources that provide support and promote physical, emotional, social, and financial well-being

Support to help you reach your career goals:

• Training, classes, and professional development
• Tuition reimbursement
• Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov)

Employee Assistance Program (EAP) for work/life support:

• A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
• Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
• Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

Programs, resources and benefits eligibility varies

based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.

EQUAL OPPORTUNITY EMPLOYERS

Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourages persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans.

All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law.

Applicants With Disabilities

Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email [e-mail] and let us know the support you need.

The Minnesota Department of Transportation (MnDOT) encourages participation in all its programs, services and activities and does not discriminate against qualified applicants with disabilities. Anyone who believes they may need a reasonable accommodation in order to fully participate in the job application, interview or selection processes may contact any agency official with whom applicant has contact in the processing of their employment application to request an accommodation. Applicants may also contact the MnDOT Affirmative Action office to request an accommodation by: E‑Mail: [e-mail]; or by calling Janet Miller at 651/366-4720; or using MN Relay 711.

The MnDOT Reasonable Accommodation policy can be found at: http://www.dot.state.mn.us/policy/hr/hr009.html.