Data Engineer

Description

Our family of brands is comprised of Schoolhouse, the lighting, home furnishings, and lifestyle brand based in Portland, Oregon; Food52, the community-driven cooking and home company, based in Brooklyn, New York; and Dansk, the heritage home brand founded in 1954.  

Schoolhouse

Schoolhouse is a lighting, home furnishings and lifestyle brand dedicated to thoughtful living and purposeful design. From iconic lighting to one-of-a-kind homewares, our mission is to provide a new generation of heirlooms that inspire people to create unique, meaningful spaces in which to live and work.

Food52

Food52 is a next-generation cooking and home company, named one of the World's Most Innovative Companies by Fast Company, with a monthly reach of more than 25 million people. Food52 challenges the models of traditional media and retailers, combining content, commerce, and community around the belief that the kitchen is the heart of the home and that food is the center of a well-lived life. Food52 inspires, informs, and supports its engaged community with recipes, videos, podcasts, events, and a curated selection of well designed, high-quality products.

Dansk

Dansk is a design company founded in 1954 by Ted and Martha Nierenberg to bring the elegant simplicity and natural materials of Scandinavian design to the American market. The mission of Dansk is to preserve its heritage, to revive many of the exceptional designs from its archives, and to collaborate with leading designers around the world to create new products that will someday be passed down from generation to generation.

ABOUT THE ROLE: 

We're seeking an experienced Data Engineer to enhance our data platform and establish robust data engineering practices. You'll work with our existing data stack (DBT and Fivetran) to improve our data warehouse architecture while maintaining high standards for documentation and data quality.

IMPACT YOU’LL MAKE: 

• Improve and optimize our data warehouse design
• Build expertise in our source systems to ensure optimal data pipeline design
• Establish clear documentation and data engineering best practices
• Design data models that serve both analytical and operational use cases efficiently

KEY RESPONSIBILITIES: 

Data Warehouse Architecture:

• Enhance and optimize our data warehouse architecture
• Design scalable data models for current and future needs
• Implement dimensional modeling best practices
• Create efficient storage and partitioning strategies
• Design data models optimized for both analytical queries and operational workloads
• Implement appropriate indexing and materialization strategies

Source System Expertise:

• Build strong technical knowledge of our key systems
• Document data lineage from source to warehouse
• Optimize data extraction patterns for each source
• Understand both analytical and operational access patterns

Data Pipeline Development:

• Design and implement robust DBT transformations
• Configure and optimize Fivetran connectors
• Create reliable testing and validation frameworks
• Implement incremental processing strategies
• Establish monitoring and alerting standards

Documentation & Engineering Practices:

• Maintain comprehensive data dictionary and field-level definitions
• Document system architecture and data flows
• Implement automated documentation processes using DBT
• Establish data quality standards
• Follow and enhance engineering best practices

REQUIRED TECHNICAL SKILLS: 

• 5+ years of data engineering experience
• Expert-level DBT knowledge
• Advanced SQL and data modeling skills
• Strong Python programming skills for data processing and automation
• Experience with large-scale data warehouse architecture
• Track record of clear technical documentation

ADDED DIFFERENTIATORS:

• Experience with e-commerce systems and data models
• Knowledge of dimensional modeling patterns
• Experience with hybrid operational/analytical database design

COMPENSATION

For residents of CT, NJ or NY the compensation for this role is 150k. 

This is an exempt role. 

This role is eligible for a 10% bonus. 

WORKING AT FOOD52

Food52 is committed to providing our team with a competitive benefits package. Some of our benefits include: 

• Health benefits (medical, dental, and vision)
• Unlimited paid time off
• Monthly fitness reimbursement
• Citibike (NYC) or BikeTown (PDX) company-sponsored annual membership
• Generous employee discount across our brand portfolio
• 401K
• FSA / HSA

EEO STATEMENT

Food52 is proud to be an equal opportunity workplace, providing equal employment and advancement opportunities to all team members. We value diversity and recruit, hire, and promote individuals solely based on talent, qualifications, competence, and merit. We evaluate candidates without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other protected characteristics as required by law and as a matter of our company values.