Job Description
State Board of Elections is the statewide agency that supervises elections administration, enforces campaign finance requirements, and conducts associated investigations. The State Board ensures uniform implementation of state and federal election laws and appoints local officials serving on county boards of elections. Description of Work *Primary Purpose of the Organizational Unit Information Technology operates as a Division of the State Board of Elections (SBE). The mission of Information Technology (IT) is to support and strengthen the Election’s business divisions by providing central services and infrastructure for state-wide access to information resources and technologies for all election officials. Department of Homeland Security (DHS) has designated elections as critical infrastructure with priority cybersecurity support under the National Infrastructure Protection Plan. To this end, NCSBE requires a sophistical and nimble IT practice. The purpose of IT is to research, advise, procure, implement, and support State Board of Election business functions through the use of technology. *Primary Purpose of the Position The primary purpose of this Data Analyst position is to conduct technical and analytical work that provides data reporting for the agency and public along with the management of the automated systems in place that provide such data. Database Administration • Election GIS Administration • Data Auditing • Managing Data Dashboards and Visualizations • Managing Manual and Automated Election Related Data Processes *Knowledge, Skills, and Abilities Recommended in this Position • Comprehensive understanding of database systems and database programming techniques. Extensive experience with Microsoft SQL Server database administration in a Windows Environment. Working knowledge of backup and recovery procedures, replication topologies and implementation, database engine and code tuning and performance optimization, SQL Server Reporting Services, and data modeling. Extensive understanding of database systems and ETL (extraction, transformation, and load) concepts. Proficiency in reporting and data visualization software such as Power-BI, Tableau, SQL • Server Reporting Services and MS Report Builder. Knowledge of Azure Cloud, PowerShell, Python, data warehousing, and Microsoft Excel data analysis is preferred. The employee will serve as an internal consultant, collaborating across divisions and business units within SBOE, building and utilizing modern reporting and data visualization technology to enhance the agency’s ability to administer and support elections processes. Knowledge Skills and Abilities/Management Preferences Recruitment Range $67,122 - $104,879 "This position is currently remote/teleworking; however, the selected candidate must be willing to work onsite at our Raleigh office full-time if business needs require.” Reporting and Business Intelligence Develop, implement, and manage an overall business intelligence strategy for the extraction and processing of data into useful information for consumption by state and county agencies, the media, and the general public. Generate complex reports in response to internal and external data requests. Design dynamic reports for use by county board of election agencies and manage the related intranet data reporting site. Maintain data visualization software such as Power-BI, Tableau, SQL, Server Reporting Services and MS Report Builder. Generate, maintain, and enhance data resources for analysis, reporting and data visualization purposes. Perform detailed analysis of source systems and create source data models. Employ business intelligence software tools to allow agency staff ready access to needed business information. Collaborate with agency business units to identify, define, and create useful reports and information dashboards. Participate in researching and building new predictive analytics methods, reporting and data visualization approaches to facilitate information sharing and decision making. Participate with other team members to conduct, enhance, or initiate various pre-election audits (contest, candidate, referenda, geocode, cross-county, and ballot check),post-election audits (provisional, sample, manual edit, close contest, and data integrity audits), List Maintenance audits (out of county, out of state and out of state DMV crosscheck, duplicate registrations, felons, deaths, citizenship, and age), and risk limiting audits, Bayesian audits, or other statistical audits. Serve as an internal consultant, collaborating across divisions and business units within SBOE, building and utilizing modern reporting and data visualization technology to enhance the agency’s ability to administer and support elections processes. Database Administration Assist in the administration of all county and state campaign finance and