Analytics Engineer

Summary

Join firsthand, a company supporting individuals with serious mental illness (SMI), as an Analytics Engineer. You will build and improve data pipelines, create reports and dashboards, identify patterns in data, and collaborate with other teams. This role requires strong experience with dbt, SQL, and working with medical claims data. The ideal candidate is a team player comfortable with both high-level analysis and detailed data work. firsthand offers a competitive salary, equity, performance bonuses, and comprehensive benefits including health, dental, vision, 401k, parental leave, and flexible vacation.

Requirements

• Strong experience in dbt, SQL (snowflake ideally), git, and bash
• A team player mentality and a desire to work in a fast paced in environment where we are constantly shipping high value work
• 3+ years experience working with dbt, advanced SQL, and git
• 1+ year of working with medical claims data
• Comfort both building dashboards and doing deep-dive analysis

Responsibilities

• Build clean, maintainable, and performant data pipelines which enable reliable analysis and BI reporting
• Work with stakeholders to develop reporting and dashboards
• Identify patterns in the analyses you conduct and data models you build, using those patterns to improve the speed and accuracy of our processes
• Partner with our product and engineering teams to continually improve our analytics and reporting infrastructure

Preferred Qualifications

• Previous experience working with medical claims data, risk adjustment experience is a nice to have
• Prior experience in a start-up environment
• 1+ years experience with medical risk adjustments

Benefits

• Base, equity (or special incentive program for clinical roles) and performance bonus potential
• Physical and mental health
• Dental
• Vision
• 401(k) with a match
• 16 weeks parental leave for either parent
• Flexible vacation
• A supportive and inclusive culture