CPI Security
Senior Data Engineer
Charlotte, North Carolina, United States · Senior
Sponsorship not specifiedDetected 33 days ago
PythonCode ReviewSQLSnowflakeAWSCI/CDAirflowdbtData EngineeringData ScienceAgileCRMERPCommunicationCollaborationProblem SolvingCritical ThinkingMentoring
About the role
- This is an on-site position at our HQ in Charlotte, NC.
- 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.
Responsibilities
- 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 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.
- 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.
- Provide architectural guidance and hands-on mentorship to engineers through code reviews, pair programming, and technical design sessions.
Requirements
- 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
- 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
- Proven ability to balance architectural thinking with hands-on implementation
Nice to have
- 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
- Innovative and positive team member mindset
- Agile development experience preferred
- Solution-oriented approach with strong problem-solving abilities
- Bachelor's degree in Information Systems, Computer Science, Data Science, or related field of study preferred
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
- Senior Data Engineer - Data Architecture & Platform
Compensation
- Competitive compensation and benefits package
Company info
- On-site position in Charlotte, NC with a dynamic, growing company
- While we are modernizing to a cloud data platform, on-premises work is still needed using SSIS and MSSQL Server during the migration phase.
Apply directly at CPI Security →Create a free account for alerts like thisView CPI Security immigration profile
This listing is sourced directly from CPI Security's careers page and normalized into a canonical job model.