Data and Analytics Engineer

at  Fresh Tracks

At Fresh Tracks Canada, we craft tailor-made Canadian vacations for people from all over the world. Since 1996, our team of Canadian Insiders have helped our customers plan their vacations and enjoy life-changing travel experiences.
We believe in keeping our customers front and center in everything we do; in fact, focus on serving our customers is one of our core values. Everyone acts and operates as an owner, treating this business as their own. We raise the bar constantly, embracing that nothing is perfect but continuous improvement is key. Our team is made up of passionate, positive experts who drive healthy collaboration by winning or losing as one, and we bring out the best in each other.

REQUIREMENTS

4+ years of experience in Data Engineering or Analytics Engineering
2+ years of experience with Google Cloud Platform (GCP)
2+ years of experience with Looker and LookML development
Strong SQL and Python skills
Experience in data pipeline architecture
Bachelor’s or Master’s degree in Computer Science, Information Systems, or related fields
Experience building data warehouses, scalable data pipelines, and provisioning self-serve data solutions in cloud-service environment
Proficient in handling large and complex datasets, from extraction to visualization
Experience connecting systems using APIs, Python code, or Bash scripts
Strong working knowledge of ETL and CDC processes, analysis, troubleshooting, and code review
Excellent communication and collaboration skills

DIVERSITY, EQUITY, AND INCLUSION

We are an equal opportunity workplace. We strongly encourage applications from under-represented communities, diverse backgrounds, identities, and experiences. We don’t judge based on race, religion, ethnic background, sexual orientation, age, marital status, disability, gender identity or anything else that you might bring to the table. We don’t care about where you went to college, your degree, your age, or what names you might have on your resume. Instead, we’re looking for motivated, compassionate people who can execute from the ground up. We also know that everyone has a unique career journey and experience comes in many forms.
Officially Great Place to Work® CertifiedTM 2022/2023
Officially Great Place to Work® CertifiedTM 2023/2024
Officially Great Place to Work® CertifiedTM 2024/2025

ABOUT THE ROLE

We are seeking a highly skilled Data & Analytics Engineer to join our dynamic team where you will get to apply your data architecture, engineering, and analytics expertise to design and deploy innovative and scalable data solutions. You will play a pivotal role in driving data-driven decision-making across the organization by developing seamless data pipelines, enabling actionable reporting and modeling, and collaborating with cross-functional teams.

WHAT YOU WILL GET TO DO:

Translate data requirements into clear data sampling plans using efficient SQL and LookML queries
Design and maintain seamless and scalable data pipelines and reporting to support business decisions
Lead data processing solutions and proactively identify gaps and opportunities in collaboration with data science, Business Intelligence, and business stakeholders
Develop and deploy data models and analysis for business processes, data usage, and process design
Conduct in-depth data analyses to uncover new data science opportunities and business insights
Enhance data governance, security frameworks, and data integration to ensure data integrity
Document assumptions, requirements, methodologies, and test plans, facilitating knowledge sharing
Analyze structured and unstructured data to identify trends and communicate findings
Coordinate model-driven process engineering and automation data/process initiatives
Stay current with with data engineering best practices and continually develop new techniques