BI Developer / ERP Analyst (Vista)

Kinsley Construction•York Township, PA

7d•Onsite

About The Position

We are seeking a disciplined and experienced BI Developer/ERP Analyst to join our growing IT Team in York, PA. The BI Developer / ERP Analyst serves 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. The ideal candidate should be highly analytical, solve problems independently, and combine strong mathematics and finance acumen with the technical skills needed to design Power BI dashboards, write SQL, and surface insights from operational and financial data.

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.

Nice To Haves

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

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.

Benefits

Competitive salary and benefits package
Single and Family Medical Insurance
Dental
Vision
Short/Long Term Disability
Life Insurance
401K Plan with company match
9 paid holidays
up to 20 days PTO
Opportunities for career advancement and professional development.
A collaborative and inclusive work environment.
A company committed to safety, quality and efficiency in all projects.
The chance to be part of a respected construction company with a long history of excellence.