Analytics Engineer

firsthand supports individuals living with SMI (serious mental illness). Our holistic approach includes a team of peer recovery specialists, benefits specialists and clinicians, which focuses on meeting each individual where they are and walking with them side by side as a trusted guide, partner, and first call on their journey to wellness.

firsthand's team members use their lived experience to build trust with these individuals and support them in obtaining socio-economic assistance and in reconnecting to primary and behavioral care. Support like this creates substantial savings for managed care organizations (Medicaid providers) and taxpayers by decreasing inappropriate healthcare utilization. This enables us to build solutions that scale and, as a result, change 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.

firsthand is rapidly growing our team to support the needs of people living with SMI across the USA. To achieve this growth we need to further improve analytics around our risk adjustment/appropriate medical coding workflows.

As an analytics engineer, you will be responsible for both implementing new analytics infrastructure and making improvements to our existing systems. You will ensure delivery of solutions on-schedule following modern best practices, using DBT, continuous integration, linting and testing. You are expected to deliver clean, maintainable, and extensible code.

In addition to writing code, you are expected to interface with operators to understand their needs and delight your customers. This role reports to the Director of Data.

As an Analytics Engineer, you will:

• 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

You will be a good fit if you have:

• 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
• Previous experience working with medical claims data, risk adjustment experience is a nice to have
• Comfort both building dashboards and doing deep-dive analysis

The required experience you bring to this role includes:

• 3+ years experience working with dbt, advanced SQL, and git
• 1+ year of working with medical claims data

Bonus points for:

• Prior experience in a start-up environment
• 1+ years experience with medical risk adjustments

Benefits 

For full-time employees, our compensation package includes base, equity (or 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, flexible vacation, and a supportive and inclusive culture.

Unfortunately, we are not able to offer sponsorship at this time.

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 firsthand. Such requests will be subject to review and approval by the Company, and exemptions will be granted only if the Company can provide a reasonable accommodation in relation to the requested exemption. Note that approvals for reasonable accommodations are reviewed and approved on a case-by-case basis and availability of a reasonable accommodation is not guaranteed.