Senior Data Analyst - Public Safety

Gwinnett County Government

Lawrenceville, GA

JOB DETAILS
SALARY
$85,311–$99,174 Per Year
SKILLS
Analysis Skills, Application Programming Interface (API), ArcGIS, Best Practices, CAD/CAM (Computer-Aided Design/Computer-Aided Manufacturing), Computer Science, Construction Safety, Continuous Improvement, Corrective Action, Data Analysis, Data Collection, Data Management, Data Mapping, Data Migration, Data Modeling, Data Quality, Data Sets, Data Visualization, Database Extract Transform and Load (ETL), Dental Insurance, Documentation, Driver's License, ESRI, Emergency Management, Employee Assistance Plan, Family Planning, Flexible Spending Accounts, Frequently Asked Questions (FAQ), Genetics, Geospatial Analysis, Health Plan, Healthcare Reimbursement, Homeless Services, Hospital, ITIL (IT Infrastructure Library), Incentive Programs, Information Technology & Information Systems, Insurance, Knowledge Transfer, Law Enforcement, Leadership, Life Insurance, Microsoft Product Family, Military, On Call, Onboarding, Operational Strategy, Operational Support, Performance Analysis, Performance Metrics, Power BI, Prescription Drugs, Public Safety, Quality Monitoring, Relational Databases (RDBMS), Reporting Dashboards, Reporting Skills, Requirements Management, Retirement Plan, SQL (Structured Query Language), Safety Systems, Safety Training, Spatial Data, Staff Requirements, Standards Development, Stewardship, Sustainability, System Integration (SI), System Test, Systems Administration/Management, Technical Leadership, Technical Support, Test Data, Time Management, Tuition Reimbursement, Vision Plan, Workflow Analysis
LOCATION
Lawrenceville, GA
POSTED
30+ days ago

Senior Data Analyst - Public Safety

Salary

$85,311.00 - $99,174.00 Annually

Location

Gwinnett County, GA

Job Type

Full-Time Merit

Job Number

26-03755

Department

Department of Information Technology Services

Opening Date

04/21/2026

Closing Date

6/21/2026 11:59 PM Eastern

FLSA

Exempt

  • Description
  • Benefits
  • Questions

Class Summary

Job Description

The Senior Data Analyst will lead advanced analytics for public safety agencies by building reporting solutions, ensuring data reliability, integrating multi-system datasets, supporting performance measurement, and delivering actionable insights to leadership while contributing to geospatial analysis and continuous improvement of data tools and processes.

Essential Duties

  • Priority Duty 1: Serves as the primary data analytics resource for public safety agencies, designing and maintaining enterprise-level dashboards, automated reports, and analytical models using Power BI, SQL, and related tools to support operational and strategic decision-making
  • Priority Duty 2: Develops and executes complex data queries, extractions, and transformations across multiple public safety data systems, ensuring data accuracy, consistency, and availability for reporting and performance measurement purposes
  • Priority Duty 3: Collaborates directly with public safety agency leadership and operational staff to identify analytical needs, define KPIs and performance metrics, and translate business requirements into technical data solutions and reporting products
  • Priority Duty 4: Supports GIS/ESRI data analysis and mapping initiatives as a secondary function, contributing to the accuracy and integration of geospatial data within public safety analytics workflows and reporting platforms
  • Designs, develops, and maintains Microsoft Power BI dashboards and paginated reports, including the creation of data models, DAX measures, calculated columns, and Power Query transformations tailored to public safety agency stakeholder requirements
  • Authors and executes complex SQL queries to extract, validate, join, and aggregate data from relational databases supporting CAD, RMS, and other public safety applications for use in reporting and analytical products
  • Monitors data quality and integrity across public safety systems, identifying anomalies, discrepancies, and gaps and implementing corrective actions or escalating issues to appropriate technical staff or vendors
  • Develops and maintains standardized reporting templates, data dictionaries, and analytical methodology documentation to ensure consistency, reproducibility, and knowledge transfer across the division
  • Conducts ad hoc data analysis and custom reporting in response to requests from public safety agency leadership, county administration, and other authorized stakeholders, delivering findings in clear and accessible formats
  • Integrates data from multiple public safety systems and platforms through ETL processes, API connections, or manual workflows to produce unified analytical datasets and cross-system reporting views
  • Supports geospatial data analysis efforts using ESRI ArcGIS tools where applicable, contributing to the incorporation of location-based data into analytics dashboards and performance reports. (GIS experience recommended, not required.)
  • Evaluates and recommends enhancements to existing analytics tools, platforms, and data pipelines, staying current with Power BI, SQL, and data visualization best practices and platform updates
  • Provides technical guidance and support to junior staff, agency analysts, and end users on the use of Power BI dashboards, data exports, and self-service reporting capabilities
  • Participates in system upgrade testing, data migration validation, and new application onboarding activities to ensure analytical continuity and data integrity during technology transitions

Other Job Requirements/Information

  • This job is a civilian position in either a public safety department or in Information Technology with close ties to public safety. Due to the sensitive nature of this position, a public safety background which may include motor vehicle & criminal histories, and fingerprinting.
  • This job may require on-call rotation and emergency after hours, weekends, and/or holidays.
  • This job is eligible for a hybrid telework schedule after an initial probationary period and individual approval.

Grade

The grade for this position is C45(1). Salary will be dependent on education and experience.

Effective 4/11/2023, this position is eligible for the Employee Referral Program.

Minimum Qualifications

  • Bachelor's Degree Computer Science, IT or in a related field AND

  • Five years of progressively responsible, professional level analyst and systems experience in a large scale Information Technology environment

  • An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above will also be considered.

  • Certifications in ITIL V4 Foundations, Microsoft PL-300, ESRI Certified Associate.

  • Valid Driver's License from state of residency.

For information related to position-specific essential duties, knowledge and skills, and physical requirements, please click here.

Note: The class specifications listed on this website are not the official class specifications for Gwinnett County and are subject to change.

For more information about this department, please click here.

Additional Information

About Gwinnett County

Welcome to Gwinnett County Government

Gwinnett County Government is an award-winning employer that believes in investing in its employees by providing corporate level benefits, a wellness program, professional development opportunities, career advancement, and more

Careers with impact

Gwinnett County sets the standard as a dynamic, vibrant community where all people can enjoy economic opportunities, safe neighborhoods, plentiful greenspace, and recreational facilities. We are committed to hiring those who share our dedication to making life better for our residents and business owners. The culture of superior service that our employees have created reflects that standard and helps staff, residents, and stakeholders remain vibrantly connected.

Exceptional benefits

Working for Gwinnett County comes with exceptional benefits, including health coverage, a robust wellness program (Spouses can participate, too!), onsite employee wellness center, longevity pay, tuition reimbursement, and more. The value of Gwinnett County benefits can be up to 49 percent of an individual's total compensation.

World-class community

More than a million residents make up Gwinnett's diverse community. The County is located just 45 minutes from Hartsfield-Jackson Atlanta International Airport and 30 minutes from downtown Atlanta. Georgia Highway 316 reduces travel time to the University of Georgia to 25 minutes.

Gwinnett County is an award-winning employer!

  • Atlanta's Healthiest Employer by Atlanta Business Chronicle
  • Green Communities Platinum Certification for Gwinnett County from the Atlanta Regional Commission
  • Top 100 Healthiest Workplaces in America by Springbuk and PR NewsWire and more!

Vision

Gwinnett is the preferred community where everyone thrives!

Mission

Gwinnett proudly supports our vibrantly connected community by delivering superior services.

Values

Integrity: We believe in being honest, building trust, and having strong moral principles.

Accountability: We believe in stewardship, transparency, and sustainability.

Equity: We believe in fairness and respect for all.

Inclusivity: We believe in engaging, embracing, and unifying our communities.

Innovation: We believe in continual adaptation of technology, process, and experience.

Hiring Process

Gwinnett County is an Equal Opportunity Employer. For more information regarding our hiring process, please click the links below:

  • Hiring Process
  • FAQs

Gwinnett County is committed to creating a diverse workforce. As an Equal Opportunity Employer, we prohibit discrimination on the basis of genetic information (including sex), race, color, national origin (including ancestry), gender (identity and expression), sexual orientation, age, marital status, familial status (including pregnancy), disability, military or veteran status, religion, political affiliation, immigration status, homeless status, or any other category protected by law.

Reasonable accommodations for qualified individuals with disabilities may be requested. If you need an accommodation during the application, interview, or testing process, contact Human Resources at 770.822.7915 or HREmployeeRelations@GwinnettCounty.com. This email is only for accommodation requests; for questions related to job postings, use jobs@gwinnettcounty.com.

Our Benefits program is designed to support every aspect of our employees' lives, from physical and emotional to social and financial.

Along with their salary, employees receive a variety of comprehensive benefits as part of their total compensation.

On average, our employees' benefits are worth 48 percent of their base salary!

In other words, employees would spend nearly half of their pay to purchase these benefits on their own. For employees' medical premium alone, the County contributes an average of 91 percent of the cost!

Health

  • Medical plans for active and retired employees
  • Dental and vision plans
  • Prescription drug plan

Wellness

  • Onsite Employee Wellness Center
  • 24/7 Employee Assistance Program (EAP)
  • Immunizations
  • Wellness education and incentive programs
  • Annual wellness fair

Family and Career

  • Training and professional development opportunities
  • Family planning benefits
  • Four weeks of paid parental leave

Time

  • Annual/Sick Leave
  • 12 paid holidays per calendar year
  • 1 paid floating holiday per calendar year

Money

  • Flexible spending accounts for medical and dependent care
  • Health Reimbursement Arrangement (HRA) available
  • Health Savings Account (HSA) available
  • Retirement and Savings Plans
  • 401(a) Defined Contribution
  • 457 (b) Deferred Compensation
  • Longevity pay
  • Tuition reimbursement
  • Financial education programs

Protection

  • Basic, optional, and dependent life insurance
  • Short-term and long-term disability
  • Critical illness and accident insurance
  • Hospital indemnity insurance
  • Identity theft protection

To learn more about the Benefits offered at Gwinnett County, click here.

01

Have you completed a degree in Computer Science, IT, or a related field?

  • Have not completed a degree in the specified fields of study
  • Completed associate degree in the specified fields of study
  • Completed bachelors degree in the specified fields of study
  • Completed masters degree or higher in the specified fields of study

02

How many years of IT experience do you have?

  • none
  • less than 1 year
  • 1 year to less than 2 years
  • 2 years to less than 3 years
  • 3 years to less than 4 years
  • 4 years to less than 5 years
  • 5 years to less than 6 years
  • 6 years to less than 7 years
  • 7 years to less than 8 years
  • 8 years to less than 9 years
  • 9 years to less than 10 years
  • 10 or more years

03

Describe your IT or related experience. If none, type N/A.

04

Describe your experience using Microsoft Power BI to develop and maintain data analytics dashboards and reports. In your response, please include: (a) the types of data sources you have connected to, (b) any DAX measures, calculated columns, or Power Query transformations you have authored, (c) the intended audience(s) for the dashboards you created, and (d) any experience publishing, scheduling, or administering reports within the Power BI Service environment. If you hold the Microsoft PL-300 certification or any other relevant Power BI credentials, please note them in your response. If none, type N/A.

05

Describe your experience working with ESRI ArcGIS products and geospatial data. In your response, please address: (a) which ESRI platforms you have worked with (e.g., ArcGIS Pro, ArcGIS Online, ArcGIS Portal, ArcGIS Enterprise), (b) your experience maintaining or publishing geospatial datasets, layers, or web maps, (c) any GIS workflows or data quality assurance processes you have developed or documented, and (d) whether you have experience supporting GIS in a 911 dispatch, emergency management, or public safety mapping context. If you do not have GIS experience, please indicate that and describe how your data analytics background positions you to learn geospatial tools. Please also note any ESRI certifications you currently hold. If none, type N/A.

06

Do you have any professional experience working in or directly with public safety agencies or organizations (e.g., 911 communications centers, law enforcement, fire, EMS, or emergency management)? If yes, please describe the nature of that experience, including the agency or organization type, your role, the systems or technologies you supported, and the duration of that experience. If you do not have direct public safety experience, please describe any related work in a similarly complex or mission-critical operational environment and how you believe that experience has prepared you for this role. If none, type N/A.

Required Question

Employer Gwinnett County

Address 75 Langley Drive

Lawrenceville, Georgia, 30046

Phone 770.822.7915

770.822.7923

Website http://www.gwinnettcountyjobs.com

About the Company

G

Gwinnett County Government