Data and Analytics Engineer

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.

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

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
  

NICE TO HAVES

• GCP Professional Data Engineer Certification
• Experience with Dataform and Vertex AI model deployment
• Machine Learning Engineering experience
• Experience with data science or data analytics projects
• Familiarity with analyzing user behavior data using tools like Amplitude
• Solid understanding of foundational statistical concepts
• Experience supporting ML and AI experiments, business intelligence, and data science models
• Understanding of high-volume data processing, relational and NoSQL databases, and machine learning tools/frameworks
• Experience with AWS stack (certification preferred)
  
  

REWARDS

You may be eligible to receive the following benefits, based on your contract type:

• 3 weeks vacation (4 weeks after your first year)
• Extended health benefits package
• Applauz Recognition
• Comprehensive employee assistance program
  
• Paid anniversary day off
• "Pawternity leave" days for your new furry family members
  
• Great working hours
  
• Friendly and fun team environment with company celebrations and social events
• Access to Canadian travel industry discounts!
• Employee Share Ownership Plan (ESOP)
• DE&I initiatives and events
• Community (volunteer) Hours
• Social Clubs including Book Club & Fitness Club
  
• Paid Maternity & Parental leave
  
• Paid Pregnancy loss leave

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

#INDHP