Data Engineer

Responsibilities

• Own the storage architecture in Amazon Redshift, including distribution and sort key design, RA3/managed storage tuning, and tiering cold data to S3/Spectrum to keep the warehouse fast and cost-efficient as data volume grows
• Design and maintain dbt models for high-volume event data at multi-billion row scale while balancing cost and efficiency
• Build resilient ingestion pipelines from third-party platforms with idempotent loads so bad or partial loads never silently reach production tables
• Diagnose and resolve pipeline performance bottlenecks and fine tuning workloads between raw to BI layer to prevent data outages
• Set up monitoring and alerting across the pipeline to catch data anomalies before they compound
• Work closely with data analysts to align warehouse design with stakeholder needs and LookML modeling, ensuring a robust, scalable foundation from raw tables through to the semantic layer
• Collaborate with other engineers and product managers in solving interesting and challenging problems across our systems
• Advance modern, agile software development practices and help build a culture of great engineering and organizational practices
• Learn from the team and on your own what you might not know about data infrastructure, business operations, and open source tooling to make you a stronger asset to the team

Preferred

• Preference for familiarity with Redshift, S3, dbt, Airflow, Looker, Trino, Fivetran
• Salesforce, GA4, Shopify experience a plus

Benefits

• Hybrid role, requiring that you work 4 days per week from our Richmond, VA office.
• Comprehensive benefits package
• Wellbeing resources
• Medical, vision, and dental insurance
• Paid Time Off
• Employee Discount to use on whatever you like (with a few exceptions)
• Product discounts for friends and family
• After one year of service, tuition reimbursement
• Glassdoor
• 3.1
• Founded in 1950, Carpenter Co. is the world’s largest vertically integrated manufacturer of polyurethane foams.
• Richmond, Virginia, USA
• https://carpenter.fr
• Late Stage
• Leadership Team
• Brad Beauchamp
• President & CEO
• Jackie Carpenter
• Chief Executive Officer
• Recent News
• Furniture News
• Furniture Component Expo extends Telford stay
• 2025-09-18
• GlobeNewswire News Room
• Lynch Carpenter Investigates Claims in Integrated Oncology Network Data Breach
• 2025-07-11
• EIN Presswire
• Leadership Tennessee Names Corbin I. Carpenter, Esq. to Class XII
• 2025-07-10
• Company data provided by

Qualifications

• The following technical capabilities developed through at least 3 years of relevant work experience:
• Expert in Python and SQL
• Experience with Airflow, containerization and orchestration
• Experience with a cloud data warehouse like Redshift or Snowflake
• Knowledge of modern BI tools and dbt
• A proven engineering background with experience developing data workflows and a good operational understanding of data operations, including processing, storage, quality and management
• Experience working with a diverse set of stakeholders and helping them understand the trade-offs to different product and technical decisions
• Appreciation for the business context that drives the need for data solutions and love working on projects to support those efforts
• Experience delivering timely, high quality data products and models
• Candidates must be authorized to work in the United States without the need for current or future employer-sponsored visa support
• Preference for familiarity with Redshift, S3, dbt, Airflow, Looker, Trino, Fivetran
• Salesforce, GA4, Shopify experience a plus

Required skills

• Airflow, Amazon Redshift, Amazon S3, Containerization, Fivetran, Looker, Orchestration, Python, SQL, Snowflake, Trino, dbt

Preferred skills

• Salesforce, GA4, Shopify experience a plus

Experience

• 3+ years