SQL Server Reporting Services (SSRS) Engineer and Pyramid BI Specialist (Remote)

Overview

GovCIO is hiring a skilled SQL Server Reporting Services (SSRS) Engineer and BI Specialist to support the VA Pyramid Analytics platform. This role involves designing, developing, and maintaining SSRS reports and dashboards, as well as managing and supporting the Pyramid Analytics enterprise BI environment. The ideal candidate will have strong SQL and data visualization skills, experience with report automation, and the ability to assist a large user base with technical support, training, and navigating complex VA data sources. This will be a fully remote position located within the United States.

Responsibilities

Provide technical support as required to ensure the availability and performance of enterprise data and Pyramid Analytics BI environment for internal VA customers/users. Document processes and procedures as needed. Help users develop, implement, and maintain Pyramid Analytics content. Design and implement technology best practices, guidelines, and repeatable processes.

• Develop, modify, and optimize SSRS reports from various data sources.
• Strong written and verbal communication skills; ability to explain complex concepts to a wide variety of individuals with varying technical skills.
• Strong knowledge of logical and physical data modeling concepts.
• Write complex SQL queries, stored procedures, and functions for data extraction.
• Collaborate with stakeholders to gather reporting requirements.
• Ensure data accuracy and integrity in reports and dashboards.
• Support infrastructure (on-prem and cloud), test new platform versions, and assist users with data navigation and training.
• Troubleshoot and resolve reporting issues efficiently.
• Implement best practices for performance tuning and report optimization.

Qualifications

Required Skills and Experience

• Bachelors Degree and 8+ years experience (or commensurate experience)
• Strong experience in SQL development and SSRS report creation.
• Familiarity with Pyramid Analytics or similar BI platforms.
• Excellent problem-solving, documentation, and customer service skills.
• 2+ years of experience using and supporting Pyramid Analytics
• 2+ years use of SQL Server
• 2+ years assisting customers/users in a technical support role
• Strong analytical, conceptual, and problem-solving abilities
• Excellent interpersonal (verbal and written) communication skills
• Ability to work independently and in a team environment.
• Excellent problem-solving and analytical skills.

Clearance Required

• Must reside and work within the continental U.S. and have the ability to obtain and maintain a suitability/public trust clearance.

Preferred Skills and Experience

• Ability to train and support users of varying technical skill levels.
• Software development/engineering background.
• Familiarity with serverless cloud technologies.
• Understanding of Agile.
• Familiarity with AWS and Azure.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.