Data Engineer

CPI Security, a national leader in residential and commercial security solutions, is seeking a Data Engineer to join us on our data transformational journey. This is an exciting, hands-on opportunity to contribute to the implementation of a modern enterprise data platform at a company that has fully embraced the Snowflake platform. This role will work with line of business leaders and technical users to help 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 solid experience building and implementing data warehouses in the cloud with experience 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 Collaborate on the design and implementation of 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 Support the implementation of 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 Contribute to the design and building of data marts using dimensional modeling techniques (Kimball methodology) to support business intelligence and analytics requirements.

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

Data Quality & Testing Implement 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 Support 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 Contribute to planning, designing, and implementing data migration strategies from legacy systems to our modern cloud platform

What We're Looking For:

Required Experience:

• 4+ 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
• 3+ years of AWS experience
• 3+ years of experience building data warehouses and data marts
• Exposure to or basic understanding of data vault 2.0 modeling methodology
• Working knowledge of dimensional modeling (Kimball methodology)
• Exposure to automated deployment and CI/CD pipelines
• Experience implementing data quality testing frameworks

Technical Skills:

• Strong SQL skills with MSSQL Server and SSIS
• Solid understanding of data modeling concepts including dimensional and data vault patterns
• Proficient with dbt for data staging, cleaning, transformation, testing, and modeling
• Proficiency in Python programming for data engineering tasks
• Experience working in agile/scrum teams for data engineering and analytics engineering
• Working knowledge of AWS cloud services (S3, Lambda, IAM, CloudFormation, etc.)
• Familiarity with data orchestration tools (Airflow, Prefect, or similar)
• Understanding of modern data engineering practices and agile methodologies
• Awareness 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 (Tableau, Sigma, ThoughtSpot)

Soft Skills:

• Good oral and written communication skills to effectively deliver messages to a range of audiences - from business to technical
• Positive team member mindset with eagerness to learn and grow
• 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 good 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:

• Good understanding of the data engineering lifecycle
• Experience with cloud data platform implementations
• 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 contribute to a modern enterprise data platform implementation
• 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.