Demo

Data Engineer

Two Chairs
Los Angeles, CA Full Time
POSTED ON 1/19/2025
AVAILABLE BEFORE 4/19/2025

Job Description

Job Description

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

    Salary : $162,000 - $180,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Engineer?

    Sign up to receive alerts about other jobs on the Data Engineer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Two Chairs

    Two Chairs
    Hired Organization Address Portland, OR Full Time
    Two Chairs is building a new kind of mental health system based on the idea that the status quo isn't good enough. Indus...
    Two Chairs
    Hired Organization Address San Francisco, CA Full Time
    Job Description Job Description Two Chairs is building a new kind of mental health system based on the idea that the sta...
    Two Chairs
    Hired Organization Address Palm, FL Part Time
    Two Chairs is building a new kind of mental health system based on the idea that the status quo isn’t good enough. Indus...
    Two Chairs
    Hired Organization Address San Francisco, CA Full Time
    Two Chairs is building a new kind of mental health system based on the idea that the status quo isn't good enough. Indus...

    Not the job you're looking for? Here are some other Data Engineer jobs in the Los Angeles, CA area that may be a better fit.

    Data Engineer

    Entertainment Data Oracle (EDO), Los Angeles, CA

    Data Science Solutions Engineer

    Entertainment Data Oracle (EDO), La Puente, CA

    AI Assistant is available now!

    Feel free to start your new journey!