Senior Data Analyst - Public Safety

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.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.

Salary : $85,311 - $99,174