Lead Data Analyst

Lead Data Analyst (Hybrid)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.Essential Duties & Responsibilities:Create and support ongoing maintenance in Power BI of complex data reports used for analytics and forecasting from all Clerk's Office systemsDevelop dashboards and staffing models to evaluate division performance and enhance decision-makingUse advanced statistical, quantitative, and programming methods (e.g., SQL) to analyze large and complex data setsOversee 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 AutomateMonitor complex data to identify changes in solutions and division trendsExamine complex data reports to locate and resolve issues using quantitative tools, advanced computer modeling, and database toolsTrain and mentor junior analysts, providing technical guidance and analytical supportCommunicate data analysis, innovative solutions, and recommendations to management, in writing and verballyCollaborate across sections and partner with management to gather requirements and specificationsProvide technical and data support for all Clerk's Office systems to ensure continuity of servicesEnsure confidentiality of data and reports that are generated for stakeholders, leadership, Commissioners, and General AssemblyPerform related work as requiredEach agency within the Commonwealth of Virginia is dedicated to recruiting, supporting, and maintaining a competent and diverse work force. Equal Opportunity Employer