Reporting and ETL Engineer - BI at Regional Transportation District

Posted in Information Technology 14 days ago.

Type: Full-Time
Location: 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 an equivalent combination of education and relevant experience

  • A minimum of eight years of experience with BI metadata design and development as well as BI User Interface design and development such as interactive Dashboards and Scorecards.

  • A minimum of five years of experience in complex enterprise business applications data discovery, dimensional modeling/data warehousing, relational databases and with Business Intelligence and Enterprise Reporting tools such as, Microsoft Power BI, Cognos, and Crystal Reports.

  • A minimum of eight years of experience with Relational Database Management Systems (RDBMS), preferably Oracle including PL/SQL development. A minimum of eight years of experience in Information Technology working in an advanced business applications software engineering role, working closely with cross-functional business teams to deliver successful solutions.

  • A minimum of five years of experience with requirements/process analysis, conceptual and detailed design, configuration, testing, training, change management, software development and support methodologies.

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

Pay Range:

$75,433.00 - $113,149.75 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.





More jobs in Denver, Colorado


TheCollegeBoard

TheCollegeBoard

Kforce Inc
More jobs in Information Technology


Thales DIS CPL USA Inc.

Ardurra Group, Inc.

Ardurra Group, Inc.