Data Engineer
Apply NowCompany: Mountain Equipment Company
Location: Vancouver, BC V5K 5J9
Description:
About MEC
At MEC, we believe the transformative power of the outdoors makes us better humans and drives us to do good for the planet. We are here to inspire and support everyone in getting active outside, matching people with gear and advice that instills confidence. We offer more than products; we offer passion for the outdoors. We play with purpose!
Our business model is dependent on impassioned and well-trained outdoor enthusiasts and as such we look for individuals who live our purpose and fit with MEC ethos and lifestyle. If you are that person, we'd love to connect with you. Join us!
Inclusivity at MEC
MEC is an equal opportunity employer and committed to building an inclusive community of staffers. We're proud to work with our people to create a diverse workplace, where everyone feels like they belong and has the opportunity to be successful. We welcome of all applicants to join our diverse team. Tell us what you need during the hiring process, and we'll do our best to accommodate you.
The Opportunity
This role blends data engineering, analytics, and business intelligence to enhance many areas of the business, and primarily customer engagement, loyalty programs, merchandising, and marketing effectiveness. Reporting to the Manager of Data and Analytics, with strategic direction from the Growth & Loyalty Director, you will build data-driven solutions that improve decision-making insights, support membership expansion and retention, and optimize targeted promotions. You will also play a key role in data integration projects, ensuring seamless collaboration between technical teams and other business stakeholders.
Location: This is a hybrid role based out of MEC Head Office in Vancouver, requiring you to be in office 2 to 3 days a week.
Marketing & Loyalty Analytics
Data Engineering & Business Intelligence
The Qualifications
It's a bonus if you these certifications
The Compensation & Perks
This is an permanent role with an anticipated annual base salary range of $75,500 to $94,500. The exact salary will be dependent on the successful candidate's relevant skills, experience, location, qualifications and internal equity. This role is eligible for our annual variable incentive plan.
At our Home Office located in Vancouver, you'll also love:
Note: Availability of the benefits and perks may be subject to your location & employment type and may have certain eligibility requirements. MEC reserves the right to alter these benefits and perks in whole or in part at any time without advance notice.
Are you up for your next adventure? We'd love to hear from you!
The Candidate must be able to read and converse in English. Le candidat doit tre l'aise de lire et de converser en anglais.
At MEC, we believe the transformative power of the outdoors makes us better humans and drives us to do good for the planet. We are here to inspire and support everyone in getting active outside, matching people with gear and advice that instills confidence. We offer more than products; we offer passion for the outdoors. We play with purpose!
Our business model is dependent on impassioned and well-trained outdoor enthusiasts and as such we look for individuals who live our purpose and fit with MEC ethos and lifestyle. If you are that person, we'd love to connect with you. Join us!
Inclusivity at MEC
MEC is an equal opportunity employer and committed to building an inclusive community of staffers. We're proud to work with our people to create a diverse workplace, where everyone feels like they belong and has the opportunity to be successful. We welcome of all applicants to join our diverse team. Tell us what you need during the hiring process, and we'll do our best to accommodate you.
The Opportunity
This role blends data engineering, analytics, and business intelligence to enhance many areas of the business, and primarily customer engagement, loyalty programs, merchandising, and marketing effectiveness. Reporting to the Manager of Data and Analytics, with strategic direction from the Growth & Loyalty Director, you will build data-driven solutions that improve decision-making insights, support membership expansion and retention, and optimize targeted promotions. You will also play a key role in data integration projects, ensuring seamless collaboration between technical teams and other business stakeholders.
Location: This is a hybrid role based out of MEC Head Office in Vancouver, requiring you to be in office 2 to 3 days a week.
Marketing & Loyalty Analytics
- Support Growth & Loyalty Marketing - Provide data-driven insights for membership expansion, retention, referral incentives, and key growth projects.
- Develop & Refine Loyalty Metrics - Define and maintain key metrics such as tenure cohorts, redemption rates, churn risk, CAC, LTV, purchase frequency, etc.
- Analyze Member Behavior - Identify patterns across product categories (e.g., camping, hiking, cycling, climbing) to enhance loyalty program effectiveness.
- Consolidate Retention Data - Integrate insights from CRM, acquisition, and email marketing tools (e.g., Klaviyo, BigCommerce, D365) to refine retention and re-engagement strategies.
- Merchandising & Business Insights - Translate member behavior insights into opportunities for product development and merchandising.
- Strategic Recommendations - Collaborate with the Growth & Loyalty Director to develop data-driven strategies for tier-based benefits, personalized engagement, and promotions.
Data Engineering & Business Intelligence
- Requirements Gathering & Business Process Optimization - Work with stakeholders to document and analyze business needs.
- Cross-Functional Collaboration - Bridge the gap between business and technical teams to ensure seamless data integration.
- Best Practices & Cost Control - Establish data engineering best practices and optimize cloud-based solutions for cost efficiency.
- Technical Solution Development - Design, build, maintain, deploy, test, and troubleshoot data pipelines and transformations.
- Azure Cloud-Based Data Engineering - Develop data warehouse components to support extract, transform, and load (ETL) processes.
- Technical Leadership - Provide coaching, mentoring, and data guidance across the organization.
The Qualifications
- 1+ years of experience working with a omnichannel retail loyalty program as a Data Engineer or Data Analyst
- 2-5 years of hands-on SQL and/or DAX experience is required.
- Strong written and verbal communication skills.
- Experience working with Entity Relational Diagrams, Data Flow Diagrams, and Architecture Diagrams.
- Knowledge of Microsoft Azure stack, including:
- Azure Storage
- Azure Logic Apps
- Azure Data Factory
- Azure SQL Database
- Azure Key Vault
- Power BI Development
- Proficiency in DAX, SQL, VBA, Python, and PowerShell is an asset.
- Advanced experience with Microsoft Office Suite, particularly Excel and collaboration tools.
- Strong ability to collaborate with teams, drive solutions, and adapt to evolving business needs.
- Post-secondary education in software development, engineering, business, or science is an asset.
It's a bonus if you these certifications
- Microsoft Certified: Azure Data Engineering Associate
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft Certified: Data Analyst Associate
- Associate Certificate in Database Administration
- Applied Database Administration and Design
The Compensation & Perks
This is an permanent role with an anticipated annual base salary range of $75,500 to $94,500. The exact salary will be dependent on the successful candidate's relevant skills, experience, location, qualifications and internal equity. This role is eligible for our annual variable incentive plan.
- Work-life flexibility
- Hybrid work environment
- Variable annual incentive plan
- Generous annual vacation allotment
- Paid Care time (Wellness/sick)
- Maternity and Parental leave top-up
- Staff Discount and amazing deals straight from vendors
- Top-notch benefit plan
- Retirement Plan, with matched contributions
- Paid days to pursue outdoor activities and/or volunteer in your community
- Access to a learning platform and educational assistance support
- Career development opportunities
At our Home Office located in Vancouver, you'll also love:
- Show up as you are-Athleisure wear
- An open office layout- choose where you sit.
- Well stocked kitchens filled with premium coffees and teas (and ALL the milks)
- Onsite fitness equipment, change rooms with showers and bike storage
Note: Availability of the benefits and perks may be subject to your location & employment type and may have certain eligibility requirements. MEC reserves the right to alter these benefits and perks in whole or in part at any time without advance notice.
Are you up for your next adventure? We'd love to hear from you!
The Candidate must be able to read and converse in English. Le candidat doit tre l'aise de lire et de converser en anglais.