Data Engineering Manager

CPI Security; Charlotte (NC); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Professional development and certific …

Certification support

On-site role in Charlotte, NC

Job summary

CPI Security in Charlotte, NC is seeking a Data Engineering Manager to lead a hands‑on data team and drive data platform modernization. You will mentor engineers while delivering scalable pipelines, data models, and analytics‑ready datasets using Snowflake, dbt, Python, SQL, and AWS.

Ideal candidates combine strong coding skills with leadership, able to balance hands‑on work with guiding a growing data function.

Qualifications

• 6+ years of data engineering experience
• 4+ years of Snowflake experience
• 4+ years of dbt experience
• 4+ years of Python development experience
• 4+ years of AWS experience
• Experience building data warehouses, data marts, and production‑grade data pipelines

Responsibilities

• Lead and mentor data engineers through code reviews, technical guidance, 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 stakeholders to understand data needs and deliver reliable, high‑quality solutions.
• Support modernizing CPI’s data platform and migrations from legacy SQL Server/SSIS to Snowflake.
• Design and build data marts using dimensional modeling for reporting, BI, and analytics.
• Implement data quality checks, testing, monitoring, and deployment automation across pipelines.

Skills

Snowflake

dbt

Python

SQL

AWS

Airflow

Data modeling

Data warehousing

Data governance

Tools

SQL Server

SSIS

Job description

Charlotte, North Carolina, United States

CPI Security, a national leader in residential and commercial security solutions, is hiring a Data Engineering Manager to help lead our data transformation. This is a hands‑on leadership role for someone who enjoys building modern data solutions while mentoring and guiding a small team of data engineers. This role is on‑site in Charlotte, NC.

What You’ll Do:

• 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.

What We’re Looking For:

Required Experience

• 6+ years of data engineering experience, including cloud data platforms.
• 4+ years of hands‑on 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.

Technical Skills

• Snowflake, dbt, Python, SQL, AWS.
• SQL Server and SSIS experience preferred, especially in migration environments.
• Data orchestration tools such as Airflow, Prefect, or similar.
• Data modeling, data warehousing, and analytics engineering best practices.
• Data governance, security, RBAC, monitoring, and compliance concepts.
• Agile or Scrum experience preferred.

Preferred Qualifications

• AWS Certified Developer or related AWS certification.
• Snowflake certification.
• Experience with modern BI and analytics platforms.
• Prior experience supporting cloud data platform migrations.

Soft Skills

• Strong communication skills with both technical and business audiences.
• Positive, collaborative, and team‑oriented approach.
• Strong problem‑solving skills and ownership mindset.
• Ability to lead through influence, coaching, and hands‑on technical contribution.
• Comfortable working in a lean, fast‑moving team environment.

Why Join CPI Security

• Help build and modernize an enterprise data platform during an active transformation.
• Lead and mentor a growing data engineering function while staying hands‑on.
• Work with modern cloud data technologies including Snowflake, dbt, Python, and AWS.
• Join a collaborative, high‑impact team in a dynamic and growing company.
• Competitive compensation and benefits package.
• Professional development and certification support.
• On‑site role in Charlotte, NC.