POSITION SUMMARY:

The Data Analyst under the direction of the IT Systems Manager is responsible for collecting, analyzing, and interpreting data to identify trends and provide insights for decision-making.

 ESSENTIAL DUTIES and RESPONSIBILITIES:

•  Regularly query and transform data from Salesforce to deliver reports, voter files, etc for internal teams and external customers.
• Transform data across multiple formats.
• Mining data from primary and secondary sources, then reorganizing the data in a format that can be easily read by either human or machine.
• Using statistical tools to interpret datasets.
• Automate data retrieval, transformation, etc. and produce reports and visualizations.
• Collaborating with programmers, engineers, and organizational leaders to identify opportunities for process improvements, recommend system modifications, and develop policies for data governance. Understand data relationships and structures
• Partake in data cleanup and optimization
• Documenting and maintaining data dictionaries
• Producing various reports and validating accurate data.
• Plan, coordinate, and implement database security measures to protect data, software, and hardware.
• Ability to work onsite in downtown Atlanta, Ga with the potential of remote work two days a week (depending on business needs).
• Contribute to the safe, fair, and secure elections for the citizens of Georgia.
• Candidate must be a US citizen
• Will participate in on-call responsibilities.
• Other duties as assigned.

Knowledge, Skills and Abilities:

• Understanding and operational knowledge of SQL, SOSL, and SOQL queries
• Understanding and operational knowledge of Salesforce
• Familiarity with AWS RDS a plus
• Hands on familiarity with data visualization tools such as PowerBI, Grafana, etc.
• Strong familiarity with a scripting and automation technology, which can include Powershell, Bash, Python, Ansible, Terraform, etc.
• Familiarity with automation/scheduling tools such as PowerAutomate, Apache Airflow, Windmill, etc.
• Familiarity with monitoring tools such as Prometheus, Grafana, Telegraf, InfluxDB, Zabbix, etc. a plus
• Familiarity with a statistical language like R..
• Familiarity with database technologies such as MS SQL, PostgreSQL, SQLite, etc.
• Strong mathematical and statistical knowledge.
• Advanced ability to communicate clearly and effectively, both orally and in writing.
• Advanced communication, analytical, and problem-solving skills.
• Excellent customer service to both internal customers and external.
• Demonstrated leadership and project and personnel management skills.
• Self-managed, upholding timelines, critical dates, and meeting deadlines.
• Strong analytical and problem-solving skills.
• Ability to work with minimal supervision, exercise discretion, and use independent judgment.