Reporting and ETL Engineer - BI at Regional Transportation District in Denver, Colorado

Job Description:

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.

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:

Lead BI Developer

We are considering all applications for this position up until the position close date of 10/16/2024. For consideration, please be sure to apply before the posting end date.

 

RTD provides equal employment opportunities to all employees and applicants for employment without regard to race (including traits historically associated with race, such as hair texture, hair type, or protective hairstyles), color, religion, national origin, ancestry, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, age, genetic information, disability, service in the military, marital status, or any other characteristic protected by applicable federal, state, or local laws and ordinances.

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 Now