Data and Analytics Engineer

at  Fresh Tracks Canada

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