Reporting and ETL Engineer - BI (Information Technology)

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 will be responsible for building and maintaining new and existing Power BI/Crystal Reports/Oracle Reports, data sets, data pipelines, translating requirements into reports/dashboards, systems upgrades, testing, and training in order to deliver effective reporting solutions to internal and external consumers.

RTD unfortunately does not offer sponsorship for employment. This includes sponsorship required now or in the future and includes persons who currently have status via an F-1 visa, OPT, STEM-OPT, H-1B, TN-1, or Form I-766 included. Only applications that require no sponsorship now or in the future will be considered.

 

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 will result in the rejection of your application. Applicants are responsible for ensuring that application materials are received before the closing date and time listed. This posting will cease accepting applications on 8/22/2025.

DUTIES & RESPONSIBILITIES:

ESSENTIAL: 

• Defines business enhancement and reporting requirements, including baseline functionality and system enhancements to augment business functions.
• Plans, designs and develops reporting and data sets in an enterprise data warehouse environment.
• Develops/Adheres to BI coding standards.
• Provides technical and functional development of reporting solutions and data analysis.
• Ensures BI environment is optimized to address business requirements by continually developing and maintaining the Enterprise Data Warehouse schema, structures, and ETL/staging jobs
• Training and presentation duties as required.

OTHER:

• All job-related duties as assigned.

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 accommodations.

• The noise level in the work environment is usually moderate.

QUALIFICATIONS:

• Bachelor's degree in Computer Sciences/Information Technologies or related field, or related and relevant experience.
• A minimum of five years of experience with BI metadata/User Interface design, complex enterprise business applications data discovery, dimensional modeling, etc. with BI/ERP tools
• A minimum of five years of experience with Relational Database Management Systems (RDBMS)
• A minimum of three years of experience with reqs/process analysis, conceptual and detailed design.

KNOWLEDGE, SKILLS & ABILITIES

• Proficient with Microsoft Office Suite.
• Ability to communicate effectively, orally and in writing.
• Ability to use sound judgment.
• Ability to manage time and workload effectively which includes planning, organizing, and prioritizing with attention to details.
• Excellent organizational and analytical skills
• Ability to work a flexible work schedule, on-call 24/7

OR:

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

CAREER MAP:

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

Pay Range:

$92,003.00 - $129,954.50 Annual

To learn more or see our EEO policy, please visit our EEO page at: [ https://www.rtd-denver.com/sites/default/files/files/2022-12/EEO%20Policy%20Statement-%20UPDATED.pdf ]

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.