Data Services Analyst: ETL & Analytics for Public Safety

Charlotte, North Carolina; Charlotte (NC); Híbrido; USD 85.000 - 123.000; Jornada completa

Descripción de la vacante

The City of Charlotte’s Innovation & Technology Department seeks an I&T Data Services Analyst to design, build, and maintain ETL pipelines, databases, and reporting systems supporting CMPD Crime Analysis and Data Analytics. You will develop SSIS/SSRS reports, APIs, and web applications using C#, ASP.NET, and SQL Server; collaborate with analysts and partners; ensure data quality and secure data exchanges.

A strong background in SQL, Python, and data integration is required, with a focus on

Formación

• High School Graduate or Equivalent and seven (7) years of related work experience
• 2 Year College Degree and five (5) years of related work experience
• Bachelor’s Level Degree and three (3) year of related work experience
• Equivalent combination of education and experience acceptable

Responsabilidades

• Develop, improve, and maintain data workflows that move information between CMPD systems, vendor systems, and reporting environments.
• Build and support ETL processes using Python, SQL, PL/SQL, T-SQL, and SSIS so data can be extracted, transformed, loaded, validated, and used reliably.
• Create and maintain secure data integrations, including API-based exchanges using REST, JSON, XML, and related authentication methods.
• Support database design and maintenance by reviewing table relationships, creating or updating stored procedures, documenting data structures, and helping maintain reporting data sources.
• Improve database and workflow performance by troubleshooting failed jobs, resolving integration issues, tuning queries, reviewing server or process logs, and correcting source-to-report data problems.
• Apply data quality, data governance, metadata, and business rule concepts so reports and applications use consistent, accurate, and secure information.
• Develop, maintain, and automate SSRS reports, recurring subscriptions, and other reporting products used by analysts, supervisors, and division leadership.
• Review existing report libraries and reporting processes to identify outdated, duplicative, or inefficient products and recommend updates that improve accuracy, performance, and usability.
• Modernize manual or legacy reporting processes, including Microsoft Access-based reports, by moving appropriate work into more sustainable web-based or server-based reporting solutions.
• Work with end users to clarify reporting needs, translate business rules into SQL logic, test report output, and explain results or report changes in a way that non-technical users can understand.
• Support existing Crime Analysis and Data Analytics web applications by maintaining back-end code, database connections, and application logic.
• Enhance and maintain on-demand web applications using C#, ASP.NET, and related .NET technologies, along with automated reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Use version control and development tracking tools such as Git, TFS, or similar systems to coordinate changes and document work.
• Work with developers, DBAs, analysts, supervisors, and external partners to align technical solutions with business needs and data standards.

Conocimientos

SQL scripting

Python

SSIS

SSRS

C#

ASP.NET

Data governance

API integration

ETL development

Excel

Educación

Bachelor's degree in Information Technology / Computer Science

5+ years related work experience or 3+ years with degree

Herramientas

SQL Server

Oracle

Git

TFS

GitHub

Visual Studio

ETL tools

Descripción del empleo

The City of Charlotte’s Innovation & Technology Department seeks an I&T Data Services Analyst to design, build, and maintain ETL pipelines, databases, and reporting systems supporting CMPD Crime Analysis and Data Analytics. You will develop SSIS/SSRS reports, APIs, and web applications using C#, ASP.NET, and SQL Server; collaborate with analysts and partners; ensure data quality and secure data exchanges.

A strong background in SQL, Python, and data integration is required, with a focus on