What are the responsibilities and job description for the Business Intelligence Developer position at Data Visualization Society?
- Full Time
- Aurora, CO
- Posted 7 months ago
- Applications have closed
Improving Your Journey
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.
- 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)
- Pay Range: $75,000-100,000
- Group Medical, Dental, Vision, Life Insurance, Short- and Long-Term Disability
- Retirement plan
- Paid time off
- Professional development/ Tuition reimbursement
Salary : $75,000 - $100,000
