Specialist, Business Intelligence
- Ottawa, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Internal (DCC Employees) and External (General Public)
Salary Range
$109,219 - $141,984
Employment Status
Continuing
Flexible Work Option
Hybrid (2 days/week)
Term Length
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
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
- Provide technical support to regional service line leaders on the planning and implementation of national service line initiatives
- Manage risk
- Other duties as assigned
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
- 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
- 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)
- Provide functional advice and guidance to employees and Client-Partners
- Lead project teams and collaborate with others nationally
- Typical office environment with routine travel
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
- 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
- Public-service pension
- Comprehensive vacation and other paid-leave plans, along with enhanced travel benefits coverage
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
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 careers@dcc-cdc.gc.ca .
More about this job
Responsibilities
Develop and maintain business intelligence policies, tools, training, data management practices, and performance indicators for the national Project and Program Management service line. Support quality management, risk and policy compliance, and provide technical guidance and coaching to regional leaders and practitioners to improve reporting, analytics, and decision-making.
Requirements
A university degree in information systems, computer science, data analytics or data science, business analytics, engineering, or mathematics, plus at least eight years of relevant experience, or equivalent, is required. The role requires proficiency in both official languages and relevant knowledge of BI, SQL, Power BI, Microsoft Fabric, Azure, data governance, and security; Microsoft certifications and additional technical specialization are preferred.
Skills
- Business Intelligence
- Data Analytics
- Data Governance
- SQL
- Data Transformation
- Scripting
- Power BI
- Microsoft Fabric
- Azure Integration
- Data Protection
- Identity and Access Management
- Microsoft 365
- Power Automate
- Risk Management
- Quality Assurance
- Training and Coaching
Benefits
- Employer-Paid Sick Leave
- Health Insurance
- Dental Insurance
- Wellness Allowance
- Mental Health Coverage
- Paramedical Coverage
- Virtual Health Care
- Health Care Spending Account
- Life Insurance
- Short-Term Disability Insurance
- Employee and Family Assistance Program
- Maternity and Parental Leave Top-Up
- Flexible Workplace Options
- Home Office Allowance
- Public-Service Pension
- Paid Vacation
- Paid Leave
- Travel Benefits
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Management & Leadership
- Government & Public Sector
- Construction
Keywords
- Business Intelligence
- Project and Program Management
- Data Fundamentals
- Data Analytics
- Reporting
- Data Governance
- SQL
- Data Transformation Logic
- Basic Scripting
- Power BI
- Power BI Service
- Microsoft 365 Data Sources
- Microsoft Fabric
- Azure Integration
- Identity and Access Management
- Data Protection
- Microsoft Teams
- SharePoint
- Power Automate
- Artificial Intelligence
- Quality Management
- Quality Assurance
- Performance Indicators
- Risk Management
- Government Policies
- Client-Partner Expectations
- Data Warehousing
- Database Design
- Azure Data Services
- Microsoft Certifications