dbt Jobs in Charlotte.
All active dbt roles based in Charlotte.
Pick a job to read the details
Tap any role on the left — its description and apply link will open here.
Senior Data Engineer
Share this job
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.
Ready to apply?
Apply to CPI Security
Senior Staff Data Scientist, Borrow
Share this job
Employee Applicant Privacy Notice
Who we are:
Shape a brighter financial future with us.
Together with our members, we’re changing the way people think about and interact with personal finance.
We’re a next-generation financial services company and national bank using innovative, mobile-first technology to help our millions of members reach their goals. The industry is going through an unprecedented transformation, and we’re at the forefront. We’re proud to come to work every day knowing that what we do has a direct impact on people’s lives, with our core values guiding us every step of the way. Join us to invest in yourself, your career, and the financial world.
The role
The Borrow Data Science team is seeking a Senior Staff Data Scientist who will help support growth in our Home Loans business by improving SoFi’s ability to execute with data. This is an exciting role for someone to leverage their analytical skills to create robust reporting, identify growth opportunities and insights, and build ML models using Snowflake, Airflow, dbt, and Sagemaker.
As a Senior Staff Data Scientist, you will serve as a data leader, balancing urgent requests, and delivering high quality projects to key stakeholders, through a clear and repeatable data informed approach. You will be a technical leader, helping the team build reliable, efficient, and scalable data foundations. You will create a culture of strong technical ownership, documenting your approach and ideas to socialize, resulting in strategies that have a wide impact within the organization. You will perform analytical deep-dives to proactively identify most impactful opportunities, and inform future experimentation design and product roadmaps.
In this role, you'll use your expertise in data analysis, statistical modeling, and machine learning to uncover insights that will directly influence product strategy and revenue growth. This role demands a strong technical foundation (SQL, Python/R, Tableau, Statistics), a deep understanding of business metrics, A/B testing, causal inference analysis, and exceptional collaboration skills.
Additionally, you are expected to work cross-functionally, including: engineering, product managers, lifecycle marketing, data science, design, operations, finance, risk, legal, compliance, and executive teams to set business objectives, define product strategy, prioritize features, and execute on them.
What you’ll do:
-
Identify high impact business opportunities to help members achieve their financial goals
-
Mentor and guide data scientists in the team by promoting best practices, strong technical decisions, coding standards, and thorough documentation.
-
Develop and apply machine learning models to solve business problems
-
Evaluate and interpret the results of data analysis
-
Build strong relationships with stakeholders and present insights on a regular cadence communicating findings to both technical and non-technical stakeholders.
-
Design and implement data collection. Build data pipelines to deploy production level datasets.
-
Collaborate with cross-functional teams and business leaders to understand needs and offer data-driven solutions
-
Act as a technical leader by mentoring and supporting the growth of less experienced team members.
What you’ll need:
-
Masters’ or above in quantitative areas: Statistics, Applied Mathematics, Economics, Computer Science, Engineering, or related field
-
10+ years of relevant experience leveraging data-driven analysis to influence key decisions, preferably in a Tech or Finance company
-
Proven track record of being able to work independently, and proactively engaging with business stakeholders with minimal direction and drive measurable business impact.
-
Experience with using Airflow and DBT to build Data Pipelines in Snowflake
-
Strong programming skills in SQL and Python
-
Experience with building data visualizations with Tableau, Looker or other BI tools
-
Knowledge of varied ML algorithms, applicability to different business problems, and experience in deploying ML models at scale in production with monitoring metrics.
-
Ability to work in a dynamic, cross-functional environment, with a strong attention to detail;
-
Effective communication and presentation skills and ability to explain complex analyses in simple terms to business leaders;
-
Strong relationship building and collaborative skills;
-
Exceptional problem-solving
SoFi provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion (including religious dress and grooming practices), sex (including pregnancy, childbirth and related medical conditions, breastfeeding, and conditions related to breastfeeding), gender, gender identity, gender expression, national origin, ancestry, age (40 or over), physical or medical disability, medical condition, marital status, registered domestic partner status, sexual orientation, genetic information, military and/or veteran status, or any other basis prohibited by applicable state or federal law.
The Company hires the best qualified candidate for the job, without regard to protected characteristics.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
New York applicants: Notice of Employee Rights
SoFi is committed to an inclusive culture. As part of this commitment, SoFi offers reasonable accommodations to candidates with physical or mental disabilities. If you need accommodations to participate in the job application or interview process, please let your recruiter know or email accommodations@sofi.com.
Due to insurance coverage issues, we are unable to accommodate remote work from Hawaii or Alaska at this time.
Ready to apply?
Apply to SoFi
Mental Health Therapist, 1099 - North Carolina, Charlotte Metro Area
Share this job
About the Company:
Octave is a modern behavioral health practice creating a new standard for care delivery that’s both high-quality and accessible. With in-person and virtual clinics in multiple states, the company offers evidence-based individual, couples, and family therapy, while pioneering relationships with payers to make care more affordable through insurance. By raising the bar on how care is delivered and how providers are supported, we are building a sustainable system that values equity, affordability, and effectiveness.
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.
Application Instructions:
Please complete the following application. Please note that the U.S. Equal Opportunity Employment Information questions below are used for the purposes of EEOC reporting and are optional to complete. Octave is unable to change these questions and we acknowledge that many of the U.S. Equal Opportunity Employment Information questions are not inclusive or affirming of all aspects of cultural identity. Octave is committed to an inclusive workplace environment, and this information will not inform how we approach hiring or employment.
Ready to apply?
Apply to Octave