Database Integration and Reporting Specialist at Sargent Electric – Pittsburgh, Pennsylvania

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.

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.

• 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

• 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

• Experience in construction or electrical contracting environments

• Experience building dashboards and executive reporting in Power BI

• Analytical thinking and problem-solving

• Stakeholder communication and collaboration

• Documentation and process discipline

• Ability to prioritize requests and evaluate new needs

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