Dofactory.com
Dofactory.com

Data Analyst

Location
NC
Pay
$81,500 - $122,250 / Year 
--
Fulltime
Level
Junior level
Skills

Job Description

Description of Work

***Time-Limited Position***
**Recruitment Range: $81,500 - $112,063 (pending experience and qualifications)

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.

The North Carolina State Board of Elections is seeking applicants for a Data Analyst position. The purpose of this position is to conduct technical and analytical work that provides data reporting and assists with database development and administration. This position also serves as a backup to the database and GIS administrators. This position is currently funded through federal grant funding. Pending future funding availability, this position would be eligible for permanent status upon management discretion.

Responsibilities:

Reporting and Business Intelligence


  • Create and maintain custom SQL reports and data exports
  • Design dynamic reports
  • Create and maintain data visualizations (Power-BI, Tableau, SQL, Server Reporting Services, MS Report Builder, etc.)
  • Conduct, enhance, or initiate various election audits
  • Collaborate with agency business units to identify, define, and create useful reports and information dashboards.

Database Administration
  • Assist in the administration of all county and state elections databases and database server instances.
  • Develop complex SQL code to automate routine administration tasks, continuously monitor infrastructure resources and processes and generate timely operational and maintenance alerts.
  • Assist with the establishment and administration of database management, design, and coding standards.
  • Provide backup support and coordinate leave coverage with other data team members for all database administration tasks.

Database Development
  • Utilize complex SQL code to construct solutions for application business requirements related to database administration and maintenance tasks
  • Consult with testers to troubleshoot application issues and implement fixes as required.
  • Devise and implement database management and monitoring processes, data transformations, alerts/notifications, and any other data processing activities
  • Consult with Applications Developers with respect to database coding standards, syntax, performance, and best practices.

Knowledge, Skills and Abilities / Competencies

  • Professional Knowledge, Skills, and Competencies (Required):
    • Comprehensive understanding of database systems and database programming techniques.
    • Extensive experience with Microsoft SQL Server database administration
    • Excellent T-SQL skills.
    • 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.
  • Personal Skills (Required):
    • Possess the ability to work under time constraints and other demands.
    • Ability to establish and maintain effective working relationships and function well as a team member.
    • Ability to serve as an internal consultant, collaborating across divisions
    • Ability to occasionally work an irregular schedule to accommodate periodic system updates/upgrades, maintenance and/or emergency needs.

  • Managers Preferences (Recommended):
    Although not required, preference may be given to candidates that are also familiar with R, C#, JSON, jQuery, Geospatial Information Systems/Databases (GIS), geospatial concepts, QGIS and/or data science techniques.

Minimum Education and Experience Requirements

Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or Associate degree in computer science or an IT related field 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 database system; or High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.

Supplemental and Contact Information

PLEASE SUBMIT YOUR APPLICATION ON-LINE USING THIS WEBSITE

All applicants must complete and submit a State application for employment using the NEOGOV Online Job Application System (http://www.oshr.nc.gov/jobs/index.html) for the State of North Carolina. To receive credit for your work history and credentials, you must list the information on the online application form. Any information omitted from the application cannot be considered for qualifying credit. Attached or incorporated resumes (including Text Resumes on application form) WILL NOT be used for screening for qualifying credit. Please make sure you complete the application in full. "See Resume" or "See Attachment" will NOT be accepted. Other attachments (except a DD-214 copy) will also be accepted, but not used in screening for qualifying credit. Applicants are required to scan and attach a copy of their DD-214 (Form 4 or Certificate of Release or Discharge from Active Duty) or discharge orders if they wish to obtain Veteran's preference. Applicants may be subject to a criminal background check.

Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account and click "Application Status". It is not necessary to contact the Human Resources Office to check the status of an application.

If you are having technical issues submitting your application, please call the NEOGOV Help Line at 855-524-5627. If there are any questions about this posting, other than your application status, please contact the Elections Human Resources Office.

CONTACT INFORMATION
NC Board of Elections
Human Resources Management Office
430 N. Salisbury Street
Raleigh, NC 27603
Office Phone: 919-814-0700

 
Ref #
2761390
Posted
18 days ago
  •  
Last updated 17 days ago


Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.