Especialista en ERP

About the role

We are looking for an experienced ERP Specialist to join our team, helping to shape the future of communities across Arizona, the Carolinas, Colorado, and Texas. As a leader in civil construction, HEI transforms landscapes through diverse projects including roads, bridges, water infrastructure, and environmental restoration. This role is key to maintaining and enhancing our ERP system, Spectrum, ensuring seamless operations across our highly skilled team.

Responsibilities

• ERP System Administration
  • Act as the primary point of contact for Spectrum-related support tickets, triaging and resolving issues.
  • Manage user access, security permissions, and system configurations, applying appropriate controls to mitigate risks.
  • Coordinate with the Spectrum vendor and IT department to resolve issues, implement updates, and escalate as needed.
  • Provide support to power users across departments through self-service access while maintaining system integrity.
• Reporting and Analysis
  • Write and optimize SQL queries in Spectrum and related databases to meet reporting needs.
  • Create and maintain reports and dashboards, collaborating with the Data and Automation team.
  • Troubleshoot and repair existing Spectrum-related reports, rebuilding those that no longer meet business needs.
• Automation and Integrations
  • Support API-driven integrations and connectivity between Spectrum and other enterprise applications.
  • Develop solutions using Power Query and contribute to broader automation projects.
  • Participate in Data and Automation team initiatives and manage the Spectrum-related project backlog.
• Documentation and Knowledge Management
  • Document key processes, administrative procedures, and report logic to build institutional knowledge and reduce risks from personnel changes.
  • Maintain clear, up-to-date documentation to ensure work is transparent, maintainable, and easily transferable to other team members.

Requirements

• Hands-on knowledge of SQL (queries, joins, and 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, or a strong ability to learn.
• Excellent problem-solving skills and comfort learning new enterprise systems through training, documentation, and vendor support.
• Strong communication skills and ability to collaborate across all departments.
• Ability to balance reactive support work with long-term projects.

Qualifications

• Education: Bachelor’s degree in Information Systems or a related field.
• Experience: 1–2 years of experience, preferably with SQL, reporting/BI tools, or system administration, gained through employment, internships, academic work, or personal projects. Prior experience with ERP systems or Viewpoint Spectrum is a plus but not required.