Vista Report Developer

COMPANY OVERVIEW

 

EMCOR Construction Services (ECS) is part of EMCOR Group, Inc. (NYSE: EME), 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. Our operating companies are mechanical and commercial electrical contractors with expertise that includes virtually all U.S. commercial, healthcare, institutional, education, hospitality, manufacturing, transportation, and water and wastewater markets. We also have several operating companies that focus on commercial fire protection. They provide integrated life safety solutions, including fire detection and suppression systems, and the most advanced security technology available today. The ECS headquarters team provides key support for its electrical and mechanical companies, including finance and accounting, human resources, legal, national purchasing and information technology.

 

information. ECS HQ is based out of McLean, Virginia. However, candidates in other locations and meeting the requirements below may be considered.

 

Compensation Range:   $100,000 - $120,000

This position is bonus eligible.

 

SUMMARY

 

The Vista Report Developer is responsible for designing, developing and maintaining reports, dashboards and analytics solutions to support business operations across the organization. This role focuses on translating business needs into actionable insights through SSRS, Power BI, and SQL-based reporting tools.  Looking for an IT professional with strong organizational and technical skills that can help us provide timely support and coordination of reporting needs as directed by the Vista Support Manager.  Role will be responsible for working with Vista Support Manager and business users across operating companies to design and deliver efficient, accurate and visually engaging reports.

Include the following. Other duties may be assigned.

• 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, 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.
• 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 withing 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. 

To perform this job successfully, the individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. 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. Exceptional communication and documentation skills, with attention to detail. 
• Strong interpersonal and communication skills with the ability to collaborate effectively with teams.
• Strong 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.
• Must demonstrate proficiency in Microsoft Office applications, (i.e. Outlook, Word and Excel).
• Experience with Viewpoint Vista is required

REQUIRED ATTRIBUTES

 

The requirements listed below are representative of characteristics and demonstrated capabilities sought to perform this job successfully.

 

• Must demonstrate integrity, honesty, professionalism, and appropriate concern regarding dissemination of sensitive and confidential information.
• Must have the ability to make sound decisions and produce accurate and timely results in mind.
• Must prioritize and organize work in a fast paced multi-task environment.
• Must monitor and analyze data and solve problems on a tactical and strategic level.
• Must build positive working relationships with multiple levels of employees and management.
• Must demonstrate commitment to company values.

LANGUAGE SKILLS

 

Must have the demonstrated ability to effectively communicate in English, cooperate, and collaborate with multiple levels of customer, employees, unions, government agencies, vendors and suppliers, and other contractor organizations.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

While performing the duties of this job, the employee is regularly required to sit, see, talk, and hear. The employee is regularly required to use hands to finger, handle, or feel objects, tools, or controls. The employee is regularly required to walk, reach with hands and arms, climb or balance and stoop, kneel, crouch, or crawl. The employee may occasionally lift and/or move up to twenty-five (25) pounds. Specific vision abilities required by the job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus.

 

While performing the duties of this job, the employee is regularly required to commute to field locations. The employee must have the ability to navigate around job site locations.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The employee may expect to work in typical office environment conditions except when visiting field locations. Field environments may vary based on project, manufacturing, or weather conditions.  The noise level in the work environment is usually moderate to loud.

As a leading provider of mechanical and electrical construction, facilities services, and energy infrastructure, we offer employees a competitive salary and benefits package and we are always looking for individuals with the talent and skills required to contribute to our continued growth and success. Equal Opportunity Employer/Veterans/Disabled

Notice to prospective employees: There have been fraudulent postings and emails regarding job openings. EMCOR Group and its companies list open positions here. Please check our available positions to confirm that a post or email is genuine.

EMCOR Group and its companies do not reach out to individuals to help with marketing or other similar services. If an individual is contacted for services outside of EMCOR’s normal application process – it is probably fraudulent.

As a leading provider of mechanical and electrical construction, facilities services, and energy infrastructure, we offer employees a competitive salary and benefits package and we are always looking for individuals with the talent and skills required to contribute to our continued growth and success.  Equal Opportunity Employer/Veterans/Disabled

 

Benefits: We are committed to providing employees a comprehensive benefits package which includes medical, dental, and vision coverage, along with health savings and flexible spending accounts, life insurance, disability, a 401(k) Savings Plan, College Coach and employee assistance program.

#ECS

#LI-CS1