Vista ERP Power User & Data Integration Engineer (Hybrid)

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

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