Business Intelligence Developer

TITLE: Business Intelligence Developer

LOCATION: Denver, CO (Hybrid)

Advanced SQL, Tableau, ETL, data warehousing, data modeling, medallion architecture, data visualization, Excel, JSON/XML, and experience with Python/R or cloud platforms (Snowflake, Azure, AWS) preferred.

OVERVIEW

The Business Intelligence Developer will help design and deliver end-to-end analytics solutions that empower decision-making across Operations and IT. This is an exciting opportunity to work with large, diverse datasets and transform raw information into actionable insights. The ideal candidate will be a hands-on technologist with a strong grasp of data modeling, visualization, and business analysis.

Responsibilities

• Model raw data into structured datasets using the medallion architecture for scalable analytics.

• Write, validate, and optimize complex SQL queries to extract, transform, and load (ETL) data for reporting purposes.

• Design and build interactive dashboards and data visualizations in Tableau using best practices for speed-to-insight and usability.

• Apply information design principles to improve clarity, engagement, and impact of dashboards and reports.

• Collaborate with cross-functional teams to understand business needs and translate them into technical solutions.

• Conduct in-depth data analysis to identify trends, anomalies, and performance drivers – present findings to stakeholders with clear recommendations.

• Build automated data pipelines and reporting processes to reduce manual effort and ensure data accuracy.

• Maintain and enhance data warehouse solutions, ensuring scalability, performance, and data quality.

• Support ad hoc and exploratory data needs from Operations and IT teams using tools like SQL, Tableau, and Excel.

• Uphold data governance and stewardship best practices, ensuring accuracy, security, and compliance in all BI work.

• Document processes, data sources, and logic to enable collaboration and future enhancements.

• EXPERIENCE REQUIRED

• 2–5 years of experience in a Business Intelligence, Data Analyst, or Data Engineering role.

• Proficient in data warehousing concepts, dimensional modeling, and ETL processes.

• Advanced SQL skills with the ability to work with large, complex datasets.

• Demonstrated experience building advanced dashboards and visualizations in Tableau.

• Strong understanding of data visualization principles and user-centered design.

• Familiarity with medallion architecture or similar modern data architecture frameworks.

• Strong analytical and problem-solving abilities with attention to detail.

• Experience working with both structured and semi-structured data (e.g., JSON, XML).

• Ability to work independently and validate complex data logic with minimal oversight.

• Understanding of data stewardship and governance practices.

• Excellent written and verbal communication skills; able to explain technical concepts to non-technical audiences.

• Proficiency with Microsoft Excel for lightweight analysis and ad hoc data exploration.

• Experience with scripting (e.g., Python, R) or cloud platforms (e.g., Snowflake, Azure, AWS) is a plus.