Specialist, Business Intelligence

Defence Construction Canada; Ottawa; Hybrid; CAD 109,000 - 142,000; Full time

Job summary

Defence Construction Canada (DCC) seeks a Specialist, Business Intelligence to lead the development and improvement of BI services across national programs. You will establish policies, training, and guidance to support consistent reporting and analytics across regions.

Responsibilities include managing data governance, risk, and performance indicators while coaching BI practitioners and collaborating with Client-Partners and stakeholders to strengthen decision making.

Qualifications

• Minimum: university degree in information systems, computer science, data analytics or data science, business analytics, engineering or mathematics with eight years’ relevant experience, or the equivalent.
• Preferred: Microsoft certifications in Power BI, MS Fabric, SQL and database design, data warehousing, and Azure data services.

Responsibilities

• Develop BI policies, procedures, tools and guidance materials for the service line, and participate in national calls and meetings to ensure consistent, effective service delivery
• Design and sustain delegated signing authority training and a continuous learning program for BI practitioners
• Support national quality management activities for the service line, including implementing and communicating quality assurance processes, ensuring the quality of deliverables and services, and conducting quality verifications to assess compliance with the service line’s quality management system
• Assist in managing risks associated with BI practices and ensure DCC complies with various government policies and best practices
• Provide coaching, training, and guidance to BI and service line leaders and staff, including organizing national service line meetings, delivering presentations, offering one‑on‑one coaching, and developing training tools to build consistent national capacity
• Develop and implement key national service line initiatives, including establishing data management best practices, and supporting the national service line business plan, and budgeting and planning activities
• Establish, communicate, monitor, and meet national service line performance indicators
• Develop and maintain effective relationships within DCC, and with industry, the Client-Partners and/or stakeholders
• Ensure quality standards are met, in line with corporate and Client-Partner expectations

Skills

Data analytics

SQL

Power BI

Azure data services

Governance & security

Microsoft 365 tools

Report development

Policy development

Education

University degree in information systems, computer science, data analytics or data science, business analytics, engineering or mathematics

Microsoft certifications in Power BI, MS Fabric, SQL and database design, data warehousing, and Azure data services (preferred)

Tools

Power BI

MS Fabric

SQL

Azure

SharePoint

Power Automate

MS Teams

Job description

Who Can Apply?

Internal (DCC Employees) and External (General Public)

Salary Range

$109,219 - $141,984

Employment Status

Continuing

Flexible Work Option

Hybrid (2 days/week)

Security Level

Reliability

Language Requirement

Bilingual Preferred

Closing Date

30/10/2026

Country

Canada

The Specialist, Business Intelligence, develops, sustains, and improves the Project and Program Management service line’s business intelligence (BI) activities, establishing policies, procedures, tools, training, and guidance that support consistent and effective service delivery. The incumbent supports national quality management activities, defines data management best practices, develops performance indicators, and provides technical advice, coaching, and support to regional service line leaders and BI practitioners. The Specialist also helps manage risk, ensures alignment of service line business intelligence activities with government policies and Client-Partner expectations, and promotes collaboration across DCC to improve reporting, analytics, and decision-making capabilities.

KEY AND PERIODIC ACTIVITIES

Primary

• Develop BI policies, procedures, tools and guidance materials for the service line, and participate in national calls and meetings to ensure consistent, effective service delivery
• Design and sustain delegated signing authority training and a continuous learning program for BI practitioners
• Support national quality management activities for the service line, including implementing and communicating quality assurance processes, ensuring the quality of deliverables and services, and conducting quality verifications to assess compliance with the service line’s quality management system
• Assist in managing risks associated with BI practices and ensure DCC complies with various government policies and best practices
• Provide coaching, training, and guidance to BI and service line leaders and staff, including organizing national service line meetings, delivering presentations, offering one‑on‑one coaching, and developing training tools to build consistent national capacity
• Develop and implement key national service line initiatives, including establishing data management best practices, and supporting the national service line business plan, and budgeting and planning activities
• Establish, communicate, monitor, and meet national service line performance indicators
• Develop and maintain effective relationships within DCC, and with industry, the Client-Partners and/or stakeholders
• Ensure quality standards are met, in line with corporate and Client-Partner expectations

Other

• Provide technical support to regional service line leaders on the planning and implementation of national service line initiatives
• Manage risk
• Other duties as assigned

Skills

General and Specific Knowledge

• Data fundamentals, analytics, reporting, and governance
• SQL, data transformation logic, basic scripting
• Power BI, Power BI Service, M365 data sources, MS Fabric, and Azure integration
• Security, compliance, and access, including identity and access, data protection, and governance
• MS Teams, SharePoint, Power Automate, and Artificial Intelligence
• DCC and Client-Partner processes and procedures
• Government policies, procedures, and external reporting requirements
• Experience with developing policies and guidance documents

Formal Education And/or Certifications(s) And Experience

• Minimum: university degree in information systems, computer science, data analytics or data science, business analytics, engineering or mathematics with eight years’ relevant experience, or the equivalent
• Preferred: additional technical specialization and/or Microsoft certifications in Power BI, MS Fabric, SQL and database design, data warehousing, and Azure data services

Abilities

• Use applicable computer software and operating systems
• Write proposals, technical texts, and reports
• Resolve complex problems with multiple stakeholders
• Apply project, program, and risk management principles
• Demonstrate business acumen, leadership, and human resources management skills
• Read and write complex technical documents
• Demonstrate proficiency in both official languages (reading, writing and oral proficiency; mandatory)

DEVELOPMENT AND LEADERSHIP

• Provide functional advice and guidance to employees and Client-Partners
• Lead project teams and collaborate with others nationally

WORKING CONDITIONS

• Typical office environment with routine travel

Check Out Your Benefits

Working with us offers excellent opportunities for growth and advancement—and entitles you to one of the job market’s best benefits packages valued at between 25 and 30% of your salary.

Your Package Includes

Health and Wellness

• 100% employer-paid annual sick leave, and health and dental premiums
• $400 wellness allowance to help cover expenses such as a gym membership
• $2,500 for mental health services on top of regular $2,500 paramedical coverage
• Telus Virtual Health Care and $750 Health Care Spending Account for some expenses not covered under provincial plans

Home and Family

• Life, accidental-death, and short-term disability insurance
• Enhanced inConfidence employee and family assistance program
• Maternity and parental leave top-up plan to 93% of regular gross earnings for up to 37 weeks
• Flexible workplace options, including $400 allowance every two years, to support working from home

Leave and Retirement

• Public-service pension
• Comprehensive vacation and other paid-leave plans, along with enhanced travel benefits coverage

To begin a career with Defence Construction Canada (DCC), you must be a Canadian Citizen or a permanent resident of Canada. As a condition of employment with DCC, a minimum reliability security status clearance is required and some roles may require secret security status clearance.

DCC is responsible for the Personnel Security Clearance process . Typically to be eligible for a "Reliability" clearance, you must have five years of verifiable background information and to be eligible for a "Secret" clearance, you must have 10 years of verifiable background information. The process usually involves reference inquiries, verification of qualifications, criminal records checks, and credit checks (as required) and may require fingerprints. For more information about obtaining a security clearance, please review the Standard on Security Screening .

Required

The appropriate security clearance is a condition of employment and it is the candidate’s or employee’s responsibility to ensure, they are able to obtain and maintain their required security level clearance to begin or continue their employment with DCC. Failure to obtain or maintain, the appropriate level of security clearance means either the candidate or employee will not receive a job offer, the conditional offer will be rendered null and void or their employment will be terminated with cause. A thorough security clearance process will be applied to all candidates or employees considered for an appointment; this process includes inquiries, verifications and assessments regarding matters such as, but not limited to:

• criminal record checks
• reference checks
• previous employment
• open source checks
• credit/financial status

DCC's Code of Business Conduct (Code) is a condition of employment. It serves to enhance public confidence in the integrity of DCC Employees and provides clarity to Employees on a number of issues, including real or perceived conflicts of interest. Before applying to this (or any) position at DCC, candidates shall familiarize themselves with the Code, because new employees are required to certify that they have read, understood, and agreed to observe the Code upon commencing work at DCC. Employees are further required to review their obligations under the Code and notify the President's Office of any changes in their circumstances at the earliest possible opportunity, and to complete the Annual Update once a year.

Be part of a diverse and inclusive workplace!

Roles at DCC will require security at various levels including Reliability, Secret, Top Secret and for Canadian Eyes Only (proof of Citizenship required). While we welcome applications to our roles who are not Canadian citizens who are eligible to work in Canada and have at least 5 years of verifiable background information, selection will depend on the specific role’s requirements.

At DCC, we are committed to ensuring everyone has a voice and can be their authentic selves in our workplace. We actively encourage applications from all, including but not limited to, women, Indigenous Peoples, persons with disabilities, visible minorities and members of the LGBTQ2+ community.

DCC’s goal is to provide barrier-free access to employment opportunities and workspaces for employees and candidates. If you require an accommodation for the recruitment/interview process (including alternate formats of materials, accessible meeting rooms or other accommodations), please let us know and we will work with you to meet your needs. Should you require accommodation, please email [e-mail] .