Senior Data Analytics Engineer

Summary

Join Fullscript's Data Commercial team as a Senior Data Analytics Engineer and build the data platform that powers our decision-making and growth. You will work cross-functionally to maintain, build, and deploy a Commercial data warehouse, collaborate on initiatives across functions, and write data transformation code. Mentor junior team members, create data models, optimize data pipelines, and leverage AI and machine learning. Apply advanced data engineering techniques and ensure data quality through testing and version control. Create and maintain data documentation and definitions. This role requires 5+ years of experience in data analytics or engineering and strong proficiency with SQL and Python.

Requirements

• 5+ years in Data Analytics and/or Data Engineering position as part of ETL/ELT process or data insights development
• Strong proficiency with SQL and experience using Python for data transformation
• Experience working with dbt (data build tool)
• Experience working with Cloud Data warehouses like Snowflake, BigQuery, Redshift and RDBMS (PostgreSQL, MySQL)
• Hands-on experience with data modeling, schema design, and optimization techniques
• Proven track record of implementing and maintaining data transformation pipelines using tools like dbt (data build tool), Argo, Airflow, or similar workflow orchestration tools
• Deep understanding of data engineering best practices, including version control, testing, and CI/CD methodologies
• Ability to communicate complex technical concepts effectively to both technical and non-technical stakeholders
• Continuous learning mindset with a keen interest in exploring new technologies and methodologies in the data engineering space

Responsibilities

• Work cross-functionally to help maintain, build and deploy a Commercial data warehouse to serve reporting, analytical, and self-service needs for key Fullscript stakeholders
• Work with your leader and team to collaborate on initiatives across functions such as Analytics, Commercial, and RevOps to understand and improve their data
• Write data transformation code in ELT pipelines to integrate that data into our data warehouse for consumption by the reporting and data analytics functions
• Mentor and provide technical guidance to junior members of the data engineering team
• Work with other data engineers to create and populate the data models for downstream consumption, and write the necessary tests to ensure data quality
• Apply advanced data engineering techniques to optimize performance and scalability of data pipelines
• Leverage AI and machine learning to build models that are responsive to business requirements and enable the delivery of streamlined, dynamic experiences for customers
• Apply version control, testing and continuous integration (CI) in the data transformation code
• Create and maintain data documentation and definitions

Preferred Qualifications

• Experience with DevOps practices and tools for automated deployment and infrastructure management
• Practical experience building and deploying data models that leverage AI and machine learning (using Azure, AWS, Snowflake, etc.)
• Familiarity with machine learning concepts and frameworks for implementing predictive analytics solutions
• Previous experience in a leadership or mentorship role within a data engineering team

Benefits

• 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*