Information Technology · Headquarters- Castle Rock, CO

Business Intelligence Developer

Haga clic aquí para ver Vacantes y Solicitar en Español

Looking for an opportunity to make a lasting mark on future generations and the communities they call home? Search no further, HEI has been an unrivaled contracting leader for over 50 years, with operations in Arizona, the Carolinas, Colorado, and Texas.

As a top heavy civil construction company, we are dedicated to transforming landscapes across these regions, and we want you to join our team. With a relentless focus on safety, people, quality, and production, we tackle diverse projects that range from roadways and bridges to water infrastructure and environmental restoration.

Our team is comprised of highly skilled individuals, just like you, who are ready to put their best boot forward. Get ready to unearth your true potential and dig into the exciting world of HEI Civil!

We are looking to hire an experienced Business Intelligence Developer to join our team! The Business Intelligence Developer is an individual contributor reporting to the Director of Data and Automation. This role is responsible for owning end-to-end business intelligence projects, from requirements gathering through implementation and maintenance. It maintains and improves critical data systems (Spectrum, HCSS) as an admin, develops and maintains Power BI reports and dashboards, and builds automation workflows.

Responsibilities:

System Administration & Maintenance

Manage admin access and maintain systems
Monitor data pipelines and ETL processes; identify and resolve data integrity issues
Manage Power BI workspace structure, permissions, and refresh schedules
Troubleshoot system issues and escalate when needed

Power BI Development & Reporting

Build, maintain, and optimize Power BI dashboards and reports
Design efficient data models that are easy to understand and maintain
Own your reports end-to-end: you can explain the logic and troubleshoot issues

Automation & Workflows

Build and maintain automation workflows using Zapier, Power Automate, and/or Python
Implement new automation requests; manage timelines and proactively surface blockers
Test and validate automations before deployment

Collaboration

Partner with stakeholders across Operations, HR, Finance, and other departments
Translate business requirements into technical solutions

Knowledge, Skills, and Abilities Required:

3+ years of hands-on Power BI development (building reports, data models, DAX)
Strong SQL skills, you can write optimized queries and understand database structures
Proven track record of owning projects end-to-end and delivering on time

Knowledge, Skills, and Abilities Preferred:

Python experience (data cleaning, automation scripts)
Experience with construction industry BI, accounting systems, or payroll data
Familiarity with Spectrum, HCSS, or similar enterprise systems
Experience with data validation and quality assurance processes
Automation tools (Zapier, Power Automate, Power Apps)
ML/AI concepts
Azure or cloud data platforms
Git/version control

Education and Experience:

Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or a related field preferred
Experience: 3+ years of hands-on Power BI development (building reports, data models, DAX)

Department: Information Technology
Role: Senior Analyst
Locations: Headquarters- Castle Rock, CO
Yearly salary: $75,000 - $90,000
Employment type: Full-time
Pay type: Salary exempt, pay based on experience
Time Off Benefit: Paid Time Off (PTO)

Physical Requirements and Environmental Conditions

Please review the section below that applies to the role you are applying for:

Office Roles: For office/headquarters-based positions.
Shop & Field Roles: For shop/field-based positions.

Office Roles:

Prolonged periods of sitting at a desk
Must be able to lift and carry up to 50 pounds
Climate-controlled office environment with varying temperatures
Occasional travel to jobsites with exposure to fluctuating weather conditions

Shop & Field Roles:

Work performed primarily outdoors in varying weather conditions, ranging from freezing temperatures to heat above 90°F, in both wet and dry conditions
Work may be performed in confined spaces
Exposure to odors, gases, dust, and dirt
Noise levels ranging from moderate to loud
Frequent lifting and carrying of 10-60 pounds; occasional lifting up to 100 pounds
Frequent overhead reaching and lifting
Majority of time spent standing, crawling, climbing, bending, twisting, pushing, pulling, and reaching
Manual labor, including hand digging as needed
Some Saturday work is required; Sundays are rarely needed

Benefits:

Six paid holidays
Health insurance
401(k) with a discretionary match
$10,000 company-paid life insurance
Voluntary dental, vision, life, and supplemental insurance
Exclusive savings at Boot Barn, on gym memberships, free Denver Zoo tickets, airfare, movie tickets, laptops, and more
Free Employee Assistance Program with mental health, financial, legal, and family support

How to Apply: Please visit our careers page at https://careers.heicivil.com/. The acceptance of applications is ongoing. We only accept online applications. For questions, please contact our Human Resources department at COhr@heicivil.com.

What Safety means to us! Our unwavering commitment to safety creates the foundation for a rewarding career, where your well-being is our top priority. Experience a company that invests in advanced safety protocols, providing you with the tools and support needed to excel while ensuring your security. At HEI, every employee has the power to halt any job site if safety concerns arise. Join our team and become part of a workplace where your voice matters.

Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities. Additional duties may be assigned based on the needs of the business.

Equal Opportunity Employer, including disabled and veterans: HEI Civil provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

We promote a Drug-Free Workplace.