Report Writer - Crystals Reports / SQL / SSRS

Primoris Services Corporation; United States; Remote; USD 65,000 - 95,000; Full time

Benefits offered by this job

401k w/employer match

Health/Dental/Vision insurance

Paid time off

10 paid holidays

Stock purchase plan

Job summary

Primoris Services Corporation seeks a Report Writer to develop, maintain, and troubleshoot reports using Crystal Reports, Microsoft SQL Server Management Studio, and SSRS. You will translate user needs into accurate, efficient reports and craft complex SQL queries to support operational and financial insights.

Collaborate with business users, optimize data quality, and ensure reports are reliable, well-documented, and user-friendly across utility, energy, and renewables projects.

Qualifications

• Experience developing and maintaining Crystal Reports and SSRS reports.
• Advanced SQL skills: complex queries, joins, stored procedures, views.
• Strong data analysis and troubleshooting abilities.

Responsibilities

• Collaborate with users to gather requirements and define report specs.
• Develop and maintain reports using Crystal Reports and SSRS.
• Write and optimize SQL queries, including complex joins and procedures.
• Validate data accuracy and troubleshoot report issues.
• Document development processes and support users in report usage.

Skills

Crystal Reports

SQL Server Management Studio

SSRS

Advanced SQL

Data Analysis

Excel (PivotTables, VLOOKUP)

Documentation & Communication

Job description

Job Overview:

Report Writer – Crystal Reports / SQL / SSRS

Position Summary

The Report Writer is responsible for developing, maintaining, and troubleshooting reports across the organization using reporting tools including Crystal Reports, Microsoft SQL Server Management Studio, and SQL Server Reporting Services (SSRS).

This role works closely with business users to understand reporting requirements and translate those needs into accurate, efficient, and user-friendly reports. The Report Writer will develop both simple and complex SQL queries, stored procedures, and views to support operational and financial reporting needs.

Essential Duties and Responsibilities

• Collaborate with users and stakeholders to gather requirements, define reporting needs, and document report specifications
• Develop and maintain reports using Crystal Reports and SQL Server Reporting Services (SSRS)
• Write and optimize SQL queries, including complex joins, nested queries, subqueries, views, and stored procedures
• Validate and reconcile report data to ensure accuracy and reliability
• Troubleshoot and resolve report errors, performance issues, and data discrepancies
• Maintain existing reports and modify them as business needs evolve
• Follow company standards, processes, and documentation practices for report development
• Communicate findings and results clearly to users and assist with report usage when needed

Required Skills and Experience

• Strong experience with Crystal Reports
• Extensive experience with Microsoft SQL Server Management Studio
• Advanced SQL skills including complex queries, joins, subqueries, stored procedures, and views
• Experience creating and maintaining SSRS (SQL Server Reporting Services) reports
• Strong data analysis and troubleshooting skills
• Experience working with Microsoft Excel, including PivotTables, VLOOKUPs, and formulas
• Understanding of the full report development lifecycle including design, development, testing, implementation, and support
• Ability to manage multiple requests, prioritize work, and meet deadlines
• Strong communication and documentation skills

Preferred / Nice to Have

• Construction or accounting industry experience
• Experience with Vista by Viewpoint
• Experience with pVault or other paperless document management systems

Company Overview:

Primoris Services Corporation is a premier specialty contractor providing critical infrastructure services to the utility, energy, and renewables markets throughout the United States and Canada. Built on a foundation of trust, we deliver a range of engineering, construction, and maintenance services that power, connect, and enhance society. On projects spanning utility-scale solar, renewables, power delivery, communications, and transportation infrastructure, we offer unmatched value to our clients, a safe and entrepreneurial culture to our employees, and innovation and excellence to our communities. To learn more, visit www.prim.com and follow us on social media at @PrimorisServicesCorporation.

Benefits:

• 401k w/employer match
• Health/Dental/Vision insurance plans
• Paid time off
• 10 paid holidays
• Stock purchase plan

EEO Statement

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.