Data Warehouse Developer (12 month Contract)

Administrative/Professional Burnaby, BC


Position at Corporate Office, Burnaby

Job Type: Full-Time (12 month Contract)


Who We Are

Gateway Casinos & Entertainment Limited (“Gateway”) is the largest and most diversified gaming company in Canada. Operating in British Columbia, Edmonton and Ontario, Gateway has over 6,100 employees and operates 26 gaming properties with 286 tables, over 9,800 slots, 57 restaurants and bars and 272 hotel rooms. As the selected service provider in Northern Ontario, Gateway will undertake two new planned builds in North Bay and Kenora.  Gateway is undertaking an ambitious growth strategy to dramatically improve the customer experience and attract new customers. This includes the development of proprietary casino and food and beverage brands like Match Eatery & Public House and Atlas Steak + Fish. This year Gateway is celebrating 25 years in the business of gaming and entertainment in Canada.


Why Work For Us

Gateway celebrates and empowers those employees who made it all possible. A career at Gateway means great people, a great atmosphere and career advancement opportunities across our 18 locations. Our employees thrive with ongoing training and leadership programs for all while working in an engaging and fun environment. Join us today! 


The Position

This dynamic role calls for an engaged professional with a solid track record, business acumen and problem solving skills to enhance customer loyalty.


The Data warehouse Developer is responsible for planning, designing, building, testing and maintaining the data warehouse/data analytics environment.  It is also responsible for developing the skills necessary to maintain reporting applications. This is a 12 month contract with an opportunity for a full-time position.


Key Responsibilities

  • Designs and implements necessary data warehouse changes. Solid understanding of dimension data modeling, On-line Analytical Processing (OLAP) and Extract, Transform and Load (ETL) concepts to support business definitions scalability and usability of the front end solution
  • Design, develop, and deploy ETL processes to support a variety of business needs
  • Develop detailed technical specifications and ETL documentation
  • Collaborate in planning, designing, developing and deploying new data warehouses/BI applications, and enhancements to existing applications
  • Work with the Business Analyst to identify business requirements and evaluate data availability to ensure reporting goals are achieved
  • Assist the BI Developer with data mapping from warehouse tables to the BI database layer, and from the business layer to the presentation layer


What You’ll Require

  • Experience in data warehousing environment
  • Strong knowledge of dimensional data modeling
  • Strong expertise in SQL/PLSQL
  • Ability to establish and maintain positive working relationships with colleagues and external contacts to meet operational and departmental objectives
  • Detail oriented, resourceful, and efficient
  • Strong computer skills including knowledge of word processing, spreadsheets, presentation programs, email and web browsers


What Is Next<span

Love what you see so far? For the best chance to hear from us, apply within 30 days of the posting date.

Not the right fit this time? Follow us on our careers social media pages!