G

Power BI/SQL Developer

GovServicesHub
Contract
On-site
Richmond, Virginia, United States
Development

Job Location: Richmond, VA (Hybrid – Tuesday and Wednesday Onsite)

Note: Candidates must be currently local within a commutable distance not to exceed 1.5 hours. The manager is not interested in candidates who will need to relocate to accept the offer. State experience is required.

Job Description:

The Virginia Retirement System (VRS) Data Office team is seeking up to two senior-level Power BI/SQL Developers with strong problem-solving, organizational, and communication skills. This role requires close collaboration with Business, IT, and other stakeholders to support the Data Quality Enhancement initiative and other development efforts. The candidate should be a self-starter with the ability to prioritize tasks effectively.

Responsibilities:

  • Maintain the confidentiality of all business data and adhere to VRS data security policies.
  • Deliver all tasks within agreed-upon timelines.
  • Provide regular status updates and attend required meetings.
  • Develop, design, and maintain Power BI reports and dashboards based on business requirements.
  • Create interactive visualizations, reports, and dashboards to monitor Critical Data Elements.
  • Optimize reports and advise on best practices in data visualization.
  • Work closely with business stakeholders to translate data needs into actionable reports.
  • Develop and optimize SQL queries and stored procedures for data retrieval and manipulation.
  • Write complex DAX queries to enhance report functionality and performance.
  • Support KPIs and other performance indicators through report development.
  • Provide training and support to end-users on Power BI and SQL tools.
  • Review SQL Queries, Execution Plans, Partitions, and Indexing for performance enhancements.
  • Convert Excel data manipulation activities into automated solutions to reduce processing time.
  • Work on special projects assigned by the Chief Operating Officer or Data Officer.

Skill Matrix:

Skill
Required/Desired
Years of Experience
Candidate’s Experience
Last Used
Power BI report/dashboard development
Required
5+ years


SQL Server SQL development (queries, stored procedures, performance tuning)
Required
5+ years


Complex DAX query writing
Required
3+ years


MS SQL Server data modeling & schema design
Required
5+ years


Experience working in an Agile development environment
Required
3+ years


Ability to work independently and in a team with business and technical stakeholders
Required
5+ years


Strong problem-solving and analytical skills
Required
5+ years


Strong communication and interpersonal skills
Required
5+ years


Experience in Pension Benefit Management programs
Required
2+ years


Experience with other BI tools (Tableau, QlikView)
Required
2+ years


Knowledge of Python or R for data analysis
Desired
2+ years


Familiarity with cloud platforms (Azure, AWS)
Required
2+ years


Microsoft Certified: Data Analyst Associate or equivalent
Required
1+ year


Other relevant certifications in SQL, Data Analysis, and Database Management
Required