Data Analytics Consultant
Role Overview
As an experienced Data Analytics Consultant t his 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
Key Skills for This Role
Full Job Posting
About the Role
As an experienced Data Analytics Consultant t his 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
- Status reporting
- 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: Azure Fundamentals
- Microsoft Certified: Azure Data Fundamentals
- Microsoft Certified: Azure AI Fundamentals
- Microsoft Certified: Security, Compliance, and Identity Fundamentals
- Microsoft Certified: Azure AI Engineer Associate
- Microsoft Certified: Azure Data Scientist Associate
- Azure Databricks Data Engineer Associate - Certifications
- Microsoft Certified: SQL AI Developer Associate
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 Data Modeling skills for Star-Schema
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.
Corporate gym discounts.
Wellness day.
Opportunities for growth and training.
Ready to make a difference? Join us and shape the future. Apply today!
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.
#INDhi
Requirements
- Location: Canada
- Schedule: Monday to Friday, 40 hours per week, 8:30 a.m. – 5:00 p.m.
- Work Mode: Remote
- 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 Data Modeling skills for Star-Schema
- 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
About MSP Corp
Canadian-owned managed IT, cybersecurity, cloud, and AI services provider serving businesses nationwide.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at MSP Corp
Consultant(e) Copilot IA et Power Platform
, CAN
MSP Corp recherche un(e) consultant(e) pour traduire les besoins clients en solutions d’IA et agents Microsoft Copilot. Le poste porte sur la conception, le développement et le déploiement avec Copilot Studio et Power Pl
Data Analytics Consultant
, CAN
MSP Corp is seeking an experienced Data Analytics Consultant to design, develop, and support end-to-end analytical data solutions for clients. Candidates need extensive Microsoft data and BI stack experience, strong data
Copilot AI and Power Platform Consultant
, CAN
MSP Corp is seeking a Copilot AI and Power Platform Consultant to translate client needs into AI solutions and build Copilot agents and automated workflows. The role requires implementation experience with Copilot Studio
Project Manager
, CAN
MSP Corp is seeking an IT Project Manager to deliver Microsoft-centric professional services projects on time, within scope, and on budget. The role owns project execution, governance, documentation, risk management, sta
Project Manager
, CAN
MSP Corp is seeking an IT Project Manager to deliver Microsoft-centric professional services projects on time, within scope, and on budget. The role owns project execution, governance, documentation, risk management, cli
Consultant(e) Copilot IA et Power Platform
, CAN
Data Analytics Consultant
, CAN
Copilot AI and Power Platform Consultant
, CAN
Copilot AI and Power Platform Consultant
, CAN
Enterprise Account Executive
Vancouver, CAN
Project Manager
, CAN
Project Manager
, CAN
Project Manager
, CAN