About NorthlandRecognized throughout Canada as one of the most trusted names in hotels, restaurants, and sports & entertainment. Northland Properties Corporation is the force behind such brands as Sandman Hotel Group, The Sutton Place Hotels, Moxie's Grill & Bar, Chop Steakhouse & Bar, Denny's Restaurants, the Dallas Stars, Grouse Mountain, Revelstoke Mountain Resort, and Northland Asset Management Company. Business Challenge As Northland continues to rapidly expand its business across Canada, the US, and the UK, the company invests in cutting-edge technology to build a more customized and localized experience for its target markets. Technology and Marketing teams are spearheading initiatives such as a new eCommerce platform, Data Lake, CRM & ERP, along with other future-focused Hotel and Restaurant technologies. Opportunity Northland is looking for a Data Engineer to manage existing data pipelines & repositories and support various enterprise project data needs. They will need to provide infrastructure support and management for both on-premises and cloud-based database systems. They will be required to develop, manage and support ETL processes with a keen eye on the performance and reliability of that information. May be required to assist with end-user reporting needs from time to time.This position is based in Vancouver, Canada and will report to the Manager, Data & Analytics. They will work closely with the IT, Finance, Marketing, and other internal departments to power insight and provide meaningful data to enable consistently informed management decisions.ResponsibilitiesProvide day-to-day management and support of the data warehouse systems and troubleshoot existing procedures and processes to optimize for the complete system potentialEnhance data warehouse process models in Snowflake, including architecture, security, modelling and integration from other systems, such as food and beverage, property management systems, central reservation systems, and other third-party partners.Work closely with data consumers within the business and other engineers to gather data requirements, create effective data workflows and ensure data is optimized for reporting & integration Analyze business requirements for reporting and analysis and translate the emanating results into technical data design documentsUtilizing Azure Data Factory, Data bricks, python and other related technologies, create and maintain data pipelines from various source systems.Design, Develop, document and maintain custom workflows, actions and triggers using Microsoft Power Automate platformProvide guidance and assistance for data visualization and report generation, specifically with visual data modelling tools such as Power BIImplementing data validation and cleansing procedures that will ensure and report the quality, integrity, and dependability of the data.Implement and manage data solutions in Microsoft Business intelligence stack using SSIS, SSAS and SSRSCreate plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.Create supporting documentation, such as metadata and diagrams of entity relationships, integration pipelines, business processes, and process flow.Manages the metadata repository, including approval workflows, data definitions, technical definitions, classifications, specifications, and data systems. Skills & Qualifications Bachelor's degree in Computer Science, Data Science, Information Technology, Information Systems or related field, or equivalent work experienceMinimum two years' experience in Snowflake, SQL server coding, SQL server database administration, and data warehouse development and architecture, preferably on the Microsoft Azure platformDemonstratable understanding of dimensional modeling as well as other data warehousing techniquesIn-depth understanding of Microsoft Power BI ecosystem, Microsoft BI stack (SSIS, SSRS, SSAS) and dimensional data modellingStrong ability to draft, analyze and debug SQL queries and be proficient in scripting languages such as Python, C Sharp, Perl, and othersFamiliar with ETL (Extraction, Transformation, and Load), data warehousing, and data visualization design principlesHands-on physical and logical database designing experienceCreative thinker with excellent analytical thinking, problem-solving skills, and attention to detailAble to multi-task and prioritize workloadDeep passion for data analytic technologies as well as analytical and dimensional modellingStrong communication skills with the ability to present information to technical and non-technical stakeholdersExperience in hospitality and/or travel industry preferred SUMMATION:Submission of resume does not guarantee an interview or an actual transfer. Qualified applicants are encouraged to apply, provided they meet the minimal requirements of the applicable skills required.You must be legally entitled to work in Canada to apply as the employer does not have a Labour Market Impact Assessment (LMIA) that would support a foreign worker.**Applications will not be accepted via email or in person.**We thank all applicants for their interest in Career opportunities, however, only those applicants we wish to interview will receive a reply to their application.****ABSOLUTELY NO PHONE CALLS PLEASE**
