Lead Data Analyst - Power BI & SQL for Strategic Insights

Commonwealth of VA Careers; Richmond (VA); Hybrid; USD 73,000 - 90,000; Full time

Job summary

Commonwealth of VA Careers in Richmond, VA seeks a Lead Data Analyst to support strategic decisions in the Clerks Office through advanced data analysis, forecasting, and reporting.

You will create and maintain Power BI reports, develop dashboards and staffing models, and apply SQL to large data sets. Mentoring junior analysts, collaborating with management, and ensuring data confidentiality are key responsibilities in a hybrid work environment.

Qualifications

• Experience creating and maintaining Power BI reports for analytics and forecasting.
• Proficient in SQL for large data sets.
• Ability to train and mentor junior analysts.
• Strong communication of data analysis and recommendations to management.
• Ability to collaborate across sections to gather requirements.

Responsibilities

• Create and maintain Power BI reports for analytics and forecasting.
• Develop dashboards and staffing models to evaluate division performance.
• Use SQL to analyze large data sets.
• Manage SQL queries in CIS Ad-Hoc Query.
• Mentor junior analysts and provide guidance.
• Communicate findings to management.
• Collaborate with management to gather requirements.
• Ensure confidentiality of data and reports.

Skills

Power BI

SQL

Analytics

Data modeling

Mentoring

Tools

Power BI

CIS

Power Automate

Job description

Commonwealth of VA Careers in Richmond, VA seeks a Lead Data Analyst to support strategic decisions in the Clerks Office through advanced data analysis, forecasting, and reporting.

You will create and maintain Power BI reports, develop dashboards and staffing models, and apply SQL to large data sets. Mentoring junior analysts, collaborating with management, and ensuring data confidentiality are key responsibilities in a hybrid work environment.