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 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.
Applied Skills
- 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.
Work Abilities
- 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
- Software application development using relational databases
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, or behavior.
Our culture is to serve the community honorably.
HOW TO APPLY
Apply online.
Federal law requires employers to provide reasonable accommodations to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job.
You are welcome to visit the City of Charlotte Human Resources Department lobby, where self-service application kiosks are available. They are located in our office at 700 East 4th Street, Suite 200, Charlotte, NC 28202. We are open Monday through Friday, from 9:30 a.m. to 3:30 p.m. (EST), excluding official City holidays.
For questions about your application or the hiring process, please email Careers@ci.charlotte.nc.us.
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.
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.
