I&T Data Services Analyst

City of Charlotte; Charlotte (NC); On-site; USD 85,000 - 123,000; Full time

Job summary

City of Charlotte is seeking a skilled I&T Data Services Analyst to design, develop, and maintain data workflows and back-end logic that support CMPD’s crime analysis and data analytics. The role bridges data engineering and analytics, improving data extraction, transformation, validation, storage, and reporting for decision support.

You will work on ETL pipelines, API integrations, relational databases, and reporting environments, using SQL Server, Oracle, Python, SSIS/SSRS, and .NET

Qualifications

• High School Graduate or Equivalent and seven (7) years of related work experience OR 2 Year College Degree and five (5) years of related work experience OR Bachelor's Level Degree and three (3) year of related work experience OR or an equivalent combination of education and relevant experience that provides the required skills, knowledge, and abilities to successfully perform the essential job duties

Responsibilities

• Develop, maintain, and optimize data workflows and ETL processes.
• Build and support ETL pipelines to move data between CMPD systems and reporting environments.
• Create, maintain, and secure data integrations using REST, JSON, XML and authentication methods.
• Support database design and maintenance including stored procedures and reporting data sources.
• Enhance and maintain SSPSSRS reports, subscriptions, and web applications.

Skills

SQL

ETL

Python

Data integration

REST API

Education

Bachelor's degree in IT

Tools

SSIS

SSRS

C#

ASP.NET

MVC.Net

SQL Server

Oracle

Git

TFS

GitHub

Python

Microsoft Access

Excel

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

Relational database content, table relationships, database design, data warehousing, dimensional modeling, and ER diagramming.

• SQL scripting, PL/SQL, T-SQL, stored procedures, data definition language, SQL Server, Oracle, Python, SSIS, SSRS, Microsoft Access, Microsoft Excel, VBA Web-based applications using Microsoft .Net technologies, including C#, ASP.NET, MVC.Net, HTML, CSS, and JavaScript. API integration concepts include REST, JSON, XML, authentication, secure data exchange, and troubleshooting integration. Data quality concepts, metadata management, business rules, data governance principles, and source system validation. Application development and support tools including Visual Studio, Git, TFS, GitHub, and related work tracking systems.

Translate business and analytic requirements into maintainable technical solutions. Build, test, automate, troubleshoot, and document ETL processes, reports, subscriptions, database jobs, and application logic. Optimize queries and database processes for performance, scalability, reliability, and source-to-report accuracy. Write clear technical documentation for workflows, code changes, report logic, integrations, and support processes. Communicate effectively with technical staff, analysts, supervisors, external partners, and non-technical users.

Manage competing assignments and move between development, reporting, troubleshooting, documentation, and customer support work. Meet deadlines in a time-sensitive public safety environment. Understand and carry out oral and written directions while following established standards and procedures. Organize and maintain electronic files, documentation, reports, and process records accurately. Maintain confidentiality, data security, and appropriate professional boundaries.

Minimum Qualifications

High School Graduate or Equivalent and seven (7) years of related work experience OR 2 Year College Degree and five (5) years of related work experience OR Bachelor's Level Degree and three (3) year of related work experience OR or an equivalent combination of education and relevant experience that provides the necessary knowledge, skills, and abilities to successfully perform the essential job duties

Preferred Qualifications

Experience developing SQL reports and report subscriptions in SSRS. Experience using Python and SSIS for ETL processes. Experience with C#, ASP.Net, MVC.Net, .NET application support, HTML, CSS, JavaScript, Git, TFS, or GitHub. Experience working with public safety data, vendor databases, external partner integrations, or limited-documentation data sources. Knowledge of AWS or other cloud technologies applicable to data integration or application modernization. Bachelor’s degree from an accredited college or university in Information Technology, Computer Science, or a related field Three (3) to five (5) years of experience in data ETL processes, report and dashboard development, with business analysis and process improvement Any equivalent combination of training, education, and experience that provides the required skills, knowledge, and abilities

CONDITIONS OF EMPLOYMENT

The City’s Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes, but is not limited to: reference checks, social security verification, education verification, criminal conviction record check, and, if applicable, a credit history check, sex offender registry and motor vehicle records check. Background checks must be in compliance with all federal and state statutes, such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidate’s written authorization before obtaining a criminal background report, motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports. Final candidates must pass a pre-employment drug‑screening test and physical examination. During the selection process, candidates may be asked to take a skills test, and/or participate in other assessments.

The City of Charlotte is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, religion, color, sex, national origin, marital status, age, disability, sexual orientation, political affiliation or on the basis of actual or perceived gender as expressed through dress, appearance, and behavior. Our culture is to serve the community honorably.

BENEFITS

The City of Charlotte provides a comprehensive benefits package to eligible employees. Click here to learn more about the City of Charlotte’s benefits. The City of Charlotte is a drug and alcohol-free workplace.

Our culture is to serve the community honorably. When you join the City of Charlotte, you become part of Team Charlotte — a dedicated group of professionals working together to make a meaningful impact on our community and its future. The City of Charlotte has more than 8,000 employees working across 19 departments to serve close to 1 million residents. From public safety and clean water to transportation, housing and an international airport, our teams deliver essential services to keep Charlotte connected, safe and empowered with opportunity for all. As public servants, we are guided by a clear mission: to be committed to exceptional service every day. No matter the department or role, every team member plays a part in helping our city grow, thrive and meet the needs of those who rely on us. We are a values-driven organization, working collaboratively, acting with integrity and delivering reliable results. We embrace a forward-thinking mindset, encouraging curiosity, innovation and continuous improvement. The City of Charlotte is committed to making our services and programs accessible to all. Upon request, auxiliary aids, written materials in alternate formats, language access, and other reasonable accommodations or modifications will be provided. To make a request, please fill out the Innovation & Technology ADA request form or call 704.336.4120. Looking for an internship? Explore opportunities on our Internship Career Site and take the first step toward your career with the City of Charlotte.