EMCOR Construction Services
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.
Position Vista Report Developer
– ECS, McLean, Virginia (open to other locations that meet the requirements)
Compensation Compensation Range: $100,000 – $120,000. This position is bonus eligible.
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 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.
Essential Duties & Responsibilities
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 GitHub 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 workspaces.
Coordinate testing and validation of new reports and dashboards with end users before deployment.
Qualifications 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.
Preferred Education And/or Experience
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.
Preferred Skills And Abilities
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 teams.
Attention to detail and ability to manage multiple priorities in a fast‑paced environment.
Computer Skills
Proficiency in Microsoft SQL Server, SSRS, Power BI, and Crystal Reports.
Proficiency in Microsoft Office applications (Outlook, Word, Excel).
Experience with Viewpoint Vista is required.
Required Attributes
Integrity, honesty, professionalism, and appropriate concern regarding the dissemination of sensitive and confidential information.
Ability to make sound decisions and produce accurate and timely results.
Prioritization and organization skills in a fast‑paced multi‑task environment.
Analytical ability to monitor, analyze data and solve problems on a tactical and strategic level.
Capability to build positive working relationships with multiple levels of employees and management.
Demonstrated commitment to company values.
Language Skills Must be able to effectively communicate in English and collaborate with customers, employees, unions, government agencies, vendors, suppliers, and other contractor organizations.
Physical Demands Requires regular sitting, seeing, talking, hearing, and handling of objects. May occasionally lift up to 25 pounds. Certain vision abilities are required. Commute to field locations may be necessary.
Work Environment Typical office environment with occasional visits to field locations. Noise level usually moderate to loud.
Equal Opportunity Employer As a leading provider of mechanical and electrical construction, facilities services, and energy infrastructure, we offer a competitive salary and benefits package. We are committed to providing equal opportunities for all employees and applicants.
Notice to Prospective Employees Notice: There have been fraudulent postings and emails regarding job openings. EMCOR Group and its companies list open positions
here . Please confirm that a post or email is genuine before applying.
Benefits Medical, dental, and vision coverage, health savings and flexible spending accounts, life insurance, disability, 401(k) plan, College Coach, and employee assistance program.
Position Details
Seniority Level: Mid‑Senior level
Employment Type: Full‑time
Job Function: Information Technology
Industry: Construction
#J-18808-Ljbffr
Position Vista Report Developer
– ECS, McLean, Virginia (open to other locations that meet the requirements)
Compensation Compensation Range: $100,000 – $120,000. This position is bonus eligible.
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 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.
Essential Duties & Responsibilities
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 GitHub 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 workspaces.
Coordinate testing and validation of new reports and dashboards with end users before deployment.
Qualifications 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.
Preferred Education And/or Experience
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.
Preferred Skills And Abilities
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 teams.
Attention to detail and ability to manage multiple priorities in a fast‑paced environment.
Computer Skills
Proficiency in Microsoft SQL Server, SSRS, Power BI, and Crystal Reports.
Proficiency in Microsoft Office applications (Outlook, Word, Excel).
Experience with Viewpoint Vista is required.
Required Attributes
Integrity, honesty, professionalism, and appropriate concern regarding the dissemination of sensitive and confidential information.
Ability to make sound decisions and produce accurate and timely results.
Prioritization and organization skills in a fast‑paced multi‑task environment.
Analytical ability to monitor, analyze data and solve problems on a tactical and strategic level.
Capability to build positive working relationships with multiple levels of employees and management.
Demonstrated commitment to company values.
Language Skills Must be able to effectively communicate in English and collaborate with customers, employees, unions, government agencies, vendors, suppliers, and other contractor organizations.
Physical Demands Requires regular sitting, seeing, talking, hearing, and handling of objects. May occasionally lift up to 25 pounds. Certain vision abilities are required. Commute to field locations may be necessary.
Work Environment Typical office environment with occasional visits to field locations. Noise level usually moderate to loud.
Equal Opportunity Employer As a leading provider of mechanical and electrical construction, facilities services, and energy infrastructure, we offer a competitive salary and benefits package. We are committed to providing equal opportunities for all employees and applicants.
Notice to Prospective Employees Notice: There have been fraudulent postings and emails regarding job openings. EMCOR Group and its companies list open positions
here . Please confirm that a post or email is genuine before applying.
Benefits Medical, dental, and vision coverage, health savings and flexible spending accounts, life insurance, disability, 401(k) plan, College Coach, and employee assistance program.
Position Details
Seniority Level: Mid‑Senior level
Employment Type: Full‑time
Job Function: Information Technology
Industry: Construction
#J-18808-Ljbffr