Data Warehouse Specialist

MVP Talent Corp; Calgary; Hybrid; Full time

Job summary

A leading executive search agency seeks a SQL Data Warehouse Developer to remap data from Dynamics 365 into a new data lake. The role involves developing reports in Power BI, ensuring database integrity, and creating documentation for the data model. Candidates should have extensive experience with SQL Server, OLAP cubes, and Dynamics 365. This contract position offers a high likelihood of becoming permanent and is mostly remote with some in-office work preferred.

Qualifications

• 7+ years of experience in SQL Server database development and OLAP data cubes.
• Hands-on experience with Dynamics 365 and data integration capabilities.

Responsibilities

• Develop and manage data warehouses and OLAP cubes for complex data analysis.
• Conduct regular database performance tuning and troubleshooting.

Skills

SQL Server

Data Warehousing

OLAP

Power BI

Dynamics 365

Problem Analysis

Interpersonal Skills

Tools

Microsoft One Lake

SSRS

SSAS

PowerShell

VBScript

GitHub

Job description

This range is provided by MVP Talent Corp. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$93.00 / hr - CA$95.00 / hr

Direct message the job poster from MVP Talent Corp

SQL Data Warehouse Developer / BI Reports

MVP Talent Corp, a leading executive search agency, is working with one of our top clients in search of a SQL Data Warehouse Developer to remap data from Dynamics 365 into a new data lake (Microsoft OneLake). This involves mapping the current logic flow data model, cube development, and re-writing SSRS and SSAS OLAP cubes. There are up to 77 tables.

You’ll also create new reports in Power BI. Candidates should be able to work across the spectrum from writing BI reports to rewriting the data warehouse and the SSIS, SSRS, SSAS OLAP cubes. This will also include tasks like table locking, stored procedures, and documentation of the new data model.

Candidates will need to have strong knowledge of MS Dynamics, OneLake, and Power BI.

This role is critical in ensuring the integrity, performance, and security of databases while providing insightful data analysis and reporting.

MUST HAVE Qualifications :

• 7+ years of experience in SQL Server database development, data warehousing concepts, OLAP data cubes, and SSRS, SSAS
• 7+ years of work experience as a database analyst
• Hands-on experience with Dynamics 365 and its data integration capabilities
• Knowledge of OWASP best practices
• Proven experience with Power BI data for data visualization and reporting
• Superior problem analysis and problem-solving skills
• Proven interpersonal aptitude and multi-tasking ability

TYPICAL DUTIES & RESPONSIBILITIES :

• Development of ad hoc reports built in Power BI
• Develop and manage data warehouses and OLAP cubes to support complex data analysis and reporting needs
• Obtain knowledge of and develop documentation for the entire data model of these applications
• Design, implement, and maintain robust database systems using Microsoft One Lake and SQL databases
• Support end users with .XLS & VB scripts for reporting warehouse & cubes
• Ensure application changes follow incident management procedures and protocols
• Report customer feedback and participate in new feature design requirements to vendors
• Conduct regular database performance tuning and troubleshooting to resolve issues
• Apply DevOps, CI / CD, and other agile development concepts

TECHNOLOGIES USED :

• Microsoft Technologies
• Windows Server 2016, 2019
• Office 365 for Mail, SharePoint
• GitHub
• Microsoft One Lake, Power BI
• API integrations
• Dynamics 365 Finance and Operations
• PowerShell and VBScript
• Proven interpersonal aptitude and multi-tasking ability
• In-depth knowledge of data warehousing concepts and OLAP cubes
• Self-motivated and a team player

This role starts as a contract assignment with a high likelihood of becoming permanent if the contractor is interested. Duration is 6-12 months to start. This position is mostly remote, with some in-office work preferred. Candidates are strongly encouraged to be in Calgary or surrounding areas.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology, Analyst, and Engineering
• Transportation, Logistics, Supply Chain and Storage, Oil and Gas

J-18808-Ljbffr

Create a job alert for this search

Warehouse Specialist • Calgary, AB, Canada