Lead System and Data Analyst

Virginia State Corporation Commission

Richmond (VA)

On-site

USD 70,000 - 90,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical insurance

Pension plan

Paid parental leave

Disability insurance

Tuition assistance

401(k) matching

Job summary

A state regulatory agency in Richmond, VA is hiring two Lead System and Data Analysts to support business operations and manage technical platforms. Responsibilities include developing PowerBI dashboards, managing SQL queries, and leading data analysis to optimize performance. The ideal candidiate will possess a bachelor's degree and 4+ years of experience in data analysis, SQL, and technical systems support. Competitive salary range of $70,000 to $90,000 offered, with comprehensive benefits.

Qualifications

4+ years of experience in data analysis and reporting, SQL, and advanced technical systems support.
Ability to present data insights effectively to management.
Strong knowledge of data management practices and technologies.

Responsibilities

Develop and maintain PowerBI dashboards and reports for analysis.
Manage SQL queries and data correction scripts.
Lead data collection and analyze trends for decision-making.

Skills

Data analysis

SQL

PowerBI

Statistical methods

Project management

Education

Bachelor's degree in a relevant field

Tools

Power Automate

Microsoft Products

Job description

Lead System and Data Analyst (2 positions)

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

Salary commensurate with qualifications and experience.

The State Corporation Commission is hiring two lead analysts to join the Clerk’s Office and support the business operation functions and management of our technical platforms. The Clerk’s 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. We are recruiting for two critical positions that advance our mission through analytics, systems management, and performance reporting.

Virginia State Corporation Commission provided pay range

This range is provided by Virginia State Corporation Commission. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$70,000.00/yr - $90,000.00/yr

Lead System & Data Analyst

Provide advanced technical and data support for Clerk’s Office systems and analytics functions
Develop and maintain PowerBI dashboards and reports for forecasting and performance analysis
Support the development of dashboards and staffing models to aid management with proper coverage in the Contact Center as well as other areas within the Clerk’s Office
Manage CIS deployments and data correction scripts
Coordinate with the IT and Information Security to resolve technical issues and implement solutions
Create and manage workflows built through Power Automate, such as the subpoena workflow with the Office of General Counsel
Serve as technical lead and support for all third‑party vendor projects
Manage SQL queries stored in Ad‑Hoc Query in CIS, SQL data correction scripts from the support vendor, and SQL data correction scripts created by the Clerk’s Office
Support the ticket management process for DevOps, ServiceDesk, System Security Access, etc.
Support the identification and resolution of Clerk’s Office system deficiencies
Support System Access Security utilizing administrator tools for all systems within the Clerk’s Office including employee access, other Commission employee access, third‑party access via IPs, and test environments
Supervise all edits to Clerk’s Office web pages and ensure all content is correct prior to publishing
Support all internal and external interfaces to Clerk’s Office systems
Identify issues proactively and bring recommendations and solutions to leadership
Identify, research, and recommend potential solutions for technology challenges that enhance efficiency and performance including, but not limited to, workflow, software, hardware, and/or system replacement
Perform related work as required

Lead Data Analyst

Lead data collection and analysis to identify trends, patterns, and actionable insights
Use advanced statistical, quantitative, and programming methods (e.g., SQL) to analyze large and complex data sets
Monitor data to identify business trends, recommend process improvements, and resolve mistakes
Develop and refine KPIs to evaluate division performance and enhance decision‑making
Create and deliver comprehensive reports and dashboards for internal and external stakeholders, including Commissioners and the General Assembly
Communicate data analysis, innovative solutions, and recommendations to management, in writing and verbally
Ensure confidentiality and accuracy of all data and reports
Train and mentor junior analysts, providing technical guidance and analytical support
Provide innovative solutions and make recommendations to management
Collaborate across sections and partner with management to gather requirements and specifications
Review and improve existing reporting technology to enhance accuracy and usability
Perform related work as required

Preferred Qualifications for Lead Analysts

4 or more years of professional experience with data analysis and reporting, SQL, statistics, data management, and/or advanced technical systems support
A bachelor’s degree in computer science, data analytics, data science, information systems, information technology, or a related degree is desirable but not required with 8 or more years of relevant professional experience
Considerable knowledge of data analysis, reporting, and statistical methodologies
Considerable knowledge in technology such as SQL database, PowerBI, and Microsoft products
Considerable knowledge of research methods, program design, planning, and workflow
Considerable knowledge of technology, data, and systems applications; systems development life cycle; and/or desktop support
Ability to assemble, organize, and present statistical information derived from a variety of sources
Ability to lead teams, projects, and initiatives
Ability to solve complex issues and implement innovative solutions
Ability to present ideas in a cogent, understandable, and compelling manner when providing solutions, both verbally and in writing
Ability to be inquisitive, use logic and reasoning, and challenge the status quo
Ability to prioritize work, support change management efforts, and adapt equipment and technology to serve user needs
Ability to establish and maintain effective working relationships with SCC staff, industry personnel, and the public
Knowledge of the functions, statutory responsibilities, and statutes administered by the Clerk’s Office is a plus

SCC Information

Located in downtown Richmond, the State Corporation Commission (SCC) is an independent state agency with regulatory authority over public utilities, insurance, state‑chartered financial institutions, investment securities, retail franchising, and utility and railroad safety, as well as serving as the state’s central filing office for businesses. The SCC is also charged with administering Virginia’s health insurance marketplace. The SCC’s structure is unique. No other state has a single agency with such a broad array of regulatory responsibility.

The SCC offers its employees rewarding, impactful public service work; flexible telework options and work‑life balance; and professional development opportunities. We foster a high‑performing workforce with a commitment to diversity and inclusion, collaboration, and alignment with the SCC’s mission and strategic goals. Core benefits include competitive health and life insurance programs, pre‑tax spending accounts, leave programs, and paid state holidays. Employees participate in a state retirement plan with options for tax‑deferred retirement savings including employer matching. The state funds a short and long‑term disability program. As a state agency, SCC employees may be eligible for the Public Service Loan Forgiveness Program (PSLF).

The SCC regulates various companies and industries in Virginia; therefore, to avoid any conflict, employees are required to sign a Conflict of Interest Form and must dispose of any stock they hold in a regulated company or dispose of any licenses or certificates they hold in any industry regulated by the SCC unless otherwise permitted. Employees also shall report employment of household members by a regulated company.

The SCC does not provide employer sponsorship. We use the E‑Verify system to confirm identity and work authorization.

The SCC is an Equal Opportunity Employer. As a Virginia Values Veterans (V3) Certified Employer, we value and encourage veterans and members of the Reserves and National Guard to apply.

The information you submit must clearly demonstrate your experience and qualifications as they relate to this position. Interview consideration is based on the information submitted online. If requested, the SCC will provide reasonable accommodation to applicants in need of accommodation to provide access to the application and interview process. A background investigation is conducted on the selected candidate as a condition of employment.

This position is classified in the SCC Salary Structure as P‑11 and will be exempt from the provisions of the Fair Labor Standards Act (FLSA).

How to Apply

Interested candidates are strongly encouraged to apply by November 16, 2025.

Qualified candidates are encouraged to apply on the SCC Career Center website at https://careercenter.scc.virginia.gov.

Seniority level