EMCOR Construction Services-posted 14 days ago
Full-time • Mid Level
McLean, VA
5,001-10,000 employees

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.

  • 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.
  • 5 - 10 years of experience in report development or data analytics, preferably in the construction industry.
  • 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.
  • 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
  • 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.
  • Working knowledge of the construction industry, operations management, and safety practices a plus
  • Experience with Trimble Analytics or Power BI Service integrations is a plus.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service