Note: The job is a remote job and is open to candidates in USA. Primoris Services Corporation is a specialty contractor providing infrastructure services to the utility, energy, and renewables markets across the United States and Canada. The Report Writer will develop, maintain, and troubleshoot Crystal Reports and SSRS reports, write advanced SQL queries and stored procedures, validate reporting data, and collaborate with business users to support operational and financial reporting needs.
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
Skills
- 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
- Construction or accounting industry experience
- Experience with Vista by Viewpoint
- Experience with pVault or other paperless document management systems
Benefits
- 401k w/employer match
- Health/Dental/Vision insurance plans
- Paid time off
- 10 paid holidays
- Stock purchase plan
- Remote work arrangement
Company Overview
Company H1B Sponsorship