I&T Data Services Analyst

Department:
Innovation and Technology Department Salary: $85,288.00 - $ 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

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.

• 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…