ERP Specialist

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.
• Cook 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.

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

• 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.

Benefits

• 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.

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

We promote a Drug-Free Workplace. 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.