The N.C. 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. The Board is composed of five individuals appointed by the Governor from lists of nominees submitted by the chairs of the two political parties having the highest number of registered affiliates. Agency staff are civil servants subject to the State Personnel Act.
Primary Purpose of the Division:
- 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.
- The U.S. Department of Homeland Security (DHS) has designated elections as critical infrastructure with priority cybersecurity support under the National Infrastructure Protection Plan. The State Board of Elections (SBE) administers and maintains secure administration of elections in North Carolina. 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 Organizational Unit:
The Data Team operates within the State Board of Elections (SBE) Information Technology Division.
The mission of the Data Team is to support the data needs of the SBE business divisions and County Board of Elections (CBE) offices by providing for access to database information resources, reporting, and data analytics services.
Primary Purpose of the Position:
- This position is responsible for lead technical and analytical work with an emphasis on both data analytics and Geospatial Information Systems (GIS).
- Employee uses their knowledge and expertise to participate in the collection, preprocessing and analysis of structured, unstructured, and geospatial data, analyze data from disparate sources to discover trends, propose solutions and strategies to business challenges, and present information using various data visualization tools and techniques.
- This is technical and analytical work in developing, designing, maintaining, and supporting enterprise data analysis and geospatial database solutions, involving state-owned data center(s) and data from one hundred county boards of elections.
- The employee should be able to work collaboratively in cross-functional teams as well as independently with minimal supervision.
Description of Work:
- Functions as lead Data Analyst responsible for the provision of data analysis services at the direction of the Data Team Manager.
- Apply analytic and data science techniques for the purposes of discovering hidden anomalies and trends and find answers to questions relating to elections processes and events.
- 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.
- Based on knowledge of agency systems and supported applications, develop complex SQL code to automate routine administration tasks, and/or continuously monitor infrastructure resources and processes and generate timely operational and maintenance alerts (including the disposition of county/state transactions, replication, scheduled database jobs, and the status of servers and services).
- Establish, administer, and/or follow database management, design, and coding standards.
- Communicate database and/or data related issues and problems with relevant agency team members, developers, testers, and managers.
- Recommend and employ third party database tools to enhance efficiency and support capabilities.
- Consult with testers to troubleshoot application issues and implement fixes as required.
- Devise and implement data management and monitoring processes, data transformations, alerts/notifications, and any other data processing activities as needed.
- Consult with Applications Developers with respect to coding standards, syntax, performance, design, architecture, and best practices regarding the agency's geospatial database and datasets.
- Functions as lead GIS Analyst responsible for the provision of GIS services at the direction of Data the Team Manager.
- Administer, maintain, analyze, design and continuously enhance and maintain the agency's GIS database, systems, and metadata.
- In cooperation with county GIS staff, the SBOE Director, and the Legislative Services Office of the General Assembly, prepare and maintain accurate maps of electoral jurisdictions and related information on an ongoing basis and during normal redistricting changes based on the decennial census.
- Use GIS datasets and spatial functions to gain meaningful insights by combining state elections data and other federal, state and local data such as US Census data and other survey's available through census.gov.
- In coordination with IT team and other agency business unit colleagues integrate geospatial solutions with other systems, data resources, and applications.
Reporting and Data Visualization
- 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.
- 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.
- 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 ad hoc data requests.
- Design dynamic reports for use by county board of election agencies and manage related web applications and intranet reporting sites.
Knowledge, Skills and Abilities / Competencies
- Extensive understanding of data analytics and geospatial systems, concepts, and industry standards and practices.
- Knowledge of SQL, Python; familiarity with R, C#, JSON, jQuery, and GIS concepts are preferred
- Advanced knowledge in math and statistics.
- Comprehensive understanding of applications analysis and programming techniques.
- Proficiency in reporting and data visualization software such as PowerBI, Tableau, SQL Server
- Reporting Services and MS Report Builder.
- An ability to effectively communicate, both verbally and in writing, and build effective working relationships with end-users, application developers, and management.
- Can skillfully manage tasks and projects with a variety of overlapping timelines, complexities, scopes, and priorities.
- Demonstrates commitment to continuous learning and problem-solving skills.
- Comprehensive understanding of database systems and data/database programming techniques.
- Extensive understanding of database systems and ETL (extraction, transformation, and load) concepts.
- Possess the ability to work under time constraints and other demands.
- Must possess the ability to establish and maintain effective working relationships and function well as a team member.
- Ability to train and supervise other employees or contractors when appropriate
Minimum Education and Experience Requirements
Bachelor's degree in Computer Science, Computer Information Systems, Computer Engineering, Math, or Engineering, or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated data base system; Associate degree in Information Systems, Computer Programming, Database Management, Computer Engineering, Math, or Engineering from an appropriately accredited institution and five years of progressive experience in programming and applications analysis including the design and maintenance of an integrated data base system; or an equivalent combination of education and experience.
When you apply, please indicate that you are responding to the posting on My GIS Jobs.