What are the responsibilities and job description for the Power BI / SQL Developer position at GovServicesHub?
Job Description
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
Requirements
Required Skills & Experience : PowerBuilder Development (version 7 or higher) – 5 years T-SQL Query Writing (Sybase / MS SQL Server) – 10 years Data Management (profiling, mapping, validation, analysis) – 10 years Source Control (TFS / Azure DevOps, Git) – 5 years Unit Testing & Documentation – 10 years Testing & Production Support – 5 years Change Management – 5 years Minimum Qualifications : Some college education in Computer Science, IT, Computer Engineering, or related fields Experience working in a hybrid office environment Willingness to learn and adapt to new technologies This role requires a strong understanding of database management, system design patterns, and best practices in software development. The candidate must possess excellent troubleshooting skills and be able to communicate technical concepts effectively with both technical and business teams.
