Share this Job

Microsoft Data Analytics Consultant

Apply now »

Date: Sep 10, 2022

Location: Victoria, BC, CA

Company: NTT DATA Services

NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Microsoft Data Analytics Consultant to join our team in Victoria, British Columbia (CA-BC), Canada (CA).

In the role of Microsoft Data Analytics Consultant, you will provide industry best practices to support our Canadian clients with deliverables that are focused on the Microsoft Analytics technology stack.  You are adept at the entire software development lifecycle from facilitating requirements gathering sessions, creating solution designs (including ETL, semantic layer, and reporting), and managing deployments into multiple environments. You are experienced at developing solutions for on-premises solutions using tools such as SSIS, SSAS (Tabular), SSRS, and Power BI. Your T-SQL skills are intermediate to senior level.


Basic Qualifications

  • Possess a college diploma or university degree focused on computer science, or equivalent experience
  • Minimum six (6) years’ experience working with on-premises Microsoft data warehouse solutions
  • Minimum five (5) years’ experience designing dimensional models (i.e. Kimball methodology)
  • Comfortable working in a hybrid or remote work scenario


Mandatory Qualifications

  • Experience working with SQL Server (2019 preferred), including DML and DDL
  • Six (6) years’ experience working with T-SQL
  • Five (5) years’ experience developing ETL solutions using a combination of SSIS and SSMS (stored procedures, functions, etc.)
  • Five (5) years’ experience developing Semantic Layers utilizing tools such as SSAS Tabular models, and/or Power BI data sets
  • Five (5) years’ experience designing and developing reporting solutions for on-premises architectures utilizing tools such as SSRS and Power BI


Nice to Have Qualifications

  • Fundamental understanding of the Power BI administration and governance framework
  • Experience integrating analytic content into SharePoint, specifically Power BI, Excel, and SSRS
  • Microsoft Azure cloud experience in particular Azure Data Factory, Azure Data Lake, Azure SQL, Azure Analysis Services and Azure Synapse Analytics

About NTT DATA Services

NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.

NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.

Job Segment: Cloud, Database, Analytics, Computer Science, SQL, Technology, Management