Election Data Analyst & BI Specialist

State of North Carolina; Salisbury (CT); Vor Ort; USD 82.000 - 102.000; Vollzeit

Zusammenfassung

The State Board of Elections in North Carolina is seeking a Database Administrator I (NS) to support data-driven decision making, maintain and optimize election and campaign finance data systems, and collaborate with program staff and county partners to ensure data accuracy and accessibility.

The role focuses on building SQL queries, developing BI dashboards with Power BI and Tableau, assuring data quality, and supporting audits and fiscal analyses.

Qualifikationen

• Bachelor's degree in Computer Science or related field or equivalent combination of education and experience.
• Experience with data visualization tools (Power BI, Tableau, Excel) and reporting for multiple departments.
• Strong analytical and problem-solving skills applicable to a range of agency functions.
• Ability to translate complex data findings into clear, actionable recommendations for diverse audiences.
• Familiarity with data quality, integrity, and compliance standards.

Aufgaben

• Develop and manage the agency’s business intelligence strategy, emphasizing data integrity validation, operational assessment, and the detection of irregularities across election related systems.
• Analyze incoming data for completeness, accuracy, expected behavior, fiscal accuracy, resource utilization patterns, and compliance; investigate inconsistencies and determine root causes.
• Generate complex, dynamic reports for internal and external stakeholders, ensuring outputs reflect verified, reliable, and actionable information.
• Maintain and enhance data visualization platforms (Power BI, Tableau, SSRS, MS Report Builder) to support investigative workflows, operational oversight, fiscal transparency, and public communication.
• Build and refine data models that accurately represent source systems and highlight areas of potential data quality, compliance, fiscal, and operational risk.
• Collaborate with agency units to define meaningful information needs and design dashboards that reveal trends, anomalies, operational bottlenecks, financial variances, and emerging risks.
• Research and develop predictive analytics, operational performance indicators, fiscal analytics, auditing enhancements, and advanced visualizations to strengthen decision making and oversight.
• Analyze operational data (e.g., workflow timing, submission patterns, throughput measures, county processing performance) to detect inefficiencies or noncompliance.
• Review and validate fiscal data associated with election operations, reimbursements, expenditures, county claims, budgetary activity, and other financial records to identify anomalies or inconsistencies.
• Participate in pre - and postelection audits and statistical evaluations, including contest audits, geocode audits, list maintenance audits, risk limiting audits, Bayesian audits, and fiscal audits, applying investigative methodologies to uncover irregularities and support corrective action.
• Serve as an internal consultant, guiding staff in interpreting analytic findings, identifying root causes, improving operational processes, validating fiscal information, and developing solutions that enhance election administration and compliance.

Kenntnisse

Analytical thinking

Data visualization

Data storytelling

Communication

Project management

ETL concepts

Database concepts

Internal consulting

Adaptability

Ausbildung

Bachelor's degree in Computer Science or related field

Associate degree in CS/IT with 2+ years experience

HS diploma + 5 years related experience

Tools

SQL

GIS databases

Power BI

Tableau

SSRS

MS Access/Report Builder

Jobbeschreibung

The State Board of Elections in North Carolina is seeking a Database Administrator I (NS) to support data-driven decision making, maintain and optimize election and campaign finance data systems, and collaborate with program staff and county partners to ensure data accuracy and accessibility.

The role focuses on building SQL queries, developing BI dashboards with Power BI and Tableau, assuring data quality, and supporting audits and fiscal analyses.