Apply on Employer Site

EMCOR Construction Services · 1 day ago

Vista Report Developer

McLean, VA

Full-time

Onsite

Senior Level

$100K/yr - $120K/yr

5+ years exp

EMCOR Construction Services (ECS) is part of EMCOR Group, Inc., a Fortune 500 leader in mechanical and electrical construction. The Vista Report Developer will design, develop, and maintain reports and dashboards to support business operations, focusing on translating business needs into actionable insights through various reporting tools.

Construction

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, 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

Qualification

SSRSPower BISQLVista by ViewpointCrystal ReportsTrimble AnalyticsData analyticsConstruction industry knowledgeCommunication skillsInterpersonal skillsAttention to detail

Required

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

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

Preferred

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. 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

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