Data Engineering Manager — Lead Snowflake Platform (Charlotte)

CPI Security Systems, Inc.; Charlotte (NC); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Competitive compensation

Professional development and certificat

Job summary

CPI Security, a national leader in residential and commercial security solutions, is seeking a Data Engineering Manager to lead our data transformation from a hands‑on position in Charlotte, NC. You will mentor a small team of data engineers, build scalable data pipelines using Snowflake, dbt, Python, SQL, and AWS, and collaborate with stakeholders to deliver reliable analytics‑ready datasets.

This role combines leadership with active coding, data modeling, and deployment automation to modernize

Qualifications

• 6+ years of data engineering experience, including cloud data platforms.
• 4+ years of Snowflake experience.
• 4+ years of dbt experience, Cloud or Core.
• 4+ years of Python development experience.
• 4+ years of AWS experience.
• Experience building data warehouses, data marts, and production‑grade data pipelines.
• Strong SQL and dimensional modeling experience.
• Experience with CI/CD, automated deployments, and data quality testing.
• Experience mentoring junior or mid‑level data engineers.
• Ability to balance hands‑on development with technical leadership.

Responsibilities

• Lead and mentor data engineers through code reviews, technical guidance, pair programming, and best‑practice sharing.
• Build and maintain scalable data pipelines, data models, and analytics‑ready datasets using Snowflake, dbt, Python, SQL, and AWS.
• Partner with business and technical stakeholders to understand data needs and deliver reliable, high‑quality solutions.
• Support the modernization of CPI’s data platform, including migration from legacy on‑premises SQL Server and SSIS environments to Snowflake.
• Design and build data marts using dimensional modeling to support reporting, BI, and analytics needs.
• Implement data quality checks, testing, monitoring, and deployment automation across the data pipeline lifecycle.
• Help define practical engineering standards for data modeling, development, documentation, security, and performance.
• Support DataOps practices including CI/CD, testing, monitoring, access controls, and secure data sharing.

Skills

Mentoring

Data pipeline development

Python

SQL

AWS

Cloud data platforms

Data quality testing

CI/CD

Tools

Snowflake

dbt

Airflow

Prefect

SSIS

SQL Server

Job description

CPI Security, a national leader in residential and commercial security solutions, is seeking a Data Engineering Manager to lead our data transformation from a hands‑on position in Charlotte, NC. You will mentor a small team of data engineers, build scalable data pipelines using Snowflake, dbt, Python, SQL, and AWS, and collaborate with stakeholders to deliver reliable analytics‑ready datasets.

This role combines leadership with active coding, data modeling, and deployment automation to modernize