You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Microsoft Data Analytics Consultant

Victoria, BC
Full Time
3 days ago
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, Data Warehouse, Database, SQL, Computer Science, Technology
Information Technology Transportation and Warehousing