Business Intelligence Architect
Top Benefits
About the role
Purpose The BI Architect reports into the Manager, Analytics.
The BI Architect is responsible for designing, implementing, and maintaining data structures that support organizational reporting and analysis. Working with Business Data Analysts, they will consider end user requirements in designing business intelligence solutions that will deliver key insights in an effective, automated, and reliable way.
Key Areas of Accountability
- In concert with the Business Data Analyst, identify appropriate sources of Data Warehouse data
- Build and maintain BI Architecture in relation to definitions of data content, understanding data flow between source systems and reports
- Set standards and best practices together with other architects
- Build logical data models for BI reporting and analytic solutions
- Architect, design, build and maintain solutions to meet enterprise business needs for the data warehouse and data mart environments
- Monitor and investigate new versions, technologies and techniques as well as advise management on adoption strategies.
- Ensure that BI Sprint solution delivery is adhering to architecture and development standards
- Implementation of Microsoft Power BI data models
- Develop, document and execute test plans
- Resolve issues and inconsistencies in the data
- Searching for causes of incompatibility between the warehouse and other systems
- Collaborate with IT to tune the analytics environment for optimal performance
Qualifications Education / Certifications / Licenses
-
Bachelor’s Degree in technical or business discipline or equivalent experience
-
Microsoft Power BI certification
Experience
- 6+ years of overall experience within the Business Intelligence/Data Warehousing space
- Advanced experience with Microsoft Power BI, SQL Server and SSIS
- Experience with data modeling and metadata management
- Experience defining data and user class security for reports and packages
- Experience translating business requirements into functional requirements, and translating those into reporting objects and reporting data requirements
- Experience in design patterns, development methodologies, delivery models etc.
- Solid experience in BI and Data Warehousing concepts
- Knowledge of IT concepts, strategies, and methodologies, architectures, and technical standards
- Knowledgeable in new and emerging business intelligence technologies
- Understanding of Salesforce Data Model a strong asset
- Travel and Hospitality Industry experience an asset
Skills
- Strong communication skills and interpersonal skills
- Responsive with a high sense of urgency
- Excellent analytical and problem-solving skills
- Ability to manage multiple conflicting priorities, reprioritize tasks, work independently and meet deadlines
- Ability to prepare and deliver comprehensive, clear, and professional documentation.
Compensation
- The base salary offered for this role is $82,000 to $102,000 per annum and can vary based on job-related expertise, qualifications, experience and internal equity.
- Eligible for Armstrong Collective’s discretionary bonus program
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:
- Medical, Dental, Vision, Life Insurance
- Short term disability, long term disability benefits
- Travel emergency assistance
- Vacation time and sick time
- Up to 5% RRSP and/or TSFA match
- Two complimentary annual train tickets after first year of employment
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.
Please ensure to opt-in for text messages when you apply in order to receive interview updates.
About Rocky Mountaineer
Our reason for working at Rocky Mountaineer is simple – to be the creators of life changing experiences, not just for our guests, but also for our employees. Join us at Rocky Mountaineer and build your career alongside an incredibly talented global team of passionate, energetic, diverse, and fun individuals who have helped to position us as the world-renowned leader in luxury train travel.
With rail routes operating in Western Canada and the American Southwest, Rocky Mountaineer’s team stretches the globe with employees in Canada (BC, AB, ON, QC), the USA, the UK, Australia and New Zealand.
Rocky Mountaineer has received numerous international awards and accolades. We have won thirteen World Travel Awards throughout our history; we were named Best Sustainable Train in 2021 in the Lonely Planet's Best in Travel awards; and are three-time winner of the Best Rail Company category at the Globe Travel Awards. We have been named one of Canada’s Top Small and Medium Employers three years in a row and three-time winner of BC’s Top Employer title. In 2023, we were recognized as a Platinum winner for Deloitte Canada's Best Managed Companies awards program - we have been recognized as a Best Managed Company since 2014 and achieved the award's Gold Standard five times.
Business Intelligence Architect
Top Benefits
About the role
Purpose The BI Architect reports into the Manager, Analytics.
The BI Architect is responsible for designing, implementing, and maintaining data structures that support organizational reporting and analysis. Working with Business Data Analysts, they will consider end user requirements in designing business intelligence solutions that will deliver key insights in an effective, automated, and reliable way.
Key Areas of Accountability
- In concert with the Business Data Analyst, identify appropriate sources of Data Warehouse data
- Build and maintain BI Architecture in relation to definitions of data content, understanding data flow between source systems and reports
- Set standards and best practices together with other architects
- Build logical data models for BI reporting and analytic solutions
- Architect, design, build and maintain solutions to meet enterprise business needs for the data warehouse and data mart environments
- Monitor and investigate new versions, technologies and techniques as well as advise management on adoption strategies.
- Ensure that BI Sprint solution delivery is adhering to architecture and development standards
- Implementation of Microsoft Power BI data models
- Develop, document and execute test plans
- Resolve issues and inconsistencies in the data
- Searching for causes of incompatibility between the warehouse and other systems
- Collaborate with IT to tune the analytics environment for optimal performance
Qualifications Education / Certifications / Licenses
-
Bachelor’s Degree in technical or business discipline or equivalent experience
-
Microsoft Power BI certification
Experience
- 6+ years of overall experience within the Business Intelligence/Data Warehousing space
- Advanced experience with Microsoft Power BI, SQL Server and SSIS
- Experience with data modeling and metadata management
- Experience defining data and user class security for reports and packages
- Experience translating business requirements into functional requirements, and translating those into reporting objects and reporting data requirements
- Experience in design patterns, development methodologies, delivery models etc.
- Solid experience in BI and Data Warehousing concepts
- Knowledge of IT concepts, strategies, and methodologies, architectures, and technical standards
- Knowledgeable in new and emerging business intelligence technologies
- Understanding of Salesforce Data Model a strong asset
- Travel and Hospitality Industry experience an asset
Skills
- Strong communication skills and interpersonal skills
- Responsive with a high sense of urgency
- Excellent analytical and problem-solving skills
- Ability to manage multiple conflicting priorities, reprioritize tasks, work independently and meet deadlines
- Ability to prepare and deliver comprehensive, clear, and professional documentation.
Compensation
- The base salary offered for this role is $82,000 to $102,000 per annum and can vary based on job-related expertise, qualifications, experience and internal equity.
- Eligible for Armstrong Collective’s discretionary bonus program
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:
- Medical, Dental, Vision, Life Insurance
- Short term disability, long term disability benefits
- Travel emergency assistance
- Vacation time and sick time
- Up to 5% RRSP and/or TSFA match
- Two complimentary annual train tickets after first year of employment
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.
Please ensure to opt-in for text messages when you apply in order to receive interview updates.
About Rocky Mountaineer
Our reason for working at Rocky Mountaineer is simple – to be the creators of life changing experiences, not just for our guests, but also for our employees. Join us at Rocky Mountaineer and build your career alongside an incredibly talented global team of passionate, energetic, diverse, and fun individuals who have helped to position us as the world-renowned leader in luxury train travel.
With rail routes operating in Western Canada and the American Southwest, Rocky Mountaineer’s team stretches the globe with employees in Canada (BC, AB, ON, QC), the USA, the UK, Australia and New Zealand.
Rocky Mountaineer has received numerous international awards and accolades. We have won thirteen World Travel Awards throughout our history; we were named Best Sustainable Train in 2021 in the Lonely Planet's Best in Travel awards; and are three-time winner of the Best Rail Company category at the Globe Travel Awards. We have been named one of Canada’s Top Small and Medium Employers three years in a row and three-time winner of BC’s Top Employer title. In 2023, we were recognized as a Platinum winner for Deloitte Canada's Best Managed Companies awards program - we have been recognized as a Best Managed Company since 2014 and achieved the award's Gold Standard five times.