Dashboard Reporting Specialist

Please complete the application in its entirety. Include all previous employment so that it may be taken into consideration. Please include a resume attachment with submittal of your application. Resume should document months and years with your dates of employment. Failure to submit a complete and timely application may result in the rejection of your application. Applicants are responsible for ensuring that application materials are received before the closing date and time listed.

At Regional Transportation District (RTD), We make lives better through connections!

When you join RTD, you will be among dedicated employees exhibiting RTD's values of passion, respect, diversity, trustworthiness, collaboration, and ownership. RTD is committed to an inclusive and diverse workplace. As part of our diversity value statement, we encourage our employees to honor diversity in thought, people, and experience. Come join RTD on this great journey to be the trusted leader in mobility, delivering excellence and value to our customers and community.

RTD Employee Benefits: https://www.rtd-denver.com/careers/benefits

(RTD Represented Employee Benefits: Please refer to the Labor Agreement included in the above link for details.)

This position maintains and operates the PMO’s digital reporting, file organization, and Graphic Information System (GIS) mapping systems. The role is responsible for managing Power BI dashboards and semantic models, maintaining structured SharePoint data and content, supporting ArcGIS Online maps and StoryMaps, maintaining Power Platform workflows, and preparing monthly reporting datasets. The Specialist ensures Project Management Office (PMO) digital tools remain accurate, organized, and aligned with RTD governance standards.

This position works closely with the Program Controls Analyst to validate source data and collaborates with the Data Visualization Specialist to ensure dashboard outputs align with PMO communication and visual standards. The role supports project managers by coordinating SharePoint content updates, maintaining clear file structures, and ensuring GIS materials and dashboards reflect current project information.

DUTIES & RESPONSIBILITIES:

ESSENTIAL:

Power BI Dashboards and Reporting

• Operates, maintains, and refreshes all PMO Power BI dashboards solutions, including semantic models, reports, dashboards, dataflows or other managed datasets, workspaces, and published apps.
• Designs or updates dashboard visuals and pages, maintains DAX measures, Power Query transformations, model relationships, and other report logic needed to support Program Controls reporting needs.
• Verifies data accuracy and coordinates with the Program Controls Analyst before scheduled refreshes.
• Assists in preparing and maintaining the monthly reporting data set, including validating data and organizing source inputs.
• Troubleshoots dashboard performance, functionality, and data integrity issues.
• Supports continuous improvement efforts by identifying opportunities to automate reporting and visualization processes.

Data SharePoint File Maintenance and Content Coordination

• Maintains structured SharePoint libraries, lists, metadata, and views to ensure clean, organized PMO sites.
• Performs minor SharePoint configuration (views, list updates, metadata adjustments) while IT retains responsibility for full site development.
• Coordinates with project managers to ensure timely, accurate updates to project pages, schedules, and reporting files.
• Ensures proper file naming conventions, folder structure, and version control across PMO SharePoint environments.

GIS and Story Maps Coordination

• Interprets and utilizes GIS datasets to support project and program reporting requirements.
• Maintains PMO ArcGIS Online feature layers, web maps, geographic datasets, and attributes used by dashboards and other program reporting products.
• Collaborates with GIS personnel and data owners to ensure accurate representation and use of spatial data.
• Applies geographic analysis concepts to communicate project status, risks, opportunities, and performance metrics.
• Creates, updates, and publishes ArcGIS Story Maps that visually communicate project and program information.
• Coordinates mapping inputs with project managers and ensures GIS content aligns with dashboards and SharePoint materials.

Power Platform Support

• Develops light workflow automations using Power Apps and Power Automate to support PMO operational efficiency.
• Ensures all automations and digital tools follow RTD governance, security, and data handling standards.

OTHER:

• Performs all other job-related duties as assigned.

QUALIFICATIONS:

Required Qualification:

• High School diploma, GED or equivalent.
• Minimum of five (5) years of experience in developing and maintaining Power BI dashboards using DAX, Power Query, and structured data models.
• Experience maintaining SharePoint Online libraries, lists, metadata, views, and structured content used in reporting or operational workflows.
• Experience preparing structured data sets to support recurring reporting cycles.
• Experience with GIS tools such as ArcGIS Online and Story Maps, feature layers, web maps, and ArcGIS StoryMaps.
• Ability to coordinate with staff responsible for graphic production and written communications to ensure consistent and accurate presentation of information.
• Strong communication skills and ability to support project managers with content updates and reporting needs.

Preferred Qualifications:

• Experience maintaining or developing Power Apps or Power Automate.
• Experience in public sector, infrastructure, transit, or project controls environments.
• Experience working with multiple data sources, file types, and structured datasets.
• Experience with SQL, APIs, or enterprise system data.
• Microsoft PL‑300 certification or equivalent.

OR

• An equivalent combination of education, experience, knowledge, skills, and abilities.

Key Competencies & Characteristics:

• Strong organizational skills and attention to detail.
• Ability to maintain structured digital systems and enforce process consistency.
• Ability to work collaboratively with analysts, visualization staff, and project managers.
• Strong problem‑solving skills and ability to troubleshoot data or dashboard issues.
• Ability to learn additional PMO tools and systems as needed.
• Strong written and verbal communication skills; including the ability to convey technical content effectively. 
• Strong planning, organizing, and prioritization skills with attention to detail. 

WORKING ENVIRONMENT AND PHYSICAL REQUIREMENTS:

The work environment and physical demands described here are representative of those required by an employee to perform the essential functions of this job with or without reasonable accommodation.

The primary work environment is a typical office environment with minimal exposure to excessive noise or adverse environmental issues.

CAREER MAP:

Based on job performance, experience, education and position availability the next step on the career map for this position may be: Data Visualization Reporting Specialist

We are considering all applications for this position up until the position close date of 10/17/2026 at 11:59PM. For consideration, please be sure to apply before the posting end date.

Pay Range:

$71,043.00 - $100,348.50 Annual

EEO POLICY AND ADA ACCOMMODATIONS 

RTD is proud to be an Equal Opportunity Employer, supporting diversity, equity, and inclusion in the workplace. All applicants will be considered for employment regardless to the race, sex, disability status or any other characteristic protected by law and we encourage candidates from all identities, backgrounds, and abilities to apply. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status, or any other protected status in accordance with applicable law. RTD is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, pre-employment testing, participating in the employee selection process, promotions, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require a reasonable accommodation, please reach out to our Employment ADA Coordinator Kris Frazier at [email protected], or the Talent Acquisition team [email protected].

To learn more or see our EEO policy, please visit our EEO page at: https://www.rtd-denver.com/open-records/reports-and-policies/eeo-policy

RTD posts a compensation range that represents a good faith estimate of what RTD anticipates paying for the position at the time of posting.  Starting salary is based on the candidate’s relevant and verified education, training and work experience.  Applicants should submit all relevant and verifiable education, training and work experiences at the time of application.