I&T Data Services Analyst

The City of Charlotte is hiring an I&T Data Services Analyst to support the Charlotte-Mecklenburg Police Department’s Crime Analysis and Data Analytics Division. The role develops and maintains data workflows, ETL processes, integrations, databases, reports, and application support processes that provide reliable information for operational decision-making.

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

Preferred

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

SQL Reporting

ETL Processes

Application Support

.NET

Public Safety Data

Vendor Databases

External Partner Integrations

Limited-Documentation Data Sources

AWS

Cloud Technologies

Data Integration

Application Modernization

Data ETL

Dashboard Development

Business Analysis

Process Improvement

Software Application Development

Computer Science

Company

Charlotte Area Transit System

Charlotte, North Carolina, US

http://ridetransit.org/

Founded in 1999

501-1000 employees

Qualifications

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

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

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

or an equivalent combination of education and relevant experience that provides the necessary knowledge, skills, and abilities to successfully perform the essential job duties

Or an equivalent combination of education and relevant experience that provides the necessary knowledge, skills, and abilities to successfully perform the essential job duties

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

Required skills

SQL, PL/SQL, T-SQL, SQL Server, Oracle, Python, SSIS, SSRS, ETL, Relational Database Design, Data Warehousing, C#, ASP.NET, MVC.NET, HTML, CSS, JavaScript, REST API Integration, JSON, XML, Microsoft Access, Microsoft Excel, VBA, Git, TFS, GitHub, AWS

Preferred skills

Experience using Python and SSIS for ETL processes, Software application development using relational databases, Charlotte Area Transit System., Charlotte, North Carolina, US, http://ridetransit.org, Late Stage, Leadership Team, Elizabeth Presutti, Deputy Director, Chief Administrative Officer, Kelly Ridall Goforth, Chief Development Officer, Company data provided by, AI Tools, Customize Your Resume, Maximize your interview chances, Build Cover Letter, Make your application stand out, Analyze How Well You Fit, Understand your strength & weakness

Experience

3+ years