Vista Report Developer

Company Overview

EMCOR Construction Services (ECS) is part of EMCOR Group, Inc. (NYSE:

ME), a Fortune 500® leader in mechanical and electrical construction, industrial and energy infrastructure, and building services for a diverse range of businesses. ECS is a nationwide group of 50+ operating companies with over 30,000 employees and annual revenues of $10.7 billion. The operating companies provide expertise in commercial, healthcare, institutional, education, hospitality, manufacturing, transportation, water and wastewater markets, as well as integrated life‑safety solutions.

Vista Report Developer – ECS, McLean, Virginia (open to other locations that meet the requirements)

Compensation Range: $100,000 – $120,000. This position is bonus eligible.

The Vista Report Developer is responsible for designing, developing and maintaining reports, dashboards and analytics solutions to support business operations across the organization. The role focuses on translating business needs into actionable insights through SSRS, Power BI and SQL‑based reporting tools, providing timely support and coordination of reporting needs as directed by the Vista Support Manager.

• 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.
• Maintain standardized report packages, SQL objects, and shared data sets used across operating companies. Manage version control and deployment through an established change control process using Git Hub to ensure consistency across environments.
• Communicate progress updates, expected timelines, and testing requirements with users and the Vista Support Manager to ensure clear visibility into ticket status and priorities.
• Write and optimize SQL queries, stored procedures, and views to support data extraction and reporting.
• Create, maintain and optimize application reporting needs including VA Inquiries and WF Notifiers.
• 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 within the Vista Support Team.
• Enhance and support existing Crystal Reports, migrating reporting needs to SSRS and Power BI where appropriate.
• Assist with development and configuration of Trimble Analytics datasets and Power BI work spaces.
• Coordinate testing and validation of new reports and dashboards with end users before deployment.

To perform this job successfully, the individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• 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.
• Working knowledge of Vista by Viewpoint ERP database schema and related reporting tools.
• Experience developing in SSRS and Power BI required;
  Crystal Reports experience preferred.
• Hands‑on experience with SQL Server databases, views and stored procedures required.
• Experience with Trimble Analytics or Power BI Service integrations is a plus.

• Advanced SQL and SSRS report design skills, including subqueries, joins, and parameter‑driven reporting.
• Strong Power BI experience in data modeling (DAX, Power Query), visualization, and deployment.
• Understanding of construction accounting and job cost management.
• Ability to communicate effectively with technical and non‑technical users, with exceptional communication and documentation skills.
• Strong interpersonal skills to collaborate effectively with…