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
power bi
ssrs
sql server
crystal reports
viewpoint
construction
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
Information not given or found
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
Specializes in large-scale mechanical and electrical systems for complex projects.
Founded with a vision to lead the construction industry and has grown into a key player in the sector.
Offers integrated solutions, covering everything from pre-construction to final commissioning, with a focus on efficiency and quality.
Operates across diverse sectors such as industrial facilities, energy plants, and commercial developments.
Portfolio includes high-profile projects like hospitals, data centers, manufacturing facilities, and large-scale government buildings.
Known for innovation in automation and control systems, offering cutting-edge technology in every project.
Reputation for delivering projects on time and within budget, even in high-stakes environments.
Culture + Values
Safety: Protecting the well-being of our employees and everyone involved in our projects is our top priority.
Integrity: We adhere to the highest standards of ethics, honesty, and transparency in everything we do.
Collaboration: We work as one team, both internally and with our clients, to achieve the best possible outcomes.
Customer Focus: We are committed to delivering value, quality, and service that exceeds customer expectations.
Innovation: We embrace change, continuously improving our processes and technologies to stay at the forefront of the industry.
Excellence: We strive for the highest standards of quality and performance in every project, big or small.
Environment + Sustainability
by 2050
Net Zero Target
Aiming to achieve net-zero carbon emissions across operations.
Focus on reducing energy consumption through energy-efficient solutions in all projects.
Incorporating environmentally sustainable materials and technologies into building designs.
Striving to minimize waste through recycling and reuse initiatives across projects.
Many projects are designed to meet or exceed standards for LEED certification and other green building criteria.
Inclusion & Diversity
Striving to increase the percentage of women in the workforce, particularly in technical and leadership roles.
Focus on developing a diverse leadership team to reflect the communities we serve.
Providing programs and initiatives that encourage personal and professional growth for all employees.