BI Developer / ERP Analyst (Vista)

WHY KINSLEY CONSTRUCTION?

• Competitive salary and benefits package; including Single and Family Medical Insurance/Dental/Vision, Short/Long Term Disability, Life Insurance, 401K Plan with company match, (9) paid holidays, and 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.
• SUMMARY OF 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.

• TYPICAL RESPONSIBILITIES/ESSENTIAL FUNCTIONS
• 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.).
• WE ARE AN EQUAL OPPORTUNITY EMPLOYER
• #J-18808-Ljbffr