Specialist, Business Intelligence

Defence Construction Canada; Ottawa; Presencial; CAD 90 000 - 130 000; Tempo integral

Resumo da oferta

Defence Construction Canada seeks a Specialist, Business Intelligence to develop and sustain BI activities across the service line, establishing policies, tools, training, and guidance for consistent service delivery. You will support national quality management, define data management best practices, and provide expert coaching to regional BI practitioners.

You will help manage risk, align BI activities with government policies and Client-Partner expectations, and promote collaboration to

Qualificações

• University degree in a relevant field with 8 years’ experience or equivalent.
• Preferred Microsoft certifications in Power BI, MS Fabric, SQL and data warehousing.
• Experience in BI policy creation and guidance documents.

Responsabilidades

• Develop BI policies, procedures, tools and guidance materials for the service line.
• Design and deliver training and continuous learning for BI practitioners.
• Support national quality management activities and ensure deliverable quality.
• Provide coaching to BI leaders and staff across regions.
• Establish data management practices and monitor national performance indicators.
• Foster relationships with Client-Partners and stakeholders.

Conhecimentos

Data analytics

Reporting

Governance

Formação académica

University degree in information systems, computer science, data analytics or data science, business analytics, engineering or mathematics with eight years’ relevant experience

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

Ferramentas

Power BI

MS Fabric

Azure data services

SQL

Power Automate

Descrição da oferta de emprego

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

The duties and responsibilities listed below are representative but not all-inclusive:

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