Regional Transportation District

Apply for this job

Business Intelligence Developer/Architect (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.)

The Business Intelligence (BI) Developer/Architect is responsible for designing, developing, and optimizing BI solutions that enhance data-driven decision-making within asset management. The ideal candidate will have strong expertise in data modeling, ETL processes, dashboard development, and BI architecture, with experience in asset tracking, capital planning, or related fields.

DUTIES & RESPONSIBILITIES:

Essential:

  • BI Architecture & Strategy: Design and implement scalable BI solutions that align with asset management objectives and business needs.
  • Data Modeling & Integration: Develop and maintain data models that support reporting and analytics, integrating data from multiple sources, including asset management systems, financial systems, and operational databases.
  • ETL Development: Design, develop, and optimize ETL processes to ensure accurate, efficient, and timely data processing.
  • Dashboard & Report Development: Build interactive dashboards and reports using tools like Power BI, Tableau, or similar, enabling stakeholders to monitor asset performance, trends, and key metrics.
  • Performance Optimization: Ensure BI solutions are efficient, scalable, and maintainable, optimizing query performance and system responsiveness.
  • Collaboration & Stakeholder Engagement: Work closely with asset management, finance, operations, and IT teams to understand business needs and translate them into BI solutions.
  • Data Governance & Quality: Implement best practices for data governance, validation, and security, ensuring data accuracy and compliance with company policies and regulatory requirements.
  • Automation & Innovation: Leverage AI/ML and advanced analytics where applicable to enhance predictive modeling and asset lifecycle optimization.

​Other:

All job-related duties as assigned

QUALIFICATIONS:

  • Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field. Master's degree preferred.
  • Minimum of 5 years of experience as a BI Developer, Data Engineer, or BI Architect, with a focus on asset management, finance, or operations.
  • Proficiency in BI tools such as Power BI, Tableau, or Looker.
  • Strong SQL skills and experience with data warehousing solutions (e.g., Azure Synapse, Snowflake, AWS Redshift).
  • Experience with ETL tools such as Azure Data Factory, SSIS, or Informatica.
  • Knowledge of cloud data platforms (Azure, AWS, or Google Cloud).
  • Familiarity with Python or R for data analysis is a plus.
  • Understanding of asset management concepts, capital planning, and operational analytics.

Or:

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

CAREER MAP:

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

Senior Business Intelligence Engineer

We are considering all applications for this position up until the position close date of June 12th 2025 at 12AM. For consideration, please be sure to apply before the posting end date.
 
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 at rtd.ta@rtd-denver.com.

Pay Range:

$92,003.00 - $129,954.50 Annual

RTD is an Equal Opportunity Employer, please see our EEO policy [ 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.

Apply
Apply Here done