Vista Report Developer

About Us

EMCOR Construction Services (ECS) is part of EMCOR Group, Inc., a Fortune 500® leader in mechanical and electrical construction, industrial and energy infrastructure, and building services. ECS operates 50+ companies nationwide, employing over 30,000 people and generating $10.7 billion in annual revenue. Our company supports a diverse range of industries, including commercial, healthcare, institutional, education, hospitality, manufacturing, transportation, and water & wastewater.

ECS HQ is located in McLean, Virginia, though candidates in other locations who meet the qualifications may be considered.

Compensation

Salary range: $100,000 – $120,000, plus bonus eligibility.

Job Summary

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 translates business needs into actionable insights using SSRS, Power BI, and SQL-based reporting tools. You will work closely with the Vista Support Manager and business users across operating companies to deliver efficient, accurate, and visually engaging reports.

• 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 aligned with business objectives.
• Manage report-related support tickets from intake to resolution, gathering requirements, defining scope, and ensuring 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 Git Hub and the change‑control process.
• Communicate progress updates, expected timelines, and testing requirements with users and the Vista Support Manager to ensure clear visibility of 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 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 feasible.
• Assist with the 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 meet the following requirements. Reasonable accommodations may be made for qualified individuals with disabilities.

• 5–10 years of experience in report development or data analytics, preferably in construction.
• Knowledge of construction industry operations, safety practices, and job‑cost accounting.
• Hands‑on experience with SSRS, Power BI, and SQL Server databases, views, and stored procedures.
• Experience with Vista by Viewpoint ERP database schema and related reporting tools.
• Experience in Crystal Reports (preferred) and with Trimble Analytics or Power BI Service integrations (plus).
• Excellent communication and documentation skills; ability to interact with both technical and non‑technical users.
• Strong interpersonal skills, attention to detail, and the ability to manage multiple priorities in a fast‑paced environment.

• Proficiency in Microsoft SQL Server, SSRS, Power BI, and Crystal Reports.
• Proficient in Microsoft Office applications (Outlook, Word, Excel).
• Experience with Viewpoint Vista required.

• Integrity, honesty, and professionalism in handling sensitive and confidential information.
• Sound decision‑making ability and a focus on producing accurate, timely results.
• Effective prioritization and organizational skills in a multi‑task environment.
• Strong analytical and problem‑solving skills at tactical and strategic levels.
• Positive relationship building with employees and management at all levels.
• Commitment to company values.

Effective English communication skills for collaboration with customers, employees, unions, government agencies, vendors, and other contractors.

EMCOR is an Equal Opportunity Employer/Veteran/Disabled.

We offer a comprehensive benefits package that includes medical, dental, and vision coverage; health savings and flexible spending accounts; life insurance; disability; a 401(k) savings plan;
College Coach; and an employee assistance program.

McLean, VA (Remote opportunities available).