> Markdown version of [/jobs/ext/1457957-erp-specialist](https://www.wearedevelopers.com/jobs/ext/1457957-erp-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ERP Specialist

- **Company:** HEI Civil
- **Location:** Castle Rock, CO, United States
- **Experience:** Starter
- **Salary:** $75,000.0 - $95,000.0
- **Contract:** Internship / Graduate position
- **Skills:** Microsoft Excel, Business Software, Information Systems, Databases, System Configuration, Knowledge Management, Power BI, Standard Sql, SQL Databases, Systems Integration, Powerquery, Tools for Reporting, Api Management
- **Published:** July 27, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=d0a46a2c5400d7e8

## About the Role

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

## Description

Spectrum ERP Administration

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


## Related Videos

- [What if your HR software adapted to you, not the other way around?](https://www.wearedevelopers.com/videos/100259-what-if-your-hr-software-adapted-to-you-not-the-other-way-around)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Building Employee Experience Through Everyday Interactions](https://www.wearedevelopers.com/videos/1763-building-employee-experience-through-everyday-interactions)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)

## Related Articles

- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)