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.
What You'll Do
This role balances architectural design with hands-on implementation. You'll spend approximately 70% of your time coding, building pipelines, and implementing solutions, while dedicating 30% to architectural design, standards definition, and technical guidance. On our lean team, everyone contributes technically, this isn't about drawing boxes, it's about designing it AND building it. You must be comfortable in the IDE daily, working alongside engineers and providing mentorship through code reviews, pair programming, and technical guidance.
Define and document reference architectures, design patterns, and standards for the enterprise data platform. Create technical design documentation, data flow diagrams, and architectural decision records (ADRs) while remaining actively involved in hands-on implementation. Establish data modeling standards, naming conventions, and best practices across the platform.
Establish and maintain data modeling standards, design patterns, and architectural guidelines. Review and approve technical designs to ensure alignment with architectural principles and enterprise standards. Collaborate with stakeholders to define data governance policies and ensure compliance with security requirements.
Provide architectural guidance and hands-on mentorship to engineers through code reviews, pair programming, and technical design sessions. Share expertise in data vault modeling, dbt development, and cloud data engineering best practices. Foster a culture of technical excellence and continuous learning within the team. Work collaboratively on our small team where everyone contributes to solving complex technical challenges.
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.
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.
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.
Design and build data marts using dimensional modeling techniques (Kimball methodology) to support business intelligence and analytics requirements.
Design and implement robust data transformation models using dbt, SQL, and Python to build scalable ingestion and processing pipelines.
Implement comprehensive data quality testing frameworks using dbt tests, custom Python validations, and automated monitoring to ensure data accuracy and reliability.
Integrate and operationalize data from external systems such as CRM, ERP, and third-party platforms via secure cloud data sharing, CDC, and APIs.
Play an integral role in planning, designing, and implementing data migration strategies from legacy on-premises SQL Server systems to our modern Snowflake cloud platform.
What We're Looking For
Technical Skills
Preferred Qualifications
Soft Skills
Education
What Sets You Apart
Why Join CPI Security
CPI Security is an equal opportunity employer committed to diversity and inclusion in the workplace.
For more than 30 years, CPI Security has been a leader in customized security and home automation solutions. We are one of the only providers to design, install, monitor and service our own security systems.
What's it like to work at CPI?
CPI realizes that its success depends on employees who are excited about coming to work every day. We offer our employees a positive and rewarding work environment with competitive pay and benefits, paid training, and educational assistance. Our employees are driven, independent, passionate, and team-oriented. Everyone at CPI comes into work knowing they will make an impact, whether that means with their team or customers. There’s a reason why we were voted one of the top places to work in the Carolinas!
CPI’s culture is built around our strong desire to give back. Because we live and work in the regions serviced by CPI Security, we actively participate in our communities. Several times a year, we ask employees to participate in our spirit of giving back and always have a great time doing so. We even offer volunteer time off for charitable time outside of work.
Ready to join the fastest growing security company in the Southeast? Check out our openings in Sales, Operations, Customer Service, and Corporate roles today. Visit www.cpisecurity.com/careers to learn more!
