Lead Data Analyst (Hybrid)

Virginia State Corporation Commission; Richmond (VA); Hybrid; USD 73,000 - 90,000; Full time

Benefits offered by this job

Hybrid work schedule

Training & professional development

Job summary

Virginia State Corporation Commission, located in downtown Richmond, seeks a Lead Data Analyst in the Clerk's Office to support strategic decisions through advanced data analysis, performance measurement, and reporting.

Responsibilities include Power BI maintenance, dashboards, SQL analysis, and mentoring junior analysts while ensuring data confidentiality for leadership and stakeholders.

Qualifications

• Four (4) or more years of professional experience with data analysis and reporting, SQL, statistics, and/or data management.
• A bachelor’s degree in computer science, data analytics, data science, information systems, information technology, or related field is desirable but not required with 8+ years of relevant experience.
• Knowledge of data analysis, reporting, and statistical methodologies.
• Knowledge of PowerBI and Microsoft products.

Responsibilities

• Create and support ongoing maintenance in Power BI of complex data reports for analytics and forecasting.
• Develop dashboards and staffing models to evaluate division performance and aid decisions.
• Use SQL to analyze large datasets and manage Ad-Hoc Query in CIS.
• Provide training and mentorship to junior analysts.

Skills

Power BI

SQL

Data analysis

Forecasting

Statistics

Leadership

Communication

Education

Bachelor's degree in computer science/data analytics

Tools

Power Automate

CIS Ad-Hoc Query

MS Office

Job description

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 Clerk's Office and support strategic decisions through advanced data analysis, performance measurement, and reporting. 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. The SCC offers a hybrid work schedule, as well as training and professional development opportunities.

• Create and support ongoing maintenance in Power BI of complex data reports used for analytics and forecasting from all Clerk's 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 Clerk's 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

Preferred Qualifications

• Four (4) or more years of professional experience with data analysis and reporting, SQL, statistics, and/or data management
• 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 of technology such as SQL database, PowerBI, and Microsoft products
• 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 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 Pay Grade 11 and will be exempt from the provisions of the Fair Labor Standards Act (FLSA).