Vista Report Developer

Description

• Enhance and support existing Crystal Reports, migrating reporting needs to SSRS and Power BI where appropriate.
• Communicate progress updates, expected timelines, and testing requirements with users and the Vista Support Manager to ensure clear visibility into ticket status and priorities.
• Assist with development and configuration of Trimble Analytics datasets and Power BI workspaces.
• Write and optimize SQL queries, stored procedures, and views to support data extraction and reporting.
• Design, develop, test, and maintain SSRS and Power BI reports and dashboards integrated with the ERP database Vista by Viewpoint.
• Collaborate with business users and the Vista Support Manager to define reporting requirements and deliver analytics that align with business objectives.
• Manage report-related support tickets from intake to resolution, collaborating directly with end users to gather requirements, define report scope, and ensure business needs are fully understood.
• Coordinate testing and validation of new reports and dashboards with end users before deployment.
• Document all report development and modification work, including report purpose, data sources, business logic, parameters and testing notes to ensure traceability and consistent knowledge sharing withing the Vista Support Team.
• Must monitor and analyze data and solve problems on a tactical and strategic level.
• Maintain standardized report packages, SQL objects, shared data sets used across operating companies. Manage version control and deployment through and established change control process using GitHub to ensure consistency across environments.
• Create, maintain and optimize application reporting needs including VA Inquiries and WF Notifiers.

Requirements

• Must demonstrate integrity, honesty, professionalism, and appropriate concern regarding dissemination of sensitive and confidential information.
• Experience developing in SSRS and Power BI required; Crystal Reports experience preferred.
• Must prioritize and organize work in a fast paced multi-task environment.
• Strong Power BI experience in data modeling (DAX, Power Query), visualization, and deployment.
• Advanced SQL and SSRS report design skills, including subqueries, joins, and parameter-driven reporting.
• Experience with Viewpoint Vista is required
• Working knowledge of Vista by Viewpoint ERP database schema and related reporting tools.
• Understanding of construction accounting and job cost management.
• Must have the ability to make sound decisions and produce accurate and timely results in mind.
• Must demonstrate proficiency in Microsoft Office applications, (i.e. Outlook, Word and Excel).
• Must build positive working relationships with multiple levels of employees and management.
• Hands on experience with SQL Server databases, views and stored procedures required.
• Proficiency in Microsoft SQL Server, SSRS, Power BI, and Crystal Reports.
• 5 - 10 years of experience in report development or data analytics, preferably in the construction industry.
• Working knowledge of the construction industry, operations management, and safety practices a plus
• Strong interpersonal and communication skills with the ability to collaborate effectively with teams.
• Experience with Trimble Analytics or Power BI Service integrations is a plus.
• Strong attention to detail and ability to manage multiple priorities in a fast-paced environment.
• Ability to communicate effectively with technical and non-technical users. Exceptional communication and documentation skills, with attention to detail.

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance