Fullscript helps people get better. It's at the core of everything we do. As the leading platform for prescribing integrative health products, our work positively impacts millions of lives everyday. Our purpose extends well beyond our platform. As a health company, we are committed to the wellbeing of our team members. We are building an organization where people thrive, grow, and have a high impact through their work. 🌱

By joining us, you stand with our purpose. You are an independent thinker, who likes to leave things better than you found them. You do things not because they are easy but because they are right. Ready to make an impact?

We’re seeking an intermediate level Data Analytics Engineer for our Data Engineering team. The Data team is both a support function and strategic partner at Fullscript and will be a key area of investment in the future. Data is used to drive effective planning and decision making all the way from exploration of opportunities, to hypothesis testing and goal setting, to measurement of results and iteration. We will invest heavily in the coming years to make data more accessible to our internal teams and to leverage it within our application to provide our practitioners and patients with data-driven tools and experiences.

As the Data Analytics Engineer you will be building the data platform that powers our decision making. This same platform also provides key insights for our practitioners and their patients through analytics and advanced metrics.

What you'll do

• You will collaborate across functions such as analytics, product, and operations to understand their data
• Using that insight, you will write the data transformation code in ELT pipelines to integrate that data into our data warehouse for consumption by the reporting and data analytics functions
• Working with other data engineers you will create and populate the data models for downstream consumption and write tests to ensure data quality
• Apply version control, testing and continuous integration (CI) in the data transformation code.
• Maintain data documentation and definitions

What you bring to the table

• 2+ years in Data Analytics and/or Data Engineering position as part of ETL/ELT process or data insights development
• Strong proficiency with SQL, and using Python for data transformation
• Experience writing and implementing data transformation pipelines in Argo, Airflow or similar Workflow orchestration tools
• Experience working with RDBMS (PostgreSQL, MySQL) and understanding of Cloud Data warehouses like Snowflake, BigQuery, Redshift
• You write tests for data quality as part of the data pipeline and understand their value
• Keen interest in learning more about programming, modern data stack and data engineering.

Bonus

• Data warehouse modeling experience
• Experience with Fivetran, Snowflake and dbt
• DevOps experience
• Write us a cover letter explaining why data engineering is of special interest to you

What we can offer you

• Generous PTO and competitive pay
• Fullscript’s RRSP match program for financial health
• Flexible benefits package and workplace wellness program
• Training budget and company-wide learning initiatives
• Discount on Fullscript catalog of products
• Ability to work Wherever You Work Well*

*Our Wherever You Work Well philosophy means Fullscript teammates get to pick their own office — whether that’s in-office, at home, or a bit of both.

Fullscript is committed to diversity in its workforce and is proud to be an equal opportunity employer. We are excited to work with talented people, period. All employment decisions are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, national or ethnic origin, gender, age, disability, sexual orientation, gender identity and/or expression, marital or civil status, political affiliation, family or parental status, or any other status protected by the laws or regulations in the jurisdictions in which we operate.

Accommodations are available on request for candidates taking part in all aspects of the selection process. Please send an email to accessibility@fullscript.com and let us know the nature of your request and your contact information.

Want to learn more? Check us out at www.fullscript.com/careers, find us on social media, or check out our culture guide.