Data Engineer

Sidecar Health is redefining health insurance. Our mission is to make excellent healthcare affordable and attainable for everyone. We know that to accomplish this lofty mission, we need driven people who will make things happen.

The passionate people who make up Sidecar Health’s team come from all over, with backgrounds as tech leaders, policy makers, healthcare professionals, and beyond. And they all have one thing in common—the desire to fix a broken system and make it more personalized, affordable, and transparent.

If you want to use your talents to transform healthcare in the United States, come join us!

**California residents only**

About the Role

As a Data Engineer at Sidecar Health, you will play a critical role in building and maintaining our data infrastructure, pipelines, and reporting capabilities. You’ll use cutting-edge tools and technologies to manage and transform data, deliver actionable insights, and support key business initiatives. Collaborating across teams, you’ll help improve operational efficiency and drive data-driven decision-making.

What You’ll Do

• Use SQL and Python on AWS infrastructure to build ETL jobs and data pipelines that integrate data from various internal and external sources into Snowflake Data Warehouse
• Leverage DBT (Data Build Tool) to transform data, consolidate records, delete duplicates, and create clean, formatted data models
• Utilize AWS technologies such as S3, SES, Transfer Family, and Secrets Manager to send reports and support business teams and partners
• Containerize and orchestrate data pipelines using Docker and Airflow, while developing monitoring and alerting systems
• Perform data quality checks, cleanup, and ensure the reliability of data stored in the data warehouse
• Develop reports and dashboards using tools like Tableau and ThoughtSpot to deliver actionable insights into customer acquisition, operational efficiency, and other key metrics
• Engage in agile development activities, including sprint planning, peer reviews, daily standups, product demos, and sprint retrospectives

What You'll Bring

• Master’s degree (or foreign degree equivalent) in Computer Science or a related field
• 1+ years of experience in a related role, such as Data Engineer or Software Engineer
• Proficiency in SQL, Python, and data modeling, with the ability to write complex SQL statements using joins and window functions
• Hands-on experience with ETL processes, real-time and batch data processing, and integrating data from multiple sources and formats (e.g., JSON, XML, CSV)
• Familiarity with Spark, Athena, Docker, and version control systems like GIT
• Knowledge of secure, scalable, cloud-based architectures compliant with HIPAA or PCI
• Experience creating data visualizations and dashboards using tools like Tableau or ThoughtSpot
• Ability to interpret business requirements and translate them into efficient, scalable software solutions
• Knowledge of machine learning features, Tableau server architecture, and Airflow is a plus
• Experience working in agile development environments

What You'll Get

• Competitive salary, bonus opportunity, and equity package 
• Comprehensive Medical, Dental, and Vision benefits 
• A 401k retirement plan 
• Paid vacation and company holidays 
• Opportunity to make an impact at a rapidly growing mission-driven company transforming healthcare in the U.S.