Vancouver, British Columbia, Canada · Hybrid
$105k–$125k/yr
Role Overview Armstrong Collective is the parent company of Rocky Mountaineer and Canyon Spirit, creating unforgettable rail journeys through some of the most breathtaking landscapes in Western Canada and the American So…
Skills: Microsoft Fabric, Power BI, PySpark, T-SQL, Data Modelling
Jasper, Alberta, Canada · On-site
Armstrong Collective is the parent company of Rocky Mountaineer (RM) and Canyon Spirit, unforgettable rail experiences in Western Canada and the American Southwest. Since 1990, we have grown to become the largest private…
Skills: Customer Service, Professional Communication, Multitasking, Organization, Attention To Detail
Banff, Alberta, Canada · On-site
Armstrong Collective is the parent company of Rocky Mountaineer (RM) and Canyon Spirit, unforgettable rail experiences in Western Canada and the American Southwest. Since 1990, we have grown to become the largest private…
Skills: Communication, Public Speaking, Time Management, Multitasking, Organizational Abilities
Vancouver, British Columbia, Canada · On-site
$63k–$70k/yr
Armstrong Collective is the parent company of Rocky Mountaineer and Canyon Spirit, unforgettable rail experiences in Western Canada and the American Southwest. Since 1990, we have grown to become the largest privately-ow…
Skills: Leadership, Coaching, Verbal Communication, Written Communication, Microsoft Office
Toronto, Ontario, Canada · On-site
$85k–$95k/yr
Purpose The Business Development Manager (BDM) is responsible for generating business through the development of close relationships with the travel agent channel in USCA. Priority focus of the role is to execute Key Ret…
Skills: Relationship Building, Sales Strategy, Account Management, Presentation Skills, Business Development
Vancouver, British Columbia, Canada · On-site
$100k–$110k/yr
Purpose: At Armstrong Collective, the parent company of Rocky Mountaineer and Canyon Spirit, we create unforgettable journeys that connect our guests to some of the world’s most iconic landscapes. Reporting to the …
Skills: Lifecycle Marketing, CRM, Marketing Automation, CMS, Google Analytics
Vancouver, British Columbia, Canada · On-site
Armstrong Collective is the parent company of Rocky Mountaineer (RM) and Canyon Spirit, unforgettable rail experiences in Western Canada and the American Southwest. Since 1990, we have grown to become the largest private…
Skills: Public Speaking, Attention To Detail, Organization, Guest Service, Microsoft Office
Vancouver, British Columbia, Canada • Hybrid
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Design and implement end-to-end data pipelines and canonical data models using Microsoft Fabric and Spark. Modernize legacy T-SQL workloads and deliver high-performing Power BI semantic models and dashboards to enable self-serve analytics.
Requires 5+ years of data engineering experience with expertise in Microsoft Fabric, PySpark, and enterprise data modelling. Proficiency in Power BI, T-SQL, and CI/CD practices is essential for delivering scalable analytics solutions.
Role Overview
Armstrong Collective is the parent company of Rocky Mountaineer and Canyon Spirit, creating unforgettable rail journeys through some of the most breathtaking landscapes in Western Canada and the American Southwest. Guided by our values—Create Meaningful Moments, Be One Team, and Achieve Extraordinary Outcomes, we show up every day with pride, ownership, and a shared commitment to excellence. We work hard, support one another, embrace new possibilities, and celebrate growth, all in a respectful and inclusive environment where integrity, collaboration, and passion for the guest experience lead the way.
We are looking for a versatile Data Engineer with deep expertise across the Microsoft Fabric platform who demonstrates strong ownership, accountability, and continuous learning while delivering modern data solutions end-to-end. In this individual contributor role with informal technical leadership expectations, you take initiative to guide approaches, influence best practices, and support peers, while remaining hands-on in design, build, and delivery.
You are responsible for ingesting high-volume data, designing canonical data models, modernizing legacy T-SQL workloads, modelling data in the Lakehouse, and delivering trusted analytics solutions. You proactively collaborate with stakeholders, align work to business outcomes, and contribute to advancing a governed, self-serve analytics ecosystem.
Key Responsibilities
• Design canonical data models, taking ownership of data quality, integrity, and alignment to business needs.
• Apply entity-relationship, normalized, and dimensional modelling techniques with strong attention to detail and continuous improvement.
• Design and implement end-to-end data pipelines, proactively identifying risks and ensuring reliability and scalability.
• Build and optimize Spark / PySpark pipelines, ensuring performance, maintainability, and quality outcomes.
• Lead the modernization of legacy T-SQL workloads into Spark, influencing design decisions and ensuring successful delivery.
• Design and maintain Power BI semantic models, enabling business-friendly and high-performing datasets.
• Build intuitive Power BI reports and dashboards that drive decision-making and user adoption.
• Champion self-serve analytics by enabling users, promoting best practices, and contributing to governance standards.
• Leverage Fabric and Copilot capabilities to improve productivity and generate insights.
• Implement monitoring, observability, and data quality controls, taking proactive action on issues.
• Collaborate with stakeholders, guiding discussions and clarifying requirements to deliver effective data solutions.
• Contribute to standards, CI/CD practices, and documentation, influencing continuous improvement across the team.
Experience and Qualifications
• 5+ years of data engineering experience with delivery of batch and streaming workloads.
• Strong Power BI development experience including semantic models, reports, dashboards, and advanced DAX.
• Demonstrated expertise in enterprise data modelling including ER, normalized, and ildimensional modelling.
• Experience designing canonical data models across multiple systems and use cases.
• Hands-on experience with Microsoft Fabric, Lakehouse, Pipelines, and Notebooks.
• Strong Spark / PySpark experience with production environments such as Databricks or Fabric.
• Experience converting complex T-SQL workloads into Spark with structured validation approaches.
• Strong T-SQL knowledge and understanding of relational systems.
• Experience with CI/CD practices, including source control and deployment pipelines.
• Experience supporting self-serve analytics and enabling business users.
• Proficiency with data modelling tools.
Preferred Qualifications
• Relevant Microsoft and data certifications (e.g., DP-700, DP-600, PL-300, DP-203, Databricks certifications).
• Experience with Fabric Copilot or AI-assisted development tools.
• Exposure to data mesh, medallion architecture, and modern data design patterns.
• Experience in regulated or data-sensitive industries.
What Success Looks Like
• Demonstrates strong ownership and accountability, consistently delivering high-quality data solutions.
• Builds trusted relationships and collaborates effectively across teams.
• Acts as a go-to technical contributor, proactively supporting and influencing others.
• Continuously improves systems, processes, and personal capability.
• Within first 2 months: contributes to canonical data model design and understands platform architecture.
• Within 3 months: delivers enhancements to pipelines and publishes semantic models and reports.
• Within 6 months: owns end-to-end data products and contributes to migration and governance initiatives.
What Success Looks Like
• Demonstrates strong ownership and accountability, consistently delivering high-quality data solutions.
• Builds trusted relationships and collaborates effectively across teams.
• Acts as a go-to technical contributor, proactively supporting and influencing others.
• Continuously improves systems, processes, and personal capability.
• Within first 2 months: contributes to canonical data model design and understands platform architecture.
• Within 3 months: delivers enhancements to pipelines and publishes semantic models and reports.
• Within 6 months: owns end-to-end data products and contributes to migration and governance initiatives.
Work Environment
Compensation
Eligible Benefits
Armstrong Collective supports our team members’ health and wellness by providing a comprehensive medical plan with 100% employer paid premiums, some of which includes:
Armstrong Collective, Rocky Mountaineer and Canyon Spirit are an equal opportunity employer, driven by our values of creating meaningful moments, being one team, and achieving extraordinary outcomes. Our strong company culture supports our vision of a diverse, open, safe, and respectful workplace. We celebrate diversity and are committed to creating an inclusive environment for all team members. If you require any accommodation during the application process or throughout your employment, please let us know. We will work with you to ensure your needs are met and to create a supportive environment.
A meeting of disciplines, minds, makers & problem solvers
We work with clients to reveal architectural solutions that inspire, challenge and delight, while solving their unique design problem.
Offices: 30 Henry St, Fremantle, Western Australia 6160, AU
View all jobs at Armstrong CollectiveA meeting of disciplines, minds, makers & problem solvers
We work with clients to reveal architectural solutions that inspire, challenge and delight, while solving their unique design problem.
Offices: 30 Henry St, Fremantle, Western Australia 6160, AU
View all jobs at Armstrong Collective