BI Engineer

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 company’s 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 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 Azure’s Data Platform 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 Manager, BI 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.

What You’ll Be Doing

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 while using DAX as needed

• Develop complex and high performing query to retrieve data from the data warehouse. Design and develop complex, high-performance queries to retrieve and manipulate data from the data warehouse

• Work with business users and rapidly proto-typing reports to involve end-user inputs and feedback. Collaborate with business users to rapidly prototype and refine reports, ensuring their alignment with end-user needs.

• Develop, and support analytical databases in a tabular model, including features for data access and data security. Develop and support tabular models and analytical databases, focusing on performance, security, and accessibility.

• Establish governance, best practices for reporting and dashboard creation. Ensure governance and best practices for reporting and dashboard creation, with a focus on usability and consistency

• Partner with Data Engineers, work collaboratively to develop and enhance of ETL workflow in Azure

• In collaboration with data architect, work collaboratively to design data architecture and data modeling. Collaborate with Data Architects to design and implement data models that support business needs.

• 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. Provide technical support and guidance to BI consumers across the organization.

• 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 and Power BI, with expertise in Dimensional models and DAX language as needed.

• 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.

Who You Are

• 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

• Strong communication and support skills, providing technical guidance to business users.

• Ability to balance technical and business requirements to deliver solutions that meet organizational needs.

• Demonstrated time, task and project management skills including planning, organizing and managing resources

• Ability to work on several un-related projects concurrently

• BI Engineering in Microsoft Azure Environment + Toolsets Expertise in Microsoft Azure BI stack (ADLS, ADF, Synapse, AAS, PowerBI, Cosmos DB, FunctionApps, Logic Apps etc)

• Strong 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

• Microsoft Visio

• Microsoft Office Suite, very strong Excel

What You Bring

• 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.

• 2-3 years’ experience in Visualization and Analytics within Azure environments using Azure Databricks, Delta Lake, Azure Data Lake, Synapse Analytics, Analysis Services and Power BI

• Very good understanding of data warehousing concepts, data modeling concepts, performance improvement.

• Desired to have 1-2 years’ experience in AI/ML projects and implementations

• University or higher degree in Engineering, Mathematics, Information Systems, Computer Science or Technology.

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.