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.

#TAPS

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

 

What You Can Expect

 

Interview & Hiring Process

If you are selected to move forward through the process, here’s what you can expect:

• During the Interview Process
  • Virtual video interview conducted via video with the hiring manager and/or team
  • Camera must be on
  • A valid photo ID must be presented during each interview

• During the Hiring Process
  • Enhanced Biometrics ID verification screening
  • Background check, to include:
    • Criminal history (past 7 years)
    • Verification of your highest level of education
    • Verification of your employment history (past 7 years), based on information provided in your application

Employee Perks

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and