Sql data analyst Jobs in Hamilton, ON

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 is the Trusted Disruptor in defense tech. 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.

Sr. Specialist, Business Intelligence Analyst

Reference #40969

Waterdown, Ontario

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

As a Business Intelligence (BI) analyst, you will be an agent of change within the organization by being a major contributor to culture shift in relation to data. You will communicate with the senior leaders, managers, supervisors and functional experts of the various Canadian divisions to propose the implementation of strategic indicators on which they will base their decisions. You will participate in the discussion, planning and execution of key performance indicators and interactive dashboards.

Responsibilities:

You will work in close collaboration with several groups within the company (planning, production, operations, program management, engineering, supply chain, etc.) in a multi-site context. You will transform data into actionable insights and information for our internal customers by leveraging your business acumen. With your knowledge of business intelligence and your analytical skills, you will be able to assess the capabilities and possible applications of organizational data. You will offer coaching and support to internal BI contributors to develop their autonomy and raise their level of BI maturity. In short, you will be an ambassador of business intelligence in the organization.

Primary Responsibilities

• Work with senior leadership and other business leaders to identify opportunities for improvement;
• Create dashboards and data strategies for internal teams and / or external stakeholders;
• Collaborate with team members to collect and analyze data;
• Establish Key Performance Indicators to measure the effectiveness of business decisions;
• Structure large data sets to find usable information;
• Work with a team of analysts and other associates to process information;
• Create presentations and reports based on recommendations and findings.

Required Capabilities

• Knowledge of Microsoft Fabric and Power BI
• Proficiency in SQL and Power Query languages
• Knowledge of data extraction, transformation and load (ETL) with SSIS and OLAP cubes
• Ability to analyze and model business needs
• Excellent communication skills in English (oral and written)
• Ability to adapt in a dynamic environment and prioritize business requests
• Agile to work simultaneously on one or more projects within a matrix organization
• Familiarity with applying AI-driven analytics tools (e.g. predictive analytics in Microsoft Fabric) an asset
• Experience preparing data and data models for AI ingestion an asset
• Experience interfacing with customers and working in large enterprise, implementing complex solutions.
• Experience in the aerospace and defense industry an asset

Desired Education and Experiences

• Requires strong knowledge of job area.
• Typically viewed as having a specialty within discipline.
• May have broad knowledge of project management.
• Bachelor’s Degree in Computer Science, Software Engineering or equivalent and minimum 6 years of prior relevant experience.Graduate Degree and a minimum of 4 years of prior related experience.
• In lieu of a degree, minimum of 10 years of prior related experience.

*This posting is for a current vacancy. In the province of Ontario, Canada, the pay range for this position will be $90,000 to $140,000

#LI-BD1

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.