Senior Data Engineer

Responsibilities

• Data Architecture & Design
• Architecture Governance
• Technical Mentorship & Collaboration
• 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 an enterprise data platform on Snowflake, including automated deployment pipelines, data quality frameworks, and monitoring solutions. While we are modernizing to a cloud data platform, on-premises work is still needed using SSIS and MSSQL Server during the migration phase.
• 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
• Cloud Migration Support
• Play an integral role in planning, designing, and implementing data migration strategies from legacy on-premises SQL Server sys

Additional Information

Senior Data Engineer - Data Architecture & Platform CPI Security, a national leader in residential and commercial security solutions, is seeking a Senior Data Engineer transitioning into Data Architecture to join us on our data transformational journey. This unique role combines hands-on data engineering (70%) with architectural design and governance (30%), ideal for a technical expert ready to shape our enterprise data strategy while remaining deeply involved in implementation. You'll work directly with line of business leaders and technical users to architect and build our cloud data warehouse using data vault 2.0 modeling and dbt. This is a technical, hands-on role, not a pure architecture position, where you'll mentor junior engineers on a lean team while personally implementing the solutions you design. This is an on-site position at our HQ in Charlotte, NC.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at cpisecurity? Share your experience