BI Developer / ERP Analyst (Vista)

About the role

The BI Developer/ERP Analyst will serve as a technical lead between business units and the IT department for dashboard and report development, data analysis, application configuration, and troubleshooting of Viewpoint Vista ERP and a variety of other line-of-business systems.

Responsibilities

• Design, build, and maintain Power BI dashboards and semantic models that deliver actionable insights on financial performance, project controls, and operations.
• Develop and tune SQL queries, stored procedures, and views against Viewpoint Vista and integrated data sources.
• Partner with Finance, Operations, and Project Management to translate business questions into data models, KPIs, and reports.
• Create and maintain Crystal Reports and SSRS reports from single or multiple systems.
• Manage and support business applications, ensuring data privacy, security, and confidentiality.
• Troubleshoot, maintain, and develop integrations between applications and databases.
• Evaluate changes and updates to source production systems and assess their impact on reporting.
• Improve use of the ERP system through process improvement, configuration changes, and end-user training.
• Create and maintain documentation for applications, data models, integrations, and reports.
• Work closely with IT Support and Application Development teams to resolve end-user issues.
• Other related duties as required or assigned.

Requirements

• Demonstrated experience designing and building production Power BI dashboards, including data modeling, DAX, and report design.
• Strong command of SQL and SQL Server tooling (SSMS, query optimization, views/stored procedures).
• Minimum 4 years' experience in business intelligence, data analysis, application support, database administration, or a related field.
• Bachelor's Degree in Information Technology, Computer Science, Mathematics, Finance, Accounting, or a related field, or an equivalent combination of education and experience.
• Strong mathematical and financial acumen: able to interpret AR aging, budget vs. actual, gross profit, revenue recognition, and project-controls metrics.
• Experience with Crystal Reports and/or SSRS.
• Analytical mindset with the ability to solve problems independently and think with a solution-based approach.
• Ability to carry out assigned tasks independently with little supervision.
• Strong interpersonal skills: clear written and verbal communication, active listening, and a customer-care mindset.

Preferred Qualifications

• Hands-on experience with Viewpoint Vista ERP (and/or Trimble Construction One).
• Construction industry experience.
• Experience administering Power BI workspaces, gateways, and row-level security.
• Experience with SSIS, SSAS, and relational/dimensional data modeling.
• Exposure to additional dashboarding or BI tooling (Metabase, Tableau, etc.).