E-470 OVERVIEW:E-470 Public Highway Authority is a dynamic 47-mile toll road on the eastern perimeter of the Denver Metro area that serves its customers as well as providing back-office tolling services for all other toll facilities in the State of Colorado. E-470 strives to provide top-notch customer service, improve safety and save time for our drivers while being Colorado’s one-stop-shop for tolling.

JOB FUNCTION: Business Intelligence Developer will develop end-to-end analytics. This role will require data warehouse development: modeling raw data into useful data sets for analysis purposes in the medallion architecture framework- bronze/raw, silver/cleaned and structured, gold/analysis-ready. Need someone with SQL skillset- ability to read, write, and validate logic. This role would be responsible for building and maintaining dashboards in Tableau.

JOB DUTIES:

• Collaborate with business stakeholders and IT teams to gather and document business requirements for reporting and data analysis.

• Perform data analysis and profiling to ensure data accuracy and quality.

• Responsible for building and maintaining dashboards

• Conduct and present analysis and recommendations on operational problems.

• Optimize and troubleshoot SQL queries and stored procedures to ensure optimal performance.

• Provide ongoing support and training to business users on BI tools and reports.

• Maintain documentation of BI processes, solutions, and data definitions.

SKILLS AND REQUIREMENTS: • College degree in in an analytical field (finance, accounting, mathematics, computer science, economics, natural sciences) or 2+ years applicable experience in-lieu of formal education. • 1-3 years of experience in business intelligence role • Strong written and verbal communication skills • Analytical and problem-solving skills • Data visualization skills • General knowledge of data warehousing, data modeling, and ETL processes • Understanding of data stewardship • Ability to validate logic with limited oversight • Advanced SQL • Ability to design and build automated workbooks in Tableau • Excel (although we don’t do Excel reporting, this is an important tool to know when delivering ad hoc requests)

JOB TYPE: FULL-TIME• Pay Range: $75,000-100,000

BENEFITS:• Group Medical, Dental, Vision, Life Insurance, Short- and Long-Term Disability • Retirement plan • Paid time off • Professional development/ Tuition reimbursement