BI Solutions Architect – SQL & Power BI

NTT DATA North America; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

NTT DATA North America is seeking a senior BI lead to define and execute the BI strategy, roadmap, and governance. You will oversee data architecture, ETL/ELT, data warehouse, semantic layer, and visualization using SSIS/SQL Server and Power BI/SSRS.

You will lead a BI team, mentor staff, and partner with senior stakeholders to translate requirements into KPI scorecards and dashboards, ensuring data quality and secure access.

Qualifications

• Bachelor's degree in CS/Engineering or related field.
• Certifications in database management or data governance preferred.
• Experience delivering BI solutions across data ingestion, warehousing, and visualization.

Responsibilities

• Define and execute the BI roadmap aligned to business goals and client commitments.
• Design scalable BI solutions across ingestion, ETL/ELT, data warehouse, semantic layer, and visualization.
• Lead Power BI/SSRS dashboard and report delivery with strong storytelling and executive-readiness.
• Engage senior stakeholders to capture requirements and translate them into KPI scorecards and dashboards.
• Establish reporting standards and data quality controls to ensure trust in enterprise dashboards.

Skills

Leadership

Stakeholder management

Data visualization

Education

Bachelors Degree in Computer Science or Engineering

Certifications in database management

Tools

SSIS/SQL Server

Power BI/SSRS

Job description

NTT DATA North America is seeking a senior BI lead to define and execute the BI strategy, roadmap, and governance. You will oversee data architecture, ETL/ELT, data warehouse, semantic layer, and visualization using SSIS/SQL Server and Power BI/SSRS.

You will lead a BI team, mentor staff, and partner with senior stakeholders to translate requirements into KPI scorecards and dashboards, ensuring data quality and secure access.