CPI Security Systems, Inc.
Senior Data Engineer Charlotte, North Carolina, United States
CPI Security Systems, Inc., Raleigh, North Carolina, United States
Overview
Charlotte, North Carolina, United States 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.
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
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
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
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
Solution-oriented approach with strong problem-solving abilities
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
What’s In It For You
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
Comprehensive and on-going training when you start, includes leadership development
Engaging and fun company culture that succeeds through diversity
Great medical, dental, vision, 401(k) with company match, short-term & long-term disability and life insurance options
Company paid holidays, floating holiday and PTO
Free monitored security system after 90 days
This position is located in Charlotte, NC and will be required to be onsite at our Corporate HQ Mon-Fri.
#J-18808-Ljbffr
Charlotte, North Carolina, United States 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.
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
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
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
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
Solution-oriented approach with strong problem-solving abilities
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
What’s In It For You
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
Comprehensive and on-going training when you start, includes leadership development
Engaging and fun company culture that succeeds through diversity
Great medical, dental, vision, 401(k) with company match, short-term & long-term disability and life insurance options
Company paid holidays, floating holiday and PTO
Free monitored security system after 90 days
This position is located in Charlotte, NC and will be required to be onsite at our Corporate HQ Mon-Fri.
#J-18808-Ljbffr