ETL & Analytics Engineer - Data Services (Public Sector)

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

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