I&T Data Services Analyst

charlottenc; United States; On-site; USD 85,000 - 123,000; Full time

Job summary

The City of Charlotte is seeking a Data Services Analyst to design, develop, and maintain back-end logic, data workflows, reports, and application support for the Crime Analysis and Data Analytics Division. You will bridge data engineering and analytics by improving extraction, transformation, validation, and storage for operational decision support.

Key duties include building ETL pipelines, supporting API integrations, maintaining relational databases, modernizing reporting processes, and

Qualifications

• Experience with relational databases and data warehousing concepts.
• Proficiency in SQL scripting and data integration processes.
• Knowledge of ETL design, data workflows, and reporting tools.

Responsibilities

• Develop, maintain, and optimize data workflows between CMPD systems and reporting environments.
• Create and support ETL processes using Python, SQL, PL/SQL, T-SQL, and SSIS.
• Develop secure data integrations using REST, JSON, and XML for internal/external partners.

Skills

SQL

Python

SSIS

SSRS

C#

ASP.NET

REST

JSON

XML

Git

TFS

Tools

SQL Server

Oracle

Microsoft Access

Job description

Department: Innovation and Technology Department

Salary: $85,288.00 - $122,601.49 Commensurate with Experience

Welcome to the City of Charlotte

Charlotte is America's Queen City, opening her arms to a diverse and inclusive community of residents, businesses and visitors alike. Here you will find a safe, family-oriented city where people work together to help everyone thrive. The mission of the City of Charlotte is to deliver quality public services and promote the safety, health, and quality of life for all residents.

Our guiding principles include:

• Attracting and retaining a skilled and diverse workforce
• Valuing teamwork, openness, accountability, productivity, and employee development
• Providing all customers with courteous, responsive, accessible, and seamless quality services
• Taking initiative to identify, analyze, and solve problems
• Collaborating with stakeholders to make informed decisions

SUMMARY

This position supports the Crime Analysis Division of the Charlotte-Mecklenburg Police Department, a unit responsible for continually leveraging technology and employing a set of systematic, analytical processes to provide timely, targeted information to drive decision making.

The I&T Data Services Analyst designs, develops, and maintains the back-end logic, data workflows, reports, and application support processes that serve CMPD's Crime Analysis and Data Analytics Division. The position bridges data engineering and data analytics by improving how data is extracted, transformed, validated, stored, reported, and used for operational decision support. Work includes developing ETL pipelines, supporting API integrations, maintaining relational databases and reporting environments, modernizing legacy reporting processes, and documenting technical workflows. Assignments require strong knowledge of CMPD data sources, relational database architecture, SQL Server and Oracle environments, Python, SSIS, SSRS, and secure data exchange practices.

Major Duties and Responsibilities:

• Develop, improve, and maintain data workflows that move information between CMPD systems, vendor systems, and reporting environments.
• Build and support ETL processes using tools such as 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 for internal and external data partners.
• 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.
• Document workflows, code changes, report logic, integration steps, database jobs, and support procedures so systems can be maintained and knowledge can be shared across the team.
• Participate in ongoing learning related to programming, data engineering, application support, cloud technologies, and other tools that may improve system performance and service delivery.

Knowledge, Skills & Abilities:

Technical Knowledge:

• Relational database content, table relationships, database design, data warehousing, dimensional modeling, and ER diagramming.
• Required: SQL scripting, PL/SQL, T-SQL, stored procedures, data definition language, SQL Se