Senior Data Engineer

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

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:

Required Experience:

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

• MSSQL Server SQL and SSIS.
• Advanced SQL and data modeling expertise with dimensional modeling and data vault modeling
• Strong dbt skills for data staging, cleaning, transformation, testing, and modeling
• Proficiency in Python programming for data engineering tasks
• Experience with agile / scrum teams for data engineering and analytics engineering.
• AWS cloud services (S3, Lambda, IAM, CloudFormation, etc.)
• Experience with data orchestration tools (Airflow, Prefect, or similar)
• Understanding of modern data engineering practices and agile methodologies
• Knowledge of data governance, security, and compliance requirements
  
  
  

Preferred Qualifications:

• AWS Certified Developer certification
• Snowflake certifications in data engineering and/or architecture
• Experience with data vault automation tools (automate-dv package)
• Knowledge of modern BI and analytics platforms
  
  
  

Soft Skills:

• Excellent oral and written communication skills to effectively deliver messages to a wide range of audiences - from business to technical
• Innovative and positive team member mindset
• Strong teamwork and interpersonal skills, with the ability to deliver results working independently or in a collaborative environment
• Agile development experience preferred
• Solution-oriented approach with strong problem-solving abilities
  
  
  

Education:

• Bachelor's degree in Information Systems, Computer Science, Data Science, or related field of study preferred
• Work experience equivalent will be considered
  
  
  

What Sets You Apart:

• Deep understanding of the complete data engineering lifecycle
• Experience with cloud data platform implementations
• Proven ability to work with cross-functional teams and stakeholders
• Passion for building modern, cloud-first data solutions
• Strong analytical and critical thinking skills
• Commitment to data quality and best practices
  
  
  

Why Join CPI Security:

• Opportunity to build a modern enterprise data platform from the ground up
• Work with cutting-edge cloud technologies and data vault modeling
• Collaborative environment with experienced data professionals
• Competitive compensation and benefits package
• Professional development opportunities and certification support
• On-site position in Charlotte, NC with a dynamic, growing company
  
  
  

CPI Security is an equal opportunity employer committed to diversity and inclusion in the workplace.