Business Intelligence Analyst, Program Planning & Control

L3Harris; Golden Horseshoe; On-site; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Analyst to empower decision-making through data-driven insights. This role involves managing Engineering data, creating impactful reports, and supporting project estimations with advanced analytics tools. The ideal candidate will excel in SQL, Microsoft Excel, and Power BI, transforming complex data into actionable metrics. Join a dynamic team dedicated to innovation and excellence in the defense sector, where your contributions will directly impact national security and operational success.

Qualifications

• Practical knowledge in business analytics and reporting.
• Experience with SQL databases and data visualization.

Responsibilities

• Provide business analytics and reporting for Engineering projects.
• Develop metrics and translate business results into recommendations.

Skills

SQL Database Interaction

Microsoft Excel

Power BI

JIRA Administration

Communication Skills

Problem Solving

Education

Bachelor's Degree

Graduate Degree

Tools

Power BI

JIRA

Confluence

Job description

Business Intelligence Analyst, Program Planning & Control

L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do. Our employees are unified in a shared dedication to our customers’ mission and quest for professional growth. L3Harris provides an inclusive, engaging environment designed to empower employees and promote work-life success. Fundamental to our culture is an unwavering focus on values, dedication to our communities, and commitment to excellence in everything we do.

L3Harris Technologies is the Trusted Disruptor in the defense industry. With customers’ mission-critical needs always in mind, our employees deliver end-to-end technology solutions connecting the space, air, land, sea and cyber domains in the interest of national security.

Business Intelligence Analyst, Program Planning & Control

Reference #23719

About L3HARRIS WESCAM

As a subsidiary of L3Harris Technologies and within the Integrated Mission Systems Segment, the WESCAM division develops the most advanced optical sensor and targeting systems for global defense and military sectors, National Security, Search & Rescue and Airborne law enforcement agencies. From long-range covert surveillance missions to search and rescue operations, our MX-series systems, and the mission systems solutions they are a part of, produce stabilized high-magnification electro-optical and infrared images from airborne, marine and ground based platforms, enabling our customers to see first and act first.

About the Role

The role is centered around ownership of Engineering data that is used to drive decisions related to Engineering Project’s. The successful candidate will be responsible for the Engineering data sources used to hold Engineering labour and non-labour forecasts, generation of reports and / or visuals that provide relevant information to Project Engineer’s and general ownership of tools / templates used by Project Engineering to generate project estimates.

Primary Responsibilities

• Provides business analytics and reporting to the Engineering functional area for projects / programs.
• Identify and develop metrics by working with users and stakeholders to understand data visualization and reporting requirements.
• Translate business results into meaningful metrics and recommendations aimed at improving performance within the Engineering Function.
• Analyzes business processes and problems to formulate and develop recommendations to meet customer and / or internal project requirements.
• Support Engineering Leadership in performing financial and business performance analysis.
• Defines configuration specifications and business analysis requirements.
• Accountable to manage & own:
  • Engineering Labour SQL Database
  • Excel templates used to generate project estimates
  • Power BI based visuals to support Engineering needs
  • Monthly ETC update process to update labour and non-labour forecasts efficiently
• Execute and provide analysis of the Engineering labour supply and demand process
• Analyze Engineering data to highlight trends to Project Engineer’s with regards to project health
• Support set up of new projects in ERP-LN and JIRA as required
• Support the continued improvement of the Engineering Knowledge Base data structure in Confluence to enable users in finding relevant data easily

Required Capabilities

• Ability to interact with SQL databases through custom queries
• Expert in Microsoft Excel data manipulation
• Able to use Power BI to connect various data sources to create required visuals
• JIRA administration, including project data management, user management, workflow management and other customizations
• Excellent communication and problem solving skills and a willingness to iterate through changes to continuously improve Engineering’s data.

Education and Experiences

• Requires practical knowledge of job area typically obtained through education combined with experience.
• Bachelor’s Degree and a minimum of 2 years of prior related experience
  • Graduate Degree or equivalent with 0 to 2 years of prior related experience.

At L3Harris, we foster an inclusive and equitable workplace. L3Harris is committed to treating all employees and applicants for employment with respect and dignity and maintaining a workplace that is free from unlawful discrimination. For applicants with disabilities, we will provide you with accommodation so that you have what you need in order to be at your best.

L3Harris performs background checks prior to employment as all applicants must be eligible for registration with the Controlled Goods Program and obtain and maintain a positive security assessment. Some positions may require a government of Canada “Reliability” status and/or Level 2 (Secret) security clearance. In addition, L3Harris performs pre-employment substance abuse testing where required.

About the company

L3Harris Technologies is an agile global aerospace and defense technology innovator, delivering end-to-end solutions that meet customers’ mission-critical needs. The company provides advanced defense and commercial technologies across air, land, sea, space and cyber domains.