Analytics Engineer
7shifts: Team Management for Restaurants
CloudETLPythonSQL
Senior Data Analytics Engineer
Fullscript
full-time
Posted on:
Location: 🇨🇦 Canada
Visit company websiteJob Level
Senior
Tech Stack
Amazon RedshiftBigQueryCloudETLSQL
About the role
- Work cross-functionally to help define, build, and deploy our Enterprise Data Warehouse to serve reporting and analytical needs across Fullscript.
- Work with Fullscript’s engineering team and other business stakeholders to define and implement our Customer Data Platform (CDP), which uses data from a variety of sources to power decision making about customer acquisition and the customer journey.
- Write data transformation code in ELT pipelines, and work with data delivery tools to ensure the data arrives where it is needed to support this decision making.
- Mentor and provide technical guidance to junior members of the team, and provide guidance and influence to all practitioners of the Analytics Engineering craft throughout the company.
- Ensure data models are properly tested and optimized for scalability and performance.
- Create and maintain data documentation and definitions.
Requirements
- 5+ years in Data Analytics and/or Data Engineering, implementing ETL/ELT processes.
- Strong proficiency in SQL.
- Experience with dbt (data build tool) for implementing transformation stages.
- Experience working with Cloud Data Warehouses such as Snowflake, BigQuery or Redshift.
- Hands-on experience with data modeling, schema design, and optimization techniques.
- Proven experience maintaining data transformation pipelines, ensuring data availability and quality, meeting SLAs, and communicating status to downstream consumers.
- Deep understanding of data engineering best practices, including version control, testing, and CI/CD methodologies.
- Ability to communicate complex technical concepts effectively to technical and non-technical stakeholders.
- Learning mindset, with a keen interest in exploring new technologies and methodologies.
- Bonus: Experience with a Customer Data Platform (CDP).
- Bonus: Experience with ops practices and tools for automated deployment, CI pipeline definition, and infrastructure management.
- Bonus: Previous experience in a leadership or mentorship role in a data engineering team.
- Bonus: A cover letter explaining why analytics engineering is of special interest to you.
Similar jobs on JobTailor
Senior Analytics Engineer
Creative Market
CloudETLPythonSQLTerraform
Analytics Engineer
Mars United Commerce
ApacheAWSAzureCloudETLHadoopPythonPyTorchScikit-LearnSparkSQLTensorflow
Staff BI/Analytics Engineer
ecobee
CloudPythonSQL
Senior Software Engineer II, Ads Data Solutions
Instacart
AirflowAWSGoGRPCPythonRubySparkSQL