ERP Application Engineer

Sylvan, Inc.; Southfield (MI); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Sylvan, Inc. is seeking an ERP Application Engineer to own Vista-based reporting, integrations, and custom solutions.

The role involves collaborating with accounting, payroll, project management, operations, and leadership to translate business needs into reliable, well-documented ERP solutions. The hybrid position is based in Southfield, MI, with in-office days coordinated with the hiring manager; candidates should bring strong Vista expertise, SQL, API integrations, and a practical interest in

Qualifications

• 7+ years of experience in ERP application development, reporting, or systems integration.
• 5+ years with Trimble Viewpoint Vista in construction.
• Working knowledge of construction accounting and project controls.
• Advanced proficiency in SQL Server (T-SQL).
• Strong experience with Crystal Reports/SSRS.
• Experience building SSIS packages or similar ETL tooling.

Responsibilities

• Design, develop, and optimize complex T-SQL queries, views, stored procedures, and functions against the Vista database.
• Build and maintain Crystal Reports and SSRS reports for accounting, project managers, operations, and leadership.
• Develop datasets and dashboards (Power BI or similar) covering job cost, profitability, cash flow, and labor/equipment activity.
• Manage integrations between Vista and third-party systems via APIs or file exchanges.
• Design, build, and support RESTful APIs and services connecting Vista with core systems.
• Collaborate with business users and document scope, deployment steps, and data definitions.

Skills

ERP reporting

System integration

Communication

Problem solving

Tools

SQL Server (T-SQL)

Crystal Reports

SSRS

SSIS

Power BI

REST APIs

Git

CI/CD tooling

Azure DevOps

Trimble Viewpoint Vista

C#/.NET

Job description

ERP Application Engineer

Sylvan is a premier AI-enabled construction services platform powering North American industries through a wide range of multi-trade capabilities. With expertise spanning data centers, energy, automotive, higher education, government, retail, commercial and industrial sectors, Sylvan provides advanced services from planning to project execution and ongoing service maintenance. By combining intelligent technology, expertise, and a commitment to safety and quality, Sylvan is dedicated to driving success for its clients and partners.

We are looking for an ERP Application Engineer to own the reports, integrations, and custom solutions built on Vista, and to extend them with modern APIs, automation, and practical AI tools. This is a hands-on technical role that works directly with accounting, payroll, project management, operations, and leadership. The right person understands how construction companies run on their ERP and can turn a business need into a reliable, well-documented solution. The ideal candidate for this role will have competent construction financial reporting skills, Vista construction expertise, familiarity with systems integrations & APIs, experience with SQL & Data Engineering, clear communication skills and a general curiosity for new technology.

This is a hybrid position based out of our Southfield, MI office, combining in-office collaboration with remote flexibility. Specific in-office days will be coordinated with the hiring manager.

Essential Duties & Responsibilities

• Vista Development & Reporting
  • Design, develop, and optimize complex T-SQL queries, views, stored procedures, and functions against the Vista database, drawing on a working knowledge of Vista table structures, posting logic, and cross-module relationships.
  • Build and maintain Crystal Reports and SSRS reports for accounting, project managers, operations, and leadership, including reports that combine summary, detail, and export options.
  • Develop datasets and dashboards (Power BI or similar) covering job cost performance, project profitability, cash flow and billing status, and labor, equipment, and subcontractor activity.
  • Make sure reporting reconciles to Vista and supports construction accounting standards, internal controls, and audit requests.
• Production Support & Operations
  • Serve as the technical escalation point for Vista and integration issues. Monitor scheduled jobs and interfaces, respond to incidents within defined SLAs, and drive root-cause analysis and lasting fixes.
  • Support Vista upgrades, patches, and module implementations, including testing custom reports, integrations, and code against each new release.
  • Manage changes through source control, testing in non-production environments, and a documented release process, adopting CI/CD practices where they add value.
• Integrations & Automation
  • Design, build, and support integrations between Vista and third-party systems such as payroll and benefits providers, banks, field and estimating tools, subcontractor prequalification, and internal applications.
  • Choose the right integration method for the job, whether SSIS packages, REST APIs, or scheduled file exchanges, with a focus on data accuracy, error handling, and recoverability.
  • Design and maintain RESTful APIs and services that connect internal applications to Vista and other core systems.
  • Automate recurring business processes, such as payroll ACH and positive pay files, benefit carrier feeds, report generation and attachment to Vista records, and approval notifications
• Collaboration, Documentation & Innovation
  • Partner with business users to translate requirements into a defined scope of work with realistic time estimates, and communicate clearly with both technical and non-technical audiences.
  • Document report logic, integrations, APIs, data definitions, and deployment steps so solutions can be supported by others over the long term.
  • Evaluate and prototype practical uses of AI tools to improve development workflows, reporting, and support processes.

Required Skills & Experience

• 7+ years of experience in ERP application development, reporting, or systems integration.
• 5+ years of hands-on experience with Trimble Viewpoint Vista in a construction environment, either at a contractor or as a Vista consultant or partner.
• Working knowledge of construction accounting and project controls, including job cost, WIP, percent complete, commitments, change orders, and construction payroll.
• Advanced proficiency in SQL Server (T-SQL).
• Strong experience designing, optimizing, and troubleshooting Crystal Reports and/or SSRS.
• Experience building and maintaining SSIS packages or comparable ETL tooling.
• Hands-on experience integrating business systems through APIs (REST/JSON) as well as file-based methods.
• Experience supporting production systems, including troubleshooting, incident response, and working against SLAs.
• Excellent written and verbal communication skills and the ability to work cross-functionally.
• Preferred Qualifications
  • Programming experience in C#/.NET or a similar language.
  • Power BI experience, including DAX and data modeling.
  • Experience with Git and CI/CD tooling (e.g., Azure DevOps, GitHub Actions).
  • Experience with Trimble Viewpoint APIs and integration tools, or other Trimble construction applications.
  • Familiarity with construction field and operations software (e.g., HCSS HeavyJob, estimating, or project management platforms).
  • Experience supporting multi-company, multi-division environments, including US and Canadian operations.
  • Familiarity with Microsoft Azure or other cloud platforms.
  • Experience using or integrating AI and LLM-based tools in development or business workflows