What are the responsibilities and job description for the Power BI/SQL Developer position at GovServicesHub?
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
