Data Engineer

Summary

Join Two Chairs, a leading mental health company recognized for its exceptional workplace, as a Data Engineer. You will play a crucial role in building and maintaining scalable data pipelines and models, collaborating with various teams to ensure high-quality data. Your responsibilities include developing and optimizing data pipelines, implementing data quality checks, and creating data models. You will work closely with data scientists, engineers, and other stakeholders to meet data needs and improve data processes. This role requires 2-4 years of experience in data pipelines and ETL processes, proficiency in Python, SQL, and cloud platforms, and strong problem-solving skills. Two Chairs offers a competitive salary, comprehensive benefits, and a supportive work environment.

Requirements

• 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

Responsibilities

• 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

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