Data Analytics Consultant

MSP Corp; Calgary; Remote; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Benefits package

Wellness day

Growth and training opportunities

Job summary

MSP Corp is seeking a Data Analytics Consultant to join our West team and work remotely from Canada. You will architect and deliver end-to-end analytics solutions using Power BI and the Microsoft Data Stack, collaborating with stakeholders across business and technology.

The role focuses on data modeling, BI framework design, governance, and building visual reports with Power BI. Strong SQL, Spark, DAX, and ETL skills are required, along with Microsoft Fabric certifications.

Qualifications

• 5+ years hands-on experience with Microsoft Data Stack (SQL Server, data warehousing, Fabric/Databricks).
• 3+ years hands-on experience in Microsoft BI Stack (Power BI, SSAS, SSRS, SSIS).
• Experience in backend data integration, dimensional modeling, ETL, and performance tuning.
• Proficient in T-SQL, Spark, DAX, and Power Query.
• Strong analytical thinking and effective communication skills.

Responsibilities

• Architect, design, and develop end to end analytical data solutions from source raw data to Power BI front end
• Providing oversight and expertise in Data Modeling and Database Design
• Working with business/project teams to understand requirements
• Defining BI framework model, semantic layers and Metadata repositories to support reporting
• Developing and managing BI end user presentation layer training and documentation
• Technical documentation
• Supporting business development efforts (proposals and client presentations)
• Estimating effort for development and support engagements in Data Engineering
• Interacting with client and management stakeholders to get work completed
• You would represent the company in the market and reflect core values

Skills

Data modeling

ETL development

AI fundamentals

Analytical thinking

Strong communication

Tools

Power BI

SSAS

SSRS

SSIS

SQL Server

ADF

Spark

Fabric Analytics Engineer

Fabric Data Engineer

Job description

Ready to take your career to the next level? Invest in yourself!MSP Corp is a dynamic and evolving organization. Our team is energetic and multidisciplinary, performing at the highest levels. We thrive on the diversity of our team and believe that any candidate could be the talent to take us to the next level. We drive technology and performance by providing powerful toolsets, business support and professional services. Our team provides complete, turn-key solutions with one goal in mind — to ensure that we can deliver 100% any day, any time.

As we continue to grow, we are seeking a Data Analytics Consultantto join our West team.

About the Role

As an experienced Data Analytics Consultant this individual will work as part of our data analytics team, supporting clients with requirements gathering, prototyping, development, and support. Client scenarios range in complexity. This individual must have a good blend of people, functional, and technical skills for cross-team collaboration and support. We are looking for individuals who will interface with multiple business and technology stakeholders and teams to evaluate and improve existing processes using multiple technology platforms.

• Location: Canada
• Schedule: Monday to Friday, 40 hours per week, 8:30 a.m. – 5:00 p.m.
• Work Mode: Remote

What You Will Do

• Architecting, designing, and developing end to end analytical data solutions from source raw data all the way to Power BI front end
• Providing oversight and expertise in Data Modeling and Database Design
• Working with business/project team members to understand the requirements
• Defining BI framework model, semantic layers and Metadata repositories to support reporting and administration
• Developing and managing BI end user presentation layer training and documentation.
• Technical documentation
• Supporting business development efforts (proposals and client presentations)
• Estimating effort for development and support engagements in Data Engineering and related technologies
• Interacting with various client and management stake holders to get the work completed
• You would represent the company in the market and must reflect the core values of the company which include:
• Continuous improvement as a way of life
• Fair and generous relationships with our people and customers
• Certifications helpful to role:
• Microsoft Certified: Security, Compliance, and Identity Fundamentals

What We Are Looking For

• 5+ years hands‑on experience in Microsoft Data Stack incl. SQL Server, data warehousing, MS Fabric/Data Bricks
• 3+ years hands‑on experience in Microsoft BI Stack incl. Power BI, SSAS, SSRS, SSIS
• Proficiency in the development and administration of at least one of the following areas:
• Back end data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development (e.g. ADF), and performance tuning, front-end reporting and analytics platforms including OLAP cube design, tabular data modeling.
• Strong Programming skills in T‑SQL, Spark (PySpark, SQL, Scala, etc), DAX, Power Query
• Strong analytical thinking for translating data into informative visuals and reports
• Experience developing visual reports including custom visuals, dashboards and KPI scorecards using Power BI
• The ability to implement row level security on data and have an understanding of application security layer models in the data platforms of SQL Server, Azure, MS Fabric and Power BI
• Foundational knowledge of the following areas: Metadata Management; Master Data Management; Data Governance; Data Analytics
• Good understanding of AI fundamentals.
• Strong written and verbal communications skills
• Certifications required:
• -Microsoft Certified: Fabric Analytics Engineer Associate
• -Microsoft Certified: Fabric Data Engineer Associate

Why Work at MSP Corp

• Benefits package.
• Dynamic work environment.
• Wellness day.
• Opportunities for growth and training.

Diversity, Equity, and Inclusion

At MSP Corp, we believe that diversity, equity, and inclusion are essential for fostering a healthy and innovative work environment. We are committed to creating a workplace where everyone, regardless of age, gender, ethnicity, sexual orientation, ability, or any other characteristic, feels valued and respected. We encourage applications from individuals of diverse backgrounds and perspectives and ensure a fair and inclusive recruitment process.

Thank you for your interest in this opportunity. We will only contact candidates whose profile closely matches the job requirements.