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 & Design

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.

Architecture Governance

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.

Technical Mentorship & Collaboration

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.

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 during the migration phase.

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

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

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
• Experience using 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
• Experience designing data architectures and creating technical documentation (data models, architecture diagrams, design patterns, ADRs)
• Proven ability to balance architectural thinking with hands-on implementation
• Experience mentoring and guiding junior/mid-level engineers through technical collaboration

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
• Architectural design experience combined with strong implementation skills
• Experience with cloud data platform implementations and migrations
• 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 architect and build a modern enterprise data platform during an active transformation
• Work with cutting-edge cloud technologies and data vault modeling
• Lead technical design while remaining hands-on with implementation
• Collaborative environment with experienced data professionals on a lean, high-impact team
• 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.

About the Company:

About the Role:

Octave is hiring Licensed Clinicians to work within an organizational structure to provide high-quality behavioral health care to our clients. Octave Clinicians will join a diverse clinical team in providing therapy in a collaborative, client-centered, evolving environment. Octave Clinicians demonstrate strong clinical service thinking, informed by evidence-informed therapies. It is our effort to drive quality access and customize mental health treatment plans and service delivery for our clients. You will treat adult clients with stress, depression, anxiety, or other mental health concerns via video, using short-term, evidence-based therapies. Candidates must be licensed in North Carolina at the master's or doctoral level, well-versed in evidence-based therapies, like CBT or DBT, and an expert in the delivery of culturally responsive care.

We are seeking out Licensed Clinicians who are willing to work both in-person and remotely, but an office space is required to start. As a Clinician with Octave, you will be able to build out a caseload that gives your clients the option to see you virtually or in-person. It is required that you already have a commercial clinical space that you can operate from to see clients in person through Octave. At this time, we are not providing an office space within the state of North Carolina. You can see clients in person from your home office or commercial office setting.

You are a good fit if you are:

• Passionate about expanding access to high-quality mental health care.
• Skilled at providing short-term, evidence-based therapies to a diverse range of adult clients.
• Adept at building and maintaining a strong therapeutic alliance.
• Willing to deliver feedback-informed care using standardized measures.
• Expert at providing culturally responsive and culturally competent care.
• Open to learning from your colleagues and clients.
• Someone who thrives in a culture of thoughtful feedback and transparency.

Qualifications:

• LMFT, LMHC, LCSW, PsyD
• Current License in North Carolina.
• Master’s Degree or higher from an accredited school of Social Work, Psychology, Counseling or Marriage, or Family and Child Counseling.
• Must be licensed and in good standing with your governing licensing board.
• Preferred 1 year of related post-license clinical experience required. 
• At least 2 years of experience preferred in one or more of the following areas:
  • CBT for depression or anxiety
  • DBT for emotion dysregulation
  • Unified Protocol for emotional distress
  • CPT or PE for trauma
• Must have your own office space and are willing to provide in-person services in the Charlotte area.

Octave's Company Values: 

The below values drive our day-to-day operations.

• We’re human beings first. We operate with empathy and kindness – with our clients, with our collaborators, and with ourselves.
• People deserve better than status quo. We’re willing to tackle the intractable problems, no matter how big, because someone should. We ask big questions, we craft big solutions, and we challenge ourselves and others to make it happen.
• No bystanders. No stars. No tourists. Each person has been selected to be here, and with that comes a responsibility to bring your expertise, share your ideas, and help make this company better.
• Partnership paves the path ahead. We don’t operate in a silo, internally or externally. To transform the system, we believe in working with others to create something bigger, better, and stronger.
• Quality is crucial at scale. Quality is core to our business, and we refuse to sacrifice it as we grow.
• Progress is a process. In the pursuit of progress, we iterate, reflect, learn, adjust – and always leave things better than we found them.
• There are people behind every data point. We recognize that numbers tell only one part of the story, and we also do the work to understand impacts at the individual level.

Physical Requirements: 

• Prolonged periods sitting at a desk and working on a computer. 
• Must be able to frequently communicate with others through virtual meeting applications such as Zoom and Google Meet. 
• Must be able to observe and communicate information on laptop. 
• Move up to 10 pounds on occasion. 
• Must be eligible to work in the United States without sponsorship now or in the future.
• Octave’s policy requires that all clinical sessions be conducted while you are physically located in the United States.

System Requirements: 

• Computers that are Mac OS (Ventura or later) and Windows OS (10/11)
• Computers kept up with the most recent security updates
• An unmanaged device (a device not provided to you by another company/organization)

Compensation: 

Starting pay for qualified applicants will depend on a combination of job-related factors, which may include education, training, experience, location, business needs, or market demands. The expected salary range for this role is set forth below and this range may be modified in the future.

The hourly compensation range for this role is listed below dependent on licensure:

In-Person Rates: 
$63-$118/hour for master's level license.
$73-$123/hour for doctoral level license.

Virtual Rates: 
$60-$115/hour for master's level license.
$70-$120/hour for doctoral level license.