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.
Data Architecture & DesignDefine 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.
Architecture GovernanceEstablish 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.
Technical Mentorship & CollaborationProvide 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.
Data Vault ImplementationDesign 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 EngineeringBuild 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 DevelopmentArchitect 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 ModelingDesign and build data marts using dimensional modeling techniques (Kimball methodology) to support business intelligence and analytics requirements.
ETL/ELT Pipeline DevelopmentDesign and implement robust data transformation models using dbt, SQL, and Python to build scalable ingestion and processing pipelines.
Data Quality & TestingImplement comprehensive data quality testing frameworks using dbt tests, custom Python validations, and automated monitoring to ensure data accuracy and reliability.
External Data IntegrationIntegrate and operationalize data from external systems such as CRM, ERP, and third-party platforms via secure cloud data sharing, CDC, and APIs.
DataOps ImplementationEnable reliable, scalable, and automated data workflows by implementing DataOps best practices for continuous integration, testing, deployment, and monitoring across the data pipeline lifecycle. Establish and maintain Snowflake security governance through role-based access control (RBAC), including the design and management of role hierarchies, privilege grants, and object-level permissions to enforce least-privilege principles across all data assets. Define and enforce data access policies for users, service accounts, and downstream consumers by leveraging Snowflake's virtual warehouses, resource monitors, row-level security, and dynamic data masking to ensure compliant and auditable data access at scale.Cloud Migration SupportPlay 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
Required Experience6+ years of data engineering experience with cloud data platforms4+ years of experience with Snowflake (required)4+ years of experience with dbt (Cloud and/or Core)4+ years of Python development experience4+ years of AWS experience (AWS Certified Developer preferred)6+ years of experience building data warehouses and data martsExperience using Data Vault 2.0 modeling methodologyStrong experience with dimensional modeling (Kimball methodology)Proven experience with automated deployment and CI/CD pipelinesExperience implementing data quality testing frameworksExperience designing data architectures and creating technical documentation (data models, architecture diagrams, design patterns, ADRs)Proven ability to balance architectural thinking with hands-on implementationExperience mentoring and guiding junior/mid-level engineers through technical collaborationTechnical Skills
MSSQL Server SQL and SSISAdvanced SQL and data modeling expertise with dimensional modeling and data vault modelingStrong dbt skills for data staging, cleaning, transformation, testing, and modelingProficiency in Python programming for data engineering tasksExperience with agile/scrum teams for data engineering and analytics engineeringAWS cloud services (S3, Lambda, IAM, CloudFormation, etc.)Experience with data orchestration tools (Airflow, Prefect, or similar)Understanding of modern data engineering practices and agile methodologiesKnowledge of data governance, security, and compliance requirementsPreferred Qualifications
AWS Certified Developer certificationSnowflake certifications in data engineering and/or architectureExperience with data vault automation tools (automate-dv package)Knowledge of modern BI and analytics platformsSoft Skills
Excellent oral and written communication skills to effectively deliver messages to a wide range of audiences, from business to technicalInnovative and positive team member mindsetStrong teamwork and interpersonal skills, with the ability to deliver results working independently or in a collaborative environmentAgile development experience preferredSolution-oriented approach with strong problem-solving abilitiesEducation
Bachelor's degree in Information Systems, Computer Science, Data Science, or related field of study preferredWork experience equivalent will be consideredWhat Sets You Apart
Deep understanding of the complete data engineering lifecycleArchitectural design experience combined with strong implementation skillsExperience with cloud data platform implementations and migrationsProven ability to work with cross-functional teams and stakeholdersPassion for building modern, cloud-first data solutionsStrong analytical and critical thinking skillsCommitment to data quality and best practicesWhy Join CPI Security
Opportunity to architect and build a modern enterprise data platform during an active transformationWork with cutting-edge cloud technologies and data vault modelingLead technical design while remaining hands-on with implementationCollaborative environment with experienced data professionals on a lean, high-impact teamCompetitive compensation and benefits packageProfessional development opportunities and certification supportOn-site position in Charlotte, NC with a dynamic, growing companyCPI Security is an equal opportunity employer committed to diversity and inclusion in the workplace.
Read LessCPI Security, a leader in the security and automation solutions industry, is looking for a New Home Construction Sales Representative to join our team in Greensboro, North Carolina! Our New Home Construction will design, present and sell our award-winning security and home automation solutions and will schedule in-home sales consultations through lead generating and prospecting activities using company provided tools. As a Construction Security Advisor, you will lead our mission to make every day safer for our community by working directly with customers to identify and meet their security and automation needs. This is a fantastic opportunity to earn an uncapped, performance-based income while providing valuable service to our customers. This is more than "just a sales job" – it's your chance for a fulfilling and purpose-driven career that provides opportunities for growth, stability, and competitive pay and benefits. We are looking for go-getters who can work independently while exceeding goals. If you're an experienced sales professional and excellent communicator, you enjoy building relationships with customers and solving problems, this opportunity is for you.
What you'll do:
Effectively communicate CPI Security's value, product vision, and capabilities to potential customersCultivate relationships with builders, contractors, and developers to promote our products and services.Self-generate customer connect opportunities, in addition to company leads, to meet or exceed sales targetsDevelop and maintain outstanding working relationship with customers and potential customers to ensure complete satisfactionMaintain a schedule of weekly appointments with accounts in assigned locationMerchandise product sections and build displays to stimulate salesWork closely with Sales Manager and team to ensure goal is achievedWhat We Are Looking For:
High school diploma1-2 years of outside sales experience preferred, but will train the right individualHighly driven and motivated, with a strong work ethic and integrityStrong time-management, organizational and prioritization abilitiesDemonstrates strong communications skills and professional credibility to influence sales leaders and professionalsDetail-oriented, creative, and decisiveExperience working with a CRM system (i.e. Salesforce) is a plusWhat's In It For You:
$80,000-$100,000 annual average earningsBase salary guarantee plus commissions on topCompany fuel card, company equipment provided (i.e. iphone, ipad)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. Read LessCPI Security, a leader in the security and automation solutions industry, is looking for an Outbound Sales Advisor to join our growing team at our incredible corporate headquarters in Charlotte, NC! As a Sales Advisor, you will play a crucial role in driving sales growth and maximizing value from strategic partnerships with home builders. Your main responsibilities will involve servicing new home buyers of our partner builders, selling services including video, home automation, security and additional value-added services. There is no cold calling or prospecting required in this role as all leads will be provided by CPI. The Business Development Representative role will reside in our Corporate Headquarters in Charlotte and will be working assigned new construction leads including new homeowners and communities.
What You'll Do:
Convert company-assigned partnership new construction leads/opportunities into revenue-generating security customers for CPI through following actions: Initiate outbound sales calls, emails, and SMS to potential prospects from a list of leads or opportunities to create solutions, sell services, devices and systems and schedule install Conduct initial and follow-up phone calls to build relationships with key decision makers and nurture the sales process Manage assigned prospect account lists and utilize Salesforce sales pipeline to accurately track prospects through the sales funnel to installation Overcome customer objections effectively through applying advanced solution selling skills Update and maintain prospect database and activity tracking on a daily basis Meet sales quotas and revenue targets, while providing superior customer experience Maintain contact with existing clients to make sure they are satisfied and request referrals Ensure compliance with regulations and best practices for contact strategiesWhat We're Looking For:
Organized, resourceful, and self-motivated with a good work ethic Effective communicator (both written and oral) and strong listening skills Strong sales funnel management skills Be a self-starter who is driven to exceed targets Prior experience in sales or an account management required Experience handling large volume of outbound calls/contacts or experience in contact center-type environment Experience and proficiency with CRMs, telephony needs, and help desk software (Salesforce etc) Experience and proficiency with Microsoft Office (MS Word and MS Excel) required. Must be able to pass required licensing as mandated by various state Alarm BoardsWhat's In It For You:
$70,000 to $100,000 Annual CompensationBase hourly rate with tiered commission structure, performance based, training and quarterly bonusHigher shift pay for working nights and weekends Great medical, dental, vision, 401(k) with company matching, short- & long-term disability and life insurance options. Company paid holidays, floating holiday, and PTO Free monitored security system after 90 days. Engaging and fun company culture that's made up of a diverse group of people Talk about perks! An on-site café, coffee/smoothie bar, walking trail, basketball court, and state-of-the-art fitness facility with a dedicated Fitness Director Read LessCPI Security, a leader in the security and automation solutions industry, is looking for a New Home Construction Sales Representative to join our team in Myrtle Beach, South Carolina! Our New Home Construction will design, present and sell our award-winning security and home automation solutions and will schedule in-home sales consultations through lead generating and prospecting activities using company provided tools. As a Construction Security Advisor, you will lead our mission to make every day safer for our community by working directly with customers to identify and meet their security and automation needs. This is a fantastic opportunity to earn an uncapped, performance-based income while providing valuable service to our customers. This is more than "just a sales job" – it's your chance for a fulfilling and purpose-driven career that provides opportunities for growth, stability, and competitive pay and benefits. We are looking for go-getters who can work independently while exceeding goals. If you're an experienced sales professional and excellent communicator, you enjoy building relationships with customers and solving problems, this opportunity is for you.
What you'll do:
Effectively communicate CPI Security's value, product vision, and capabilities to potential customersCultivate relationships with builders, contractors, and developers to promote our products and services.Self-generate customer connect opportunities, in addition to company leads, to meet or exceed sales targetsDevelop and maintain outstanding working relationship with customers and potential customers to ensure complete satisfactionMaintain a schedule of weekly appointments with accounts in assigned locationMerchandise product sections and build displays to stimulate salesWork closely with Sales Manager and team to ensure goal is achievedWhat's In It For You:
$60,000 to $90,000 annual average earningsBase salary guarantee plus commissions on top.Company fuel card, company equipment provided (i.e. iphone, ipad)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.What We Are Looking For:
High school diploma1-2 years of outside sales experience preferred, but will train the right individualHighly driven and motivated, with a strong work ethic and integrityStrong time-management, organizational and prioritization abilitiesDemonstrates strong communications skills and professional credibility to influence sales leaders and professionalsDetail-oriented, creative, and decisiveExperience working with a CRM system (i.e. Salesforce) is a plus Read LessCPI Security, a leader in the security and automation solutions industry, is looking for a New Home Construction Sales Representative to join our team in Columbia, South Carolina! Our New Home Construction will design, present and sell our award-winning security and home automation solutions and will schedule in-home sales consultations through lead generating and prospecting activities using company provided tools. As a Construction Security Advisor, you will lead our mission to make every day safer for our community by working directly with customers to identify and meet their security and automation needs. This is a fantastic opportunity to earn an uncapped, performance-based income while providing valuable service to our customers. This is more than "just a sales job" – it's your chance for a fulfilling and purpose-driven career that provides opportunities for growth, stability, and competitive pay and benefits. We are looking for go-getters who can work independently while exceeding goals. If you're an experienced sales professional and excellent communicator, you enjoy building relationships with customers and solving problems, this opportunity is for you.
What you'll do:
Effectively communicate CPI Security's value, product vision, and capabilities to potential customersCultivate relationships with builders, contractors, and developers to promote our products and services.Self-generate customer connect opportunities, in addition to company leads, to meet or exceed sales targetsDevelop and maintain outstanding working relationship with customers and potential customers to ensure complete satisfactionMaintain a schedule of weekly appointments with accounts in assigned locationMerchandise product sections and build displays to stimulate salesWork closely with Sales Manager and team to ensure goal is achievedWhat We Are Looking For:
High school diploma1-2 years of outside sales experience preferred, but will train the right individualHighly driven and motivated, with a strong work ethic and integrityStrong time-management, organizational and prioritization abilitiesDemonstrates strong communications skills and professional credibility to influence sales leaders and professionalsDetail-oriented, creative, and decisiveExperience working with a CRM system (i.e. Salesforce) is a plusWhat's In It For You:
$60,000 to $90,000 annual average earningsBase salary guarantee plus + uncapped commissions AND tiered bonuses Company fuel card, company equipment provided (i.e. iphone, ipad)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. Read Less