Data Engineer

Two Chairs is building a new kind of mental health system based on the idea that the status quo isn’t good enough. Industry-best clinician experiences, better client outcomes, groundbreaking innovation, and access to the highest quality care are how we’ll raise the bar for the entire industry. With that, we're excited and honored to have been recognized as a 2024 Great Place to Work, 2024 Fortune Best Workplaces in the Bay Area, and 2023 San Francisco Business Times Bay Area Best Places to Work.

Diversity, equity, and inclusion are the principles guiding how we build our business and teams. We encourage interested candidates from diverse backgrounds to apply even if they don't think they meet every expectation of the role. 

About the role 

As a Data Engineer, you'll play a key role in building scalable, reliable, and innovative data pipelines and data models that support our mission. You'll collaborate with stakeholders from Data Science, Product, Clinical Operations, and beyond to ensure the delivery of high-quality data through analytics engineering and data pipeline development, helping our operators, clinicians, and clients in their day-to-day. 

You'll be responsible for ensuring Two Chairs’ data ecosystem serves quality data to inform decision making and enable great product experiences. 

Core Areas of Responsibility 

• Build and maintain reliable data pipelines, working closely with Data Scientists, Data Engineers, and Backend engineers to ensure proper data movement and alignment
• Implement monitoring, alerting, and data quality checks to ensure data integrity across key pipelines
• Partner with people across the company (Product, Finance, Business Development, Operations, Clinical Care) to understand and solve data needs
• Optimize query performance and manage costs for our BigQuery environment
• Create and maintain API integrations to support data ingestion needs
• Automate common data team tasks through notebooks and APIs (e.g. Looker)
• Build data models, documentation, and tools to help data consumers confidently run queries and create dashboards
• Learn and work within our established data architecture, suggesting improvements as you gain experience

Impact and Success Indicators

Where you'll make an impact in the first 90 days: 

• Gain a solid understanding of our existing data pipelines and tools
• Successfully augment and maintain data pipelines
• Learn our monitoring systems and respond effectively to alerts
• Participate actively in sprint planning, standups, and retrospective meetings
• Complete projects with support from senior team members

Where you'll make an impact in the first year: 

• Own end-to-end pipeline development for moderate complexity data projects
• Build robust monitoring and data quality checks for key data assets
• Create clear documentation parts of the data stack that you maintain
• Develop strong working relationships with other data teammates and data consumers
• Identify and implement optimization opportunities in existing pipelines
• Collaborate with data scientists on new data sets for new products for clients and clinicians

We’re looking for someone with: 

• 2-4 years of hands-on experience with data pipelines and ETL processes
• Experience with cloud platforms (preferably GCP) and data warehouses (preferably BigQuery)
• Working knowledge of Python, SQL, and DBT or similar data modeling frameworks for data manipulation and pipeline development
• Familiarity with data quality monitoring and alerting practices
• Strong problem-solving skills and attention to detail
• Ability to work collaboratively with engineers and non-technical teammates
• Enthusiasm for learning and growing in a fast-paced environment

Compensation & Benefits 

The salary range for this full-time, exempt role is $162,000 to $180,000. The final offer is dependent on qualifications and experience. 

In addition, we offer perks and benefits that support the health and well-being of our teams, including: 

Additional perks and benefits: 

• Equity in a high-growth start-up 
• Paid time off, including nine paid holidays and an additional Winter Office Closure from Christmas Day (Observed) through New Year's Day 
• Comprehensive medical, dental, and vision coverage 
• One-time $200 Work from Home reimbursement 
• 401(k) Retirement savings options 
• Annual $1,000 Productivity & Wellness Stipend to support your personal and professional goals
• Annual $500 subsidized company contribution to your healthcare FSA or HSA 
• Paid parental leave 

Outreach Notice to Applicants 

We are thrilled that you’re interested in joining our team! To ensure a consistent and equitable hiring process for all candidates, we kindly ask that you refrain from reaching out to current employees regarding the role, your application, or the interview process. Our talent acquisition team is committed to carefully reviewing all applications and will reach out directly if they decide to move forward. 

All applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time. 

#LI-Remote #LI-AA1