Report Writer - Crystals Reports / SQL / SSRS

Primoris Services Corporation; Town of Texas, Northern (WI, KY); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

401k w/employer match

Health/Dental/Vision insurance plans

Paid time off

10 paid holidays

Stock purchase plan

Job summary

Primoris Services Corporation seeks a Report Writer skilled in Crystal Reports, SQL Server Management Studio, and SSRS to develop and maintain robust reports across the organization. You will craft complex SQL queries, optimize performance, and troubleshoot data issues in collaboration with business users.

Responsibilities include translating business needs into clear report specifications, maintaining existing reports, and ensuring accuracy and reliability of reporting outputs.

Qualifications

• Strong experience using Crystal Reports for complex reporting needs.
• Advanced SQL skills including joins, subqueries, stored procedures and views.
• Experience creating and maintaining SSRS reports and using SSRS in a SQL Server environment.

Responsibilities

• Collaborate with users to gather requirements and translate needs into report specifications.
• Develop and maintain reports using Crystal Reports and SSRS.
• Write and optimize SQL queries, including complex joins and stored procedures.
• Validate data accuracy and troubleshoot report issues and performance problems.
• Provide support and documentation for report usage and ongoing maintenance.

Skills

Crystal Reports

SQL Server Management Studio

SSRS

Advanced SQL

Tools

Vista by Viewpoint

pVault

Job description

## Report Writer - Crystals Reports / SQL / SSRSApplyremote type: Remotelocations: Texastime type: Full timeposted on: Posted Todayjob requisition id: JR101596**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.**Agency Statement**We are not accepting resumes from Third Party Recruiting Firms for this position. If you are an Agency or Search firm representative, contact the Primoris Talent Acquisition Manager directly for consideration. Primoris or its subsidiaries will not be responsible for any fees arising from the use of resumes and online response forms through this source. In addition, Primoris or its subsidiaries will not be responsible for any fees on unsolicited resumes that are submitted to any member of the Staffing or Operations team. Primoris has established an approved vendor program for this service and will only consider accepting submissions from those approved firms. For consideration in becoming an approved vendor, contact HR.**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.# **Power Your Potential.**As a premier specialty contractor, we deliver critical infrastructure services to the utility and energy markets throughout the United States and Canada. We’re proud to provide unmatched value to our clients, a safe work environment to our employees, and innovation to our communities.When you’re part of our team, the opportunities are endless. From career advancement to worldclass benefits, we value, safeguard, invest in, and motivate our employees as we build the future, together. Join us today!