Database Integration and Reporting Specialist

Sargent Electric

Pittsburgh, PA, USA

Published: 6/14/2022

Technology

Full Time

Job Description

Job DescriptionSargent Electric Company: Database Integration and Reporting Specialist

Sargent Electric Company (www.sargentelectric.com) is a nationally recognized electrical contractor with deep Pittsburgh roots. Founded in 1907, we’ve grown into one of the region’s largest electrical contracting firms and have been consistently named one of the Fastest Growing Companies by the Pittsburgh Business Times.

We are looking to hire a Database Integration and Reporting Specialist based in our Pittsburgh, PA office. This role requires regular in-office collaboration to support operations, accounting, and IT teams.

Role Summary

The Database Integration and Reporting Specialist designs, develops, and maintains operational, financial, and management reports using data from a variety of sources, including the ERP system, Trimble Vista. This role partners with operational divisions and shared services to deliver accurate reports, lead system integrations, and automate workflows to improve data sharing across teams.

Key Responsibilities

Design, develop, and maintain standard and ad-hoc reports from the ERP system
Write and optimize SQL queries, views, and stored procedures to extract and transform data
Collaborate directly with business users to gather reporting requirements and define data definitions
Ensure data accuracy, consistency, and integrity across all reports
Create dashboards and analytical visualizations using reporting tools (SSRS, Power BI, Crystal Reports, Tableau, or ERP-native tools)
Document report logic, data sources, and business rules
Troubleshoot and resolve data discrepancies or performance issues
Support ERP upgrades, enhancements, and data model changes as they relate to reporting
Work with Corporate Accounting and IT to provide access to ERP and Project Management Systems

Required Qualifications

Bachelor’s degree in Information Systems, Computer Science, Business Analytics, or related field (or equivalent experience)
3–5 years of ERP reporting experience, preferably with Viewpoint Vista
Strong SQL Server experience (T-SQL, joins, aggregations, performance tuning)
Ability to translate business requirements into accurate technical solutions
High attention to detail and data integrity

Preferred Qualifications

Experience in construction or electrical contracting environments
Experience building dashboards and executive reporting in Power BI

Core Competencies

Analytical thinking and problem-solving
Stakeholder communication and collaboration
Documentation and process discipline
Ability to prioritize requests and evaluate new needs

Who This Role Is Ideal For

This position is ideal for someone who:

Lives within commuting distance of Pittsburgh
Enjoys collaborating closely with operational and accounting teams
Wants to leverage ERP and reporting skills in a growing construction-focused environment

Sargent Electric Company Equal Employment Opportunity Statement

Sargent Electric Company and all its affiliate companies are committed to providing equal employment opportunities in all aspects of employment to qualified individuals without regard to the following criteria: race, color, national origin, religion, sex, pregnancy, sexual orientation, gender identity or expression, mental or physical disability, age, familial or marital status, ancestry, military status, veteran status or genetic information as well as any other prohibited criteria under any local, state or federal law applicable to Sargent Electric Company.

czSzrQipHH