Lead Data Analyst (Hybrid)

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

Lead Data Analyst

Anticipated Salary Range: $73,000-$90,000

Salary Commensurate with Qualifications and Experience

The State Corporation Commission (SCC) seeks a Lead Data Analyst to join the Clerks Office and support strategic decisions through advanced data analysis, performance measurement, and reporting. The Clerks Office serves as the official custodian of the judicial and administrative records of the Commission and the central filing office in Virginia for most business entities, as well as Uniform Commercial Code (UCC) financing statements. This includes processing more than 800,000 registrations and fees annually for corporations, limited liability companies, business trusts, limited partnerships, general partnerships, and limited liability partnerships. The SCC offers a hybrid work schedule, as well as training and professional development opportunities.

Essential Duties & Responsibilities

• Create and support ongoing maintenance in Power BI of complex data reports used for analytics and forecasting from all Clerks Office systems
• Develop dashboards and staffing models to evaluate division performance and enhance decision-making
• Use advanced statistical, quantitative, and programming methods (e.g., SQL) to analyze large and complex data sets
• Oversee and manage all SQL queries stored in Ad-Hoc Query in the Clerk's Information System (CIS)
• Create, manage, and utilize best practices for workflows built through Power Automate
• Monitor complex data to identify changes in solutions and division trends
• Examine complex data reports to locate and resolve issues using quantitative tools, advanced computer modeling, and database tools
• Train and mentor junior analysts, providing technical guidance and analytical support
• Communicate data analysis, innovative solutions, and recommendations to management, in writing and verbally
• Collaborate across sections and partner with management to gather requirements and specifications
• Provide technical and data support for all Clerks Office systems to ensure continuity of services
• Ensure confidentiality of data and reports that are generated for stakeholders, leadership, Commissioners, and General Assembly
• Perform related work as required