Staff Data Engineer

firsthand supports individuals living with SMI (serious mental illness). Our holistic approach includes a team of peer recovery specialists, benefits specialists and clinicians. Our teams focus on meeting each individual where they are and walking with them side by side as a trusted guide and partner on their journey to better health.
firsthand's team members use their lived experience to build trust with these individuals and support them in reconnecting to the healthcare they need, while minimizing inappropriate healthcare utilization. Together with our health plan partners, we are changing the way our society supports those most impacted by SMI.
We are cultivating a team of deeply passionate problem-solvers to tackle significant and complex healthcare challenges with us. This is more than a job—it's a calling. Every day, you will engage in work that resonates with purpose, gain wisdom from motivated colleagues, and thrive in an environment that celebrates continuous learning, creativity, and fun.

We are building data infrastructure to enable more timely and personalized engagement with individuals living with SMI at scale. This allows our team of peers, social workers, and nurse practitioners to plan appropriate care and focus on critical tasks rather than manually searching for information across silos in the healthcare system. This is a unique opportunity to found and define the data engineering team, our stack and architecture, with a high caliber product and data team that is growing quickly. You will build impactful healthcare technology on a modern technology stack.

As a Staff Data Engineer, you will:

• Work in a fast-paced, agile team to build and improve modern cloud-based data infrastructure (Snowflake, Postgres, Fivetran, and Airflow). Focus on processing and managing diverse healthcare data through efficient ELT pipelines
• Provide technical leadership throughout the technical design and implementation process
• Own end-to-end infrastructure releases and platform improvements, ensuring reliability and performance at scale
• Lead the technical design process, bringing your expertise and analysis to help make data-driven decisions
• Contribute to developing a culture of testing and code quality by establishing and maintaining robust test coverage and engineering best practices
• Actively participate in ensuring firsthand maintains a disciplined approach to healthcare security and privacy

You will be a good fit if you have:

• You are comfortable collaborating with cross-functional stakeholders to translate business needs into scalable data solutions.
• You have experience working on data engineering teams, building and deploying highly scalable data analytics applications
• You have deep experience working with medical and pharmacy claims to drive intelligent operational workflows
• You are passionate about building quality products and want to own product development end-to-end leading with the right design and development principles
• You are a team player and are interested in working at a fast-paced startup environment
• Experience with Apache Airflow, DBT, and ETL / ELT tools, and cloud platforms (e.g., AWS, GPC)
• Competent Python skills

Our application stack:

• DBT
• Python
• Airflow
• Snowflake
• Postgres (for storing our own internal application data)
• Other tools like Fivetran/Hightouch

The experience you bring to this role includes:

• Minimum of 3 years of experience in data engineering
• Prior experience in healthcare or life sciences data infrastructure development
• Expert in SQL
• Familiarity with production airflow environment + python

Benefits 
For full-time employees, our compensation package includes base, equity (or a special incentive program for clinical roles) and performance bonus potential. Our benefits include physical and mental health, dental, vision, 401(k) with a match, 16 weeks parental leave for either parent, 15 days/year vacation in your first year (this increases to 20 days/year in your second year and beyond), and a supportive and inclusive culture.
Vaccination Policy
Employment with firsthand is contingent upon attesting to medical clearance requirements, which include, but may not be limited to: evidence of vaccination for/immunity to COVID-19, Hepatitis B, Influenza, MMR, Chickenpox, Tetanus and Diphtheria. All employees of firsthand are required to receive these vaccinations on a cadence/frequency as advised by the CDC, whereas not otherwise prohibited by state law.
New hires may submit for consideration a request to be exempted from these requirements (based on a valid religious or medical reason) via forms provided by firstha