MS-SQL Data Warehouse Analyst

Build data warehouse structures and enterprise reporting solutions with Keyano College’s Information Technology Services Department. Work on campus in Fort McMurray, Alberta, with MS-SQL and ETL.

As a Database Analyst, you will develop reports, datasets, ETL processes, and data solutions for business operations. The position works with the ERP team on integrating on-premise and cloud-based enterprise applications. It also supports a broader data warehouse and enterprise reporting framework through modeling, migrations, and data transfers.

Key Responsibilities:

• Develop reports, datasets, ETL processes, and data solutions
• Design structures supporting business and application needs
• Plan data migrations and system integrations between platforms
• Manage database changes, testing, and quality assurance
• Provide application support for organizational databases

Requirements:

• Three-plus years developing MS-SQL queries, ETL code, and integrations
• Experience managing data warehouses and report or dashboard modeling
• Azure Data Lake or similar cloud solution experience preferred
• Programming, scripting, XML constructs, and schema competency
• Project management and data processing flowcharting experience

Apply your MS-SQL, ETL, reporting, and enterprise integration capabilities to Keyano College’s Fort McMurray operations.