ERP Specialist

HEI Civil; Castle Rock (CO); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

401(k) with match

Paid time off

Paid holidays

Life insurance

Dental & Vision

Employee discounts

Job summary

HEI Civil in Colorado seeks an experienced ERP Specialist to optimize Spectrum-based processes and empower field teams with reliable data. You will write SQL queries, build reports in Power BI, and support integrations between Spectrum and other business apps, while collaborating across departments to improve safety, quality, and production.

The role combines hands-on system administration with analytics, offering growth in a stable, safety-focused construction company.

Qualifications

• Bachelor's degree in information systems or a related field.
• 1–2 years of experience with SQL, reporting/BI tools, or systems administration; Viewpoint Spectrum a plus.

Responsibilities

• Serve as the primary user for Spectrum-related support tickets, triaging and resolving issues.
• Administer user access, security, and system configuration; implement controls to reduce risk.
• Coordinate with Spectrum vendor and IT on troubleshooting, upgrades, and escalations.
• Support power users with self-service access while maintaining system integrity.
• Write and optimize SQL queries against Spectrum and related databases.
• Build and maintain reports and dashboards with Data & Automation team.
• Troubleshoot and repair Spectrum-adjacent reports; rebuild as needed.
• Support API integrations and system connectivity between Spectrum and other apps.
• Develop Power Query solutions and contribute to broader automation projects.
• Document processes and reporting logic to reduce knowledge loss.
• Maintain clear documentation for handoffs and transparency.

Skills

SQL

Power BI

Power Query

API integrations

Data reporting

Communication

Problem solving

Cross-functional teamwork

Education

Bachelor's degree in information systems

Experience: 1–2 years with SQL/reporting/tools

Tools

Viewpoint Spectrum

Excel

Job description

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 ERP Specialist to join our team!

Responsibilities:

• Serve as the primary point of contact for Spectrum-related support tickets, triaging and resolving issues.
• Administer user access, security permissions, and system configuration, applying appropriate controls to reduce risk.
• Coordinate with the Spectrum vendor and IT on troubleshooting, upgrades, and escalations.
• Support department power users with appropriate self-service access while maintaining system integrity.

Reporting & Analytics

• Write and optimize SQL queries against Spectrum and related databases to support reporting needs.
• Build and maintain reports and dashboards, partnering with the Data & Automation team.
• Troubleshoot and repair existing Spectrum-adjacent reports, and rebuild those that no longer meet business needs.

Automation & Integrations

• Support API integrations and system connectivity between Spectrum and other business applications.
• Develop Power Query solutions and contribute to broader automation projects.
• Contribute to Data & Automation team initiatives and the Spectrum project backlog.

Documentation & Knowledge Management

• Document key processes, administrative procedures, and reporting logic to build institutional knowledge and reduce risk from staff transitions.
• Maintain clear, current documentation so work is transparent, maintainable, and easy to hand off.

Knowledge, Skills, and Abilities:

• Working knowledge of SQL (queries, joins, basic performance considerations).
• Interest or experience in reporting and analytics tools (e.g., Power BI, Excel, Power Query).
• Familiarity with API integrations and system connectivity concepts, or strong aptitude to learn them.
• Strong problem-solving skills and comfort learning a new enterprise system through training, documentation, and vendor support.
• Excellent communication skills and the ability to work cross-functionally with all departments.
• Prior ERP experience — particularly with Viewpoint Spectrum — is a plus, but not required.
• Comfortable balancing reactive support work with longer-term projects.

Education and Experience:

• Education: Bachelor's degree in information systems or a related field.
• Experience: 1–2 years of experience - Preferably with SQL, reporting/BI tools, or systems administration — through prior roles, internships, coursework, or personal projects. Prior ERP or Viewpoint Spectrum experience is a plus, but not required.

Physical Requirements and Environmental Conditions

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
• Six paid holidays
• Paid Time Off
• 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

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.