Job Description

About Four Seasons:
Four Seasons is powered by our people. We are a collective of individuals who crave to become better, to push ourselves to new heights and to treat each other as we wish to be treated in return. Our team members around the world create amazing experiences for our guests, residents, and partners through a commitment to luxury with genuine heart. We know that the best way to enable our people to deliver these exceptional guest experiences is through a world-class employee experience and company culture.
At Four Seasons, we believe in recognizing a familiar face, welcoming a new one and treating everyone we meet the way we would want to be treated ourselves. Whether you work with us, stay with us, live with us or discover with us, we believe our purpose is to create impressions that will stay with you for a lifetime. It comes from our belief that life is richer when we truly connect to the people and the world around us.
About the location: Four Seasons Hotels and Resorts is a global, luxury hotel management company. We manage over 120 hotels and resorts and 50 private residences in 47 countries around the world and growing. Central to Four Seasons employee experience and social impact programming is the companys commitment to supporting cancer research, and the advancement of diversity, inclusion, equality and belonging at Four Seasons corporate offices and properties worldwide. At Four Seasons, we are powered by people and our culture enables everything we do.
Four Seasons Hotels and Resorts is a global, luxury hotel management company. We manage over 120 hotels and resorts and 50 private residences in 47 countries around the world and growing. At Four Seasons, we are powered by people and our culture enables everything we do.
Central to Four Seasons employee experience and social impact programming is the companys commitment to supporting cancer research, and the advancement of diversity, inclusion, equality and belonging at Four Seasons corporate offices and properties worldwide. At Four Seasons, we are powered by people and our culture enables everything we do.
The BI Data Engineer is a technical leader in our Data & Analytics commercial data engineering team. Responsibilities include designing, building, optimizing, and maintaining experiments, prototypes and products across Four Seasons Microsoft Azures Data Platform including AAS and PowerBI.
The Engineer will be a valued member of an internal Data Engineering capability working together to discover to define requirements, use cases and outcomes.
The candidate is capable of working with all levels of the organization with an ability to understand and translate institutional knowledge into technical solutions. Strong service, communication and problem-solving skills are key.
This role is based in Four Seasons Hotels and Resorts, Toronto Corporate Office, reporting to the Senior Director, Data Engineering. This role involves interactions with internal executive stakeholders , project sponsors, technical operations and development teams, Four Seasons IT, end-user contracts, and product users. Externally, the role will interact with various Four Seasons partners and data solution providers, Microsoft, and source data providers.
Key Activities
BI Engineering
As an excellent communicator and facilitator, you will interview users and pull business needs and translate requirements to represent report functionalities
Design complex and interactive reports in Power BI to act like sophisticated applications with interactive visuals to service data using DAX as needed
Develop complex and high performing query to retrieve data from the data warehouse
Work with business users and rapidly proto-typing reports to involve end-user inputs and feedback
Develop, and support analytical databases in a tabular model, including features for data access and data security
Establish governance, best practices for reporting and dashboard creation
In collaboration with Data Engineers, work collaboratively to develop and enhancement of ETL workflow in Azure
In collaboration with data architect, work collaboratively to design data architecture and data modeling
Automate continuous build and deployment of data mart, ETL workflow and reports
Work closely with business analysts, SMEs on project and production support to troubleshoot and debug issues
Thinking creatively to design solutions, addressing both business and technical aspects, with a forward-thinking approach to best accommodate future opportunities
Collaborate with cross functional team to understand business issues and identify opportunities to turn data into business insights using reporting tools or other self-service analytics
Acts as BI SME for all BI consumers to provide technical support of tools and technical architecture
Participate to convert legacy reporting platform into future state data and analytics platform
Make contributions in the development of test plans, test scripts, and perform test execution
Initiate knowledge dissemination of design, coding, and analysis techniques with other team members in collaborative manner
Ensure that appropriate application and design documentation is created and kept up to date
Monitors system performance, implements changes to optimize performance
Incorporate operational risk and systems performance management in all initiatives
Design and develop Tabular models in AAS/Power BI using DAX language as needed
Adoption of best development practices for batch processing
Managing all work in Jira including but not limited to story creation, defect resolution etc
Documentation of the work in Confluence
Identifies opportunities for new architectural initiatives makes recommendations on the increasing scalability and robustness of platforms and solutions.
Expected Skills
Excellent analytical, mathematical, and creative problem-solving skills
Excellent listening, interpersonal, written, and oral communication skills
Logical and efficient, with keen attention to detail
Self-motivated and directed
Ability to effectively prioritize and execute tasks while under pressure
Able to exercise independent judgement and take action on it
Strong customer service orientation
Experience working in a team-oriented, collaborative environment
Ability to lead technical teams through outage and technical roadblock situations
Ability to prioritize competing requests for resource
Ability to translate business needs into data requirements and priorities
Ability to devise and apply logical steps to troubleshoot issues and test new development
Ability to engage in the role from multiple angles, as trainer, helpdesk support person, tester and analyst
Process-oriented capability and skills
Proven experience providing excellent customer service to internal system users
Demonstrated time, task and project management skills including planning, organizing and managing resources
Ability to work on several un-related projects concurrently
Technical Skills
Expert knowledge in BI Engineering Toolsets (PowerBI, AAS, Synapse, Cosmos DB)
Deep understanding in Microsoft Azure Environment Toolsets (ADLS, ADF, FunctionApps, Logic Apps etc)
Expert knowledge in DAX language
Expert knowledge in understanding, writing, troubleshoot, enhance, optimize the complex sql statements, stored procedures, functions and other database components.
Skilled in core data warehousing platforms
Microsoft Power BI delivery and support
Data process improvement
Working in large data sets
Confluence, Jira, TestRail
Helpdesk Tools and methods
Microsoft Visio
Microsoft Office Suite, very strong Excel
Experience, Education and Professional Qualifications
University or higher degree in Engineering, Mathematics, Information Systems, Computer Science or Technology.
5+ years of IT industry experience with the data related projects.
Minimum 4+ years of experience in data modeling, datawarehouse design and development, reports, dashboards development and migration related projects.
Very good understanding of data warehousing concepts, data modeling concepts, performance improvement.
2-3 years experience in Visualization and Analytics in Azure environments using Azure Databricks, Delta Lake, Azure Data Lake, Synapse Analytics, Analysis Services and Power BI
Desired to have 1-2 years experience in AI/ML projects and implementations
This role will be a Hybrid working model, which will require 3 days per week in the Four Seasons Corporate Office located at 1165 Leslie Street, Toronto, Ontario #LI-Hybrid
Four Seasons is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If contacted for an employment opportunity, please advise Human Resources if you require accommodation.