Business Intelligence Analyst, Operations

Defence Construction Canada • Ottawa, ON

3d • Onsite

About The Position

Reporting to the Manager, Operations Coordination, the Business Intelligence Analyst, Operations, provides business intelligence services to internal and external stakeholders to help advance corporate initiatives and programs. The incumbent provides technical support to senior and executive stakeholders by identifying business requirements, developing procedures to analyze various data sources, interpreting and validating data sources, recommending and communicating analyses to stakeholders, and producing analytical and visualization tools such as dashboards and reports using tools like Power BI and the broader Power Platform.

Requirements

• Best practices, methods and trends in DCC business, service lines and operations
• Strong understanding of business intelligence tools and practices, including data modelling, data visualization, and reporting development
• Familiarity with data quality, validation, and governance principles
• Project management principles
• University degree in engineering, data sciences, computer science, business, mathematics, statistics, management, accounting or related field with minimum of six years’ relevant experience, or the equivalent
• Use applicable computer software and operating systems
• Use Power Platform tools (with an emphasis on Power BI) to develop analytical and reporting solutions
• Build and optimize data models and reporting solutions for performance and reliability
• Translate business needs into technical reporting solutions and communicate insights clearly to non-technical audiences
• Apply project management techniques
• Provide advice and/or guidance to stakeholders, managers and senior management

Nice To Haves

• Experience developing dashboards and reporting solutions in a production environment
• Microsoft Power BI certification (e.g., PL-300) or equivalent experience is considered an asset

Responsibilities

• Support the Manager, Operations Coordination, in advancing corporate initiatives and programs
• Identify business intelligence requirements and establish and interpret data models to produce analytical and visualization tools (e.g., Power BI dashboards, reports, and scorecards)
• Design, develop, and maintain reporting solutions to support operational and executive decision-making
• Understand automated data sources and technologies such as EnterpriseOne, Adaptive Insights and the Defence Resource Management Information System, and integrate applicable data across multiple systems to produce analyses and visual tools
• Interpret results of completed analyses and ensure accuracy and consistency of data
• Validate data with DCC, Client-Partners and industry
• Provide insights, advice and recommendations to senior and executive stakeholders, as needed
• Develop and maintain effective relationships within DCC, and with industry, the Client-Partners and/or stakeholders
• Collaborate with stakeholders to continuously improve reporting solutions and meet evolving business needs
• Ensure quality standards are met, in line with corporate expectations
• Manage risk
• Map policies and processes for stakeholders
• Document data flows, reporting processes, and business intelligence solutions
• Provide ad hoc reporting and dashboard enhancements as required
• Other duties as assigned

Benefits

• 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 deluxe travel benefit plans

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level