Data Analyst

Commonwealth of VA Careers; Richmond (VA); Hybrid; USD 95,000 - 101,000; Full time

Job summary

The Virginia Retirement System is seeking a Data Analyst to perform complex data analysis and reporting, improve data reporting capabilities, and develop data quality assurance processes. The ideal candidate has expertise in business data analysis, excels at communicating technical information to non-technical audiences, and can leverage SQL, Power BI, and Tableau.

The role involves collaborating with business and technology teams to define, collect, analyze, and report data, and presenting

Qualifications

• Bachelor’s degree in a related field; 3–5 years of data analysis, data science, and/or data warehousing experience
• Advanced knowledge of SQL
• Knowledge of DAX, Power BI, and/or other similar systems
• Excellent communication skills including written, verbal and presentation

Responsibilities

• Collaborate with data owners to ensure data-related objectives are understood and documented
• Gather, evaluate and document business and technical data requirements for new systems, enhancements and defects
• Create customizable reports and visualizations using SQL, Power BI or Tableau
• Design data-driven analyses to improve customer experience and agency objectives
• Present data-driven recommendations and findings with documentation and reports

Skills

Communication skills

Presentation skills

SQL

Power BI

Tableau

DAX

Education

Bachelor’s degree in CS, information management, data science, statistics or related field

Tools

SQL

Power BI

Tableau

DAX

Job description

Title: Data Analyst

Agency: Virginia Retirement System

Location: Virginia Retirement System - Main Office

FLSA: Exempt

Hiring Range: $95,077-$101,000

Full Time or Part Time: Full time

Additional Detail

Applications must be submitted by 11:59 PM (EST) the day before the posted End Date.

Please read all information in the Important Notices section.

The Data Analyst will work both independently and as part of a team to perform complex data analysis and reporting, improve data reporting capabilities, and develop data quality assurance processes. The ideal candidate has expertise in business data analysis, excels at communicating technical information to non-technical audiences, and can leverage tools like SQL, Power BI, and Tableau.

Essential Duties and Responsibilities

• Work collaboratively with business process owners and data owners to ensure data-related business objectives are understood and documented.
• Gather, evaluate and document business and technical requirements related to data for new systems, enhancements and defects based on business user input and data needs.
• Support individual team members in the Data Office as well as various business units, by creating customizable, interactive tabular or visual reports with available tools such as SQL, Power BI or Tableau.

Data Analysis

• Design data-driven analysis to help fellow VRS employees improve customer experience and achieve agency objectives.
• Structure and clean large data sets.
• Collaborate with various business and technology teams to define, collect, analyze, and report data.
• Create reports and visualizations for internal teams and stakeholders.
• Present data-driven recommendations and findings by creating presentations, dashboards, visualizations, documentation, and reports.

Data Office Support

• Serve as subject matter expert on Data Analytics.
• Function as a liaison between the business teams and IT teams for data-related initiatives.
• Participate and assist with the VRS Change Management Process to ensure all activities flow through change management (documentation, test plans, approvals).
• Manage risk and provide timely status reports and project updates to stakeholders.
• Provide cross-team support when needed to achieve technical goals, knowledge sharing, Agency Performance Outcomes (APOs), and operational measures (OMs).
• Participate in software/hardware security reviews and implement best practices for the Data Office.
• Establish KPIs in coordination with business units to measure the effectiveness of business decisions.
• Perform special projects as assigned.
• Other duties may be assigned.

Minimum Qualifications

• Bachelor’s degree from a four-year college or university in computer science, information management, data science, statistics or related field, required; an equivalent combination of education and experience may also be considered
• Three to five years of experience working in data analysis, data science, and/or data warehousing
• Advance knowledge of SQL
• Knowledge of DAX, Power BI, and/or other similar system
• Excellent communication skills including written, verbal and presentation

Additional Considerations

• Three or more years of experience designing dashboards and reports using BI tools such as, Power BI and/or Tableau, or other similar software, preferred
• Experience in pension benefits management, or related industry, preferred
• Working with Excel, Microsoft Access, Power Platform, Data Warehouse, SQL database and/or ETL development, preferred
• Proficiency in programming languages such as Python, Java, R, C (or similar), preferred
• Software development background, preferred

Special Instructions

*VRS is unable to provide sponsorship, for this position*

This position follows the hybrid work model, currently requiring three days on-site and two days remote; the selected candidate must be able to work in the office any day of the week, as required by the manager.

Hiring Range

$95,077-$101,000