Dashboard Reporting Specialist

October 16, 2026

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: 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 <ul><li>Operates, maintains, and refreshes all PMO Power BI dashboards solutions, including semantic models, reports, dashboards, dataflows or other managed datasets, workspaces, and published apps.</li><li>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.</li><li>Verifies data accuracy and coordinates with the Program Controls Analyst before scheduled refreshes.</li><li>Assists in preparing and maintaining the monthly reporting data set, including validating data and organizing source inputs.</li><li>Troubleshoots dashboard performance, functionality, and data integrity issues.</li><li>Supports continuous improvement efforts by identifying opportunities to automate reporting and visualization processes. </li></ul>Data SharePoint File Maintenance and Content Coordination <ul><li>Maintains structured SharePoint libraries, lists, metadata, and views to ensure clean, organized PMO sites.</li><li>Performs minor SharePoint configuration (views, list updates, metadata adjustments) while IT retains responsibility for full site development.</li><li>Coordinates with project managers to ensure timely, accurate updates to project pages, schedules, and reporting files.</li><li>Ensures proper file naming conventions, folder structure, and version control across PMO SharePoint environments. </li></ul>GIS and Story Maps Coordination <ul><li>Interprets and utilizes GIS datasets to support project and program reporting requirements.</li><li>Maintains PMO ArcGIS Online feature layers, web maps, geographic datasets, and attributes used by dashboards and other program reporting products.</li><li>Collaborates with GIS personnel and data owners to ensure accurate representation and use of spatial data.</li><li>Applies geographic analysis concepts to communicate project status, risks, opportunities, and performance metrics.</li><li>Creates, updates, and publishes ArcGIS Story Maps that visually communicate project and program information.</li><li>Coordinates mapping inputs with project managers and ensures GIS content aligns with dashboards and SharePoint materials. </li></ul>Power Platform Support <ul><li>Develops light workflow automations using Power Apps and Power Automate to support PMO operational efficiency.</li><li>Ensures all automations and digital tools follow RTD governance, security, and data handling standards. </li></ul>Other <ul><li>Performs all other job-related duties as assigned. </li></ul>Qualifications Required Qualification: <ul><li>High School diploma, GED or equivalent.</li><li>Minimum of five (5) years of experience in developing and maintaining Power BI dashboards using DAX, Power Query, and structured data models.</li><li>Experience maintaining SharePoint Online libraries, lists, metadata, views, and structured content used in reporting or operational workflows.</li><li>Experience preparing structured data sets to support recurring reporting cycles.</li><li>Experience with GIS tools such as ArcGIS Online and Story Maps, feature layers, web maps, and ArcGIS StoryMaps.</li><li>Ability to coordinate with staff responsible for graphic production and written communications to ensure consistent and accurate presentation of information.</li><li>Strong communication skills and ability to support project managers with content updates and reporting needs. </li></ul>Preferred Qualifications <ul><li>Experience maintaining or developing Power Apps or Power Automate.</li><li>Experience in public sector, infrastructure, transit, or project controls environments.</li><li>Experience working with multiple data sources, file types, and structured datasets.</li><li>Experience with SQL, APIs, or enterprise system data.</li><li>Microsoft PL‑300 certification or equivalent. </li></ul>OR <ul><li>An equivalent combination of education, experience, knowledge, skills, and abilities. </li></ul>Key Competencies & Characteristics <ul><li>Strong organizational skills and attention to detail.</li><li>Ability to maintain structured digital systems and enforce process consistency.</li><li>Ability to work collaboratively with analysts, visualization staff, and project managers.</li><li>Strong problem‑solving skills and ability to troubleshoot data or dashboard issues.</li><li>Ability to learn additional PMO tools and systems as needed.</li><li>Strong written and verbal communication skills; including the ability to convey technical content effectively. </li><li>Strong planning, organizing, and prioritization skills with attention to detail. </li></ul>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 adarequests@rtd-denver.com, or the Talent Acquisition team rtd.ta@rtd-denver.com. To learn more or see our EEO policy, please visit our EEO page at: 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.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...