Virginia State Corporation Commission · 3 days ago
Lead System and Data Analyst
Richmond, VA
Full-time
Hybrid
Mid, Senior Level
$70K/yr - $90K/yr
4+ years expThe Virginia State Corporation Commission is hiring two lead analysts to join the Clerk’s Office and support business operations and technical platform management. The Lead System and Data Analyst will blend data analytics expertise with technical system leadership to ensure operational efficiency and data integrity.
FinanceGovernmentInsurancePublic Relations
No H1B
U.S. Citizen Only
Responsibilities
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
Qualification
Required
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 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
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
Benefits
Flexible telework options and work-life balance
Competitive health and life insurance programs
Pre-tax spending accounts
Leave programs
Paid state holidays
State retirement plan with options for tax-deferred retirement savings including employer matching
Short and long-term disability program
Public Service Loan Forgiveness Program (PSLF)
Company
Virginia State Corporation Commission
The State Corporation Commission, or SCC, is a Virginia regulatory agency whose authority encompasses utilities, insurance, state-chartered financial institutions, securities, retail franchising, and railroads.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Keven Patchett
Commission Counsel & Chief Legal Officer
Company data provided by crunchbase