Staff Data Engineer

Palmetto; Charlotte (NC); Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

Unlimited PTO

Medical/Dental/Vision coverage

Paid parental leave

Retirement plans

Job summary

Palmetto is seeking a senior data engineer to own the technical design of the data platform powering Palmetto's products and AI agents. You will turn raw data from the customer journey into a single governed, trustworthy view and build secure data access paths.

This is an IC role; you will set technical direction, write foundational code, and partner with core platform and product teams. AI agents are primary consumers; you will enable them daily.

Qualifications

• 8+ years in data engineering, including time at a staff or lead level owning a platform used by multiple teams.
• Deep experience with SQL and Python.
• Strong database fundamentals in modern warehouses (Snowflake, BigQuery).
• Hands-on with dbt or equivalent transformation framework.
• Experience with ETL orchestration (Fivetran, Airflow).
• Infrastructure as code and container orchestration on major cloud platforms.

Responsibilities

• Model and own data products from bronze to gold for analysts, engineers, product teams, partners, and AI tools.
• Shape semantic context, documentation, and interfaces for agents to answer from governed definitions.
• Build governance into code: classification, masking, access policy, and change control.
• Operate ingestion and orchestration as code, with CI/CD, observability, and SLAs.
• Communicate with finance, operations, product and engineering to evolve data requirements.
• Design and maintain secure, low-latency data access paths for products, partners, and agents.
• Review code, mentor teammates, and provide templates and CI checks to ship trusted data.

Skills

SQL

Python

Data modeling

Communication

Leadership

Tools

dbt

Fivetran

Airflow

Snowflake

BigQuery

AWS/Azure/GCP

Job description

Company Description

Palmetto is a consumer energy platform that provides homeowners with a single destination to discover, purchase, finance, install, monitor and manage home energy products and services. By offering one integrated platform across solar, battery storage, HVAC, heat pumps and more, Palmetto helps homeowners make home energy more affordable, reliable and accessible. Today Palmetto serves hundreds of thousands of homeowners, across 30+ states, building the operating infrastructure for the consumer energy transition, one home at a time.

Palmetto is a consumer energy platform that provides homeowners with a single destination to discover, purchase, finance, install, monitor and manage home energy products and services. By offering one integrated platform across solar, battery storage, HVAC, heat pumps and more, Palmetto helps homeowners make home energy more affordable, reliable and accessible. Today Palmetto serves hundreds of thousands of homeowners, across 30+ states, building the operating infrastructure for the consumer energy transition, one home at a time. Our employees are our most valuable resource. We foster a promote-from-within culture that prioritizes talent development, career growth, and purpose-driven work. Palmetto offers a comprehensive benefits package—including unlimited PTO, medical, dental, and vision coverage, paid parental leave, retirement plans, and more—so you can have it all both personally and professionally. Palmetto prioritizes people, planet, and profit—backed by a culture that values collaboration, impact, and balance. Join us in building a brighter, cleaner world.

Location

This position will be remote based in the United States.

Reporting

This position will report to the Senior Manager, Data Engineering.

Summary of Role

You will own the technical design of the data platform that powers Palmetto's products, partners, and AI agents. Our data spans the whole customer journey: sales, lending, installation, interconnection, and years of system production. You will turn it into one governed, trustworthy view of the business, with each metric defined once so every dashboard, notebook, and agent returns the same answer. You will also build the secure, authorized, auditable path that lets people and systems use that data directly.

This is a high-leverage individual-contributor role. You'll set technical direction, write foundational code, and work closely with core platform and product teams. AI agents are first-class consumers of our platform, and we build with them every day.

Strategic & Tactical

• Model the business. Build and own data products that deliver trustworthy data, from bronze to gold, for analysts, engineers, product teams, partners, and AI tools.
• Make data agent-ready. Shape the semantic context, documentation, and interfaces that let agents answer from governed definitions, with answers that trace back to source.
• Build governance in. Treat classification, masking, access policy, and change control as code, and prepare the platform for SOC 2 and related compliance audits.
• Build and run pipelines. Operate ingestion and orchestration as code, with CI/CD, observability, alerting, and SLAs.
• Communicate. Partner with finance, operations, product and engineering to understand how their data requirements are evolving.
• Build the access path. Design and operate the secure, authorized, low-latency interface through which products, partners, and agents consume data.
• Raise the bar. Review code, mentor teammates, and give engineering teams templates and CI checks to ship trusted data.

Qualifications

• 8+ years in data engineering, including time at a Staff or lead level owning a platform used by multiple teams.
• Deep experience in SQL and Python.
• Strong database fundamentals in a modern analytical warehouse (e.g., Snowflake, BigQuery): schema design, query plans, distributed computing.
• Deep experience with dbt or an adjacent transformation framework (e.g., SQLMesh, Dataform).
• Experience with ETL orchestration (e.g., Fivetran, Airflow).
• Infrastructure as code and container orchestration on a major cloud (AWS, GCP, or Azure).
• Demonstrated agentic engineering beyond prompting: you run coding agents in loops checked by specs and tests, and stay curious about new tools.
• Design docs that settled cross-team architecture questions, and clear written and verbal communication with non-technical partners.
• Working knowledge of API design, authentication and authorization (e.g., OAuth/OIDC, RBAC), and PII handling.
• Knowledge of reporting tools such as Looker and Hex is a plus

Employment is contingent upon the successful completion of a background check.

Equal Employment Opportunity

Palmetto embraces diversity and is an Equal Employment Opportunity employer. Employment is decided on the basis of qualifications, merit, and business need. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or any other status protected under federal, state, or local law.

To ensure a fair evaluation, we may use AI to assist in sorting applications, but all final decisions are made by our hiring team and no candidate dispositions are automated. We will keep your information on file for four years from the date of your application. For detailed information about how we handle your data and our use of AI, please review our full privacy policy.

For more about our Privacy Policy, visit: https://palmetto.com/privacy-policy