Senior Analytics Engineer
At RXNT, we think of ourselves as a backbone to the US healthcare system. Every day, we provide the digital foundation on which healthcare professionals serve patients, order medications and lab tests, bill insurance companies, and interact with the wider healthcare community.
23 years of blood, sweat, and tears have taught us that this pursuit comes with great responsibility. It’s in the best interest of everyone if we hold ourselves to high standards, think rigorously, and at times, act urgently.
RXNT has a blend of complex user-facing reports built into our products, and also internal 'executive' reports that require us to crunch down hundreds of tables (and other sources) into KPIs that will orient the business. You will be working within the domain of creating end-to-end reports, you should be versatile and open to working across the full data stack (e.g. modeling, analysis, BI tools).
We’re looking for self-motivated people who love to learn, are comfortable in a fast-paced and quickly-growing environment, and who seek ownership.
What you'll be doing
- As a Senior Analytics Engineer, you will design and implement data modeling, reporting, and queries for RXNT’s various systems.
- You will manage and extend RXNT’s customer-facing data warehouse models (BigQuery, DBT), write complex analytical queries, find clever workarounds when data is missing (for instance, building SCD tables), and ultimately aim for high-ROI reporting strategies.
- With the help of our team, you will quickly become an expert in RXNT's complex entity relationships. The learning curve is steep but necessary to do accurate analyses.
- You will push for and maintain best practices, such as testing in DBT, performant SQL, and consistent code standards (e.g. Fishtown style guide).
- You will communicate thoroughly with the product team, designers, engineers, and sometimes customers to understand user needs and nuances in RXNT’s data.
- With the help of your engineering manager, you will often provide both optimistic and pessimistic time estimates for your work.
- BI tools like Tableau or Data Studio will be integral to your daily work.
You might be a good fit if you
- Have a proven track record (3+ years of experience) as a data analyst at a SaaS company
- Are proficient in writing analytical SQL and understand the difference between SQL that works, and performant SQL
- Consider yourself a full-stack data analyst
- Have experience using the command line and git
- Have a solid understanding of data warehouses and business intelligence tools
- Have experience with DBT
- Can communicate clearly and directly about complex technical topics
- Are highly motivated to work autonomously, with strong organizational and time management skills