Data Analytics Consultant

About the role

Location and schedule

• Work mode is remote; the stated location is Canada.
• Monday to Friday, 40 hours per week, 8:30 a.m. to 5:00 p.m.

What you will do

• Architect, design, and develop analytical data solutions from raw data sources through the Power BI front end.
• Provide oversight in data modeling and database design; define BI framework models, semantic layers, and metadata repositories.
• Gather requirements with business and project teams and interact with client and management stakeholders.
• Develop and manage end-user training and documentation for the BI presentation layer; prepare technical documentation and status reports.
• Support proposals and client presentations and estimate effort for data engineering and related engagements.

What we are looking for

• 5+ years of hands-on Microsoft data stack experience, including SQL Server, data warehousing, and Microsoft Fabric or Databricks.
• 3+ years of hands-on Microsoft BI stack experience, including Power BI, SSAS, SSRS, and SSIS.
• Proficiency in at least one listed development and administration area spanning data integration, architecture, modeling, database design, warehousing, ETL, performance tuning, or analytics platforms.
• Strong Star-schema modeling and programming skills in T-SQL, Spark technologies, DAX, and Power Query.
• Experience creating Power BI visual reports, custom visuals, dashboards, and KPI scorecards.
• Ability to implement row-level security and understand application security layers across SQL Server, Azure, Microsoft Fabric, and Power BI.
• Foundational knowledge of metadata management, master data management, data governance, analytics, and AI fundamentals.
• Strong written and verbal communication skills.
• Required certifications: Microsoft Certified: Fabric Analytics Engineer Associate and Microsoft Certified: Fabric Data Engineer Associate.

Helpful certifications

• Certifications described as helpful include Azure Fundamentals, Azure Data Fundamentals, Azure AI Fundamentals, Security, Compliance, and Identity Fundamentals, Azure AI Engineer Associate, Azure Data Scientist Associate, Azure Databricks Data Engineer Associate, and SQL AI Developer Associate.

Benefits

• Benefits package, dynamic work environment, corporate gym discounts, wellness day, and opportunities for growth and training.