Senior Data Engineer

Job Description

Job Description

CPI Security, a national leader in residential and commercial security solutions, is seeking a Senior Data Engineer to join us on our data transformational journey. This is an exciting, hands-on opportunity to implement a modern enterprise data platform at a company that has fully embraced the Snowflake platform. This role will work directly with line of business leaders and technical users to design and implement our cloud data warehouse using data vault modeling and dbt. CPI will leverage the data cloud for our data warehouse, machine learning, and AI journeys. The ideal person will have extensive experience building and implementing data warehouses in the cloud with deep expertise in data vault modeling and dbt. This is an on-site position at our HQ in Charlotte, NC.

What You'll Do :

Data Vault Implementation : Design and implement data vault 2.0 modeling patterns to build a scalable, audit-friendly enterprise data platform that supports business agility and data governance.

Modern Data Engineering : Build and maintain automated data pipelines using dbt (Cloud / Core), Python, and Snowflake to transform raw data into business-ready datasets with comprehensive data quality testing.

Cloud Data Platform Development : Architect and implement a enterprise data platform on Snowflake, including automated deployment pipelines, data quality frameworks, and monitoring solutions.

Data Mart & Dimensional Modeling : Design and build data marts using dimensional modeling techniques (Kimball methodology) to support business intelligence and analytics requirements.

ETL / ELT Pipeline Development : Design and implement robust data transformation models using dbt, SQL, and Python to build scalable ingestion and processing pipelines.

Data Quality & Testing : Implement comprehensive data quality testing frameworks using dbt tests, custom Python validations, and automated monitoring to ensure data accuracy and reliability.

External Data Integration : Integrate and operationalize data from external systems such as CRM, ERP, and third-party platforms via secure cloud data sharing, CDC, and APIs.

DataOps Implementation : Enable reliable, scalable, and automated data workflows by implementing DataOps best practices for continuous integration, testing, deployment, and monitoring across the data pipeline lifecycle.

Cloud Migration Support : Play an integral role in planning, designing, and implementing data migration strategies from legacy systems to our modern cloud platform.

What We're Looking For :

• 6+ years of data engineering experience with cloud data platforms
• 4+ years of experience with Snowflake (required)
• 4+ years of experience with dbt (Cloud and / or Core)
• 4+ years of Python development experience
• 4+ years of AWS experience (AWS Certified Developer preferred)
• 6+ years of experience building data warehouses and data marts
• Deep understanding of data vault 2.0 modeling methodology
• Strong experience with dimensional modeling (Kimball methodology)
• Proven experience with automated deployment and CI / CD pipelines
• Experience implementing data quality testing frameworks

Technical Skills :

Preferred Qualifications :

Soft Skills :

What Sets You Apart :

What's In It For You :