Business Intelligence Analyst - Data and Automation

Communications and Power Industries, Inc.; Halton Hills; On-site; CAD 73,000 - 99,000; Full time

Job summary

Communications and Power Industries, Inc. is seeking a Business Intelligence Analyst – Data and Automation to join our CPI Power Electronics team in Ontario, Canada.

The role turns business needs and data from JD Edwards, Salesforce, and other sources into reliable reporting, actionable analysis, and process improvements. You will extract, combine, validate, and automate data using SQL, Power BI, advanced Excel, and Python.

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• 3+ years in BI, data analysis, or process automation.
• Experience extracting, combining, and automating data from multiple systems.
• SQL proficiency with joins, aggregations, CTEs, and validation queries.
• Power BI expertise including data modeling, DAX, and dashboards.
• Advanced Excel skills for repeatable analyses.
• Python and API experience for data integration.
• Strong communication, documentation, and project management.

Responsibilities

• Confirm business questions and translate them into data and reporting requirements.
• Independently extract and combine data from JD Edwards and Salesforce.
• Build and maintain Power BI models and dashboards.
• Automate recurring data preparation and reporting using Python.
• Document calculations and establish data quality checks.
• Train and support users in understanding reports and tools.
• Travel less than 10% to the United States for collaboration and training.

Skills

Data analysis

Stakeholder coordination

Process automation

Data quality

Education

Bachelor's degree in a related field

Tools

SQL

Power BI

Excel

Python

Job description

Business Intelligence Analyst - Data and Automation

Job Category: Information Technology

Requisition Number: DATAA002337

• Posted : October 30, 2026
• Full-Time
• On-site

Locations

Showing 1 location

Description

SHAPING THE FUTURE THROUGH INNOVATION AND DISCOVERY!

With a history spanning more than seven decades, Communications & Power Industries’ thousands of products have impacted people’s lives in numerous unseen ways every day. Our highly engineered products serve as the backbone of modern-day commercial and military communications systems, assist in diagnosing medical conditions, empower scientific discoveries and space exploration, and much more.

CPI is headquartered in Plano, Texas and is a global manufacturer of electronic components and subsystems. We have manufacturing locations in the United States, Canada, Europe, and Asia. With a heritage of technological excellence, our team serves customers in the communications, defense, medical, industrial, and scientific markets.

YOUR DAY TO DAY:

We are looking for a Business Intelligence Analyst – Data and Automation to join our CPI Power Electronics team. This is a hands‑on role responsible for turning business needs and data from JD Edwards, Salesforce, and other sources into reliable reporting, actionable analysis, and practical process improvements. The position independently extracts, combines, validates, and automates data, building solutions using SQL, Power BI, advanced Excel, and Python .

Reporting to the Business Process Improvement Manager , you will work with functional teams and local and corporate IT to establish priorities, define meaningful performance measures, and deliver maintainable solutions. The role combines technical development with business analysis, helping users understand results, make informed decisions, and reduce recurring manual effort.

YOU WILL BE ACCOUNTABLE FOR/TO:

Business Requirements & Stakeholder Coordination

Confirm business questions, priorities, metric definitions, and acceptance criteria with stakeholders and translate them into practical data and reporting requirements.

Work with functional teams to understand business processes, identify reporting needs, and prioritize opportunities for analysis and automation.

Manage agreed priorities, communicate progress, issues, and dependencies , and follow through on commitments.

Data Extraction, Integration & Quality

Independently extract and combine data from JD Edwards, Salesforce, databases, spreadsheets, and other approved sources using SQL, supported connectors, APIs, and scripts as appropriate.

Validate and reconcile results to source systems, ensuring reporting outputs are accurate, consistent, and traceable.

Document calculations and transformations, establish repeatable data-quality checks , and resolve discrepancies with business owners and IT.

Build and maintain Power BI semantic models, DAX measures, Power Query transformations, and dashboards that clearly communicate performance and exceptions.

Develop advanced Excel analyses that combine and reconcile data from multiple sources.

Maintain scheduled refreshes and troubleshoot reporting discrepancies to support reliable, timely access to information.

Automation & Process Improvement

Automate recurring data preparation, analyses, and reporting using appropriate tools, including Python.

Maintain reliable automated processes with error handling, monitoring, and refresh controls within IT-approved environments.

Identify opportunities to reduce manual effort, improve consistency, and simplify recurring business processes.

Monitor solution accuracy, usefulness, and reductions in manual effort to assess the effectiveness of improvements.

Business Analysis & Decision Support

Deliver prioritized analyses of backlog, sales pipeline, inventory and material availability, production and delivery performance, margins, and working capital .

Investigate trends, exceptions, and underlying causes; explain findings and recommend practical actions .

Present results clearly to technical and nontechnical audiences and help users apply insights to business decisions.

Solution Delivery & Governance

Test solutions with users against agreed requirements and acceptance criteria.

Document and version‑control code, reporting logic, and supporting procedures to ensure solutions remain maintainable.

Train and support users in understanding reports, using analytical tools, and applying results.

Coordinate with local and corporate IT on access, credentials, security, and infrastructure .

Share reusable solutions and collaborate with State College and other CPI analysts to support consistent practices and knowledge sharing.

YOU ARE THE RIGHT PERSON FOR THIS JOB IF YOU HAVE:

A bachelor’s degree in Business Analytics, Information Systems, Computer Science, Industrial Engineering, Finance, Business, or a related field, or equivalent relevant experience.

At least three years of relevant experience in business intelligence, data analysis, business analysis, operations analytics, or process automation, including hands‑on development of reporting or analytical solutions.

Demonstrated delivery of solutions that independently extract, combine, validate, and automate data from multiple systems to support a business decision or improve a recurring process.

Demonstrated SQL proficiency , including joins, aggregations, common table expressions or subqueries, and validation queries to retrieve and reconcile relational data.

Hands‑on proficiency with Power BI , including Power Query, data modeling, DAX measures, dashboard development, scheduled refresh, and troubleshooting reporting discrepancies.

Advanced Excel skills , including PivotTables, lookup and aggregation formulas, Power Query, and repeatable analyses that reconcile data from multiple sources.

Practical experience with Python and APIs , including writing, modifying, troubleshooting, and maintaining scripts to extract, clean, combine, and validate data, while handling common data formats, authentication requirements, and errors.

Strong business analysis and data-quality skills , with the ability to define useful measures, understand processes, trace results to their sources, identify root causes, and translate findings into recommendations.

Strong written and verbal communication, documentation, organization, and follow‑through , with the ability to work independently and manage multiple priorities.

Ability and willingness to travel less than 10% to the United States , primarily State College, Pennsylvania, for support, collaboration, training, and workshops, and to meet applicable international travel requirements.

Direct experience with JD Edwards and Salesforce data, reporting, or interfaces is preferred.

Experience in manufacturing or engineered-product businesses , including analysis of orders, backlog, inventory, production, margins, or working capital, is preferred.

Experience with Git or other source control, scheduled jobs, Power Automate , or other data integration and workflow automation tools is an asset.

Experience applying Lean or other process improvement methods , or approved AI tools, to reduce manual effort while protecting company data and validating results is an asset.

WHO WE ARE:

We value the unique and diverse skills, qualities, and backgrounds that each employee brings to CPI, and we respect each employee as an integral member of our growing team. CPI is committed to providing equal employment opportunities for all current and prospective employees, as well as to promoting a culture of inclusion and respect for everyone. We celebrate the innovation that diversity creates in the work environment, and we recognize that each employee brings their own unique capabilities, experiences, and perspectives to the organization. It is this variety that adds value to our teams, as well as to our stakeholders. We welcome and encourage applicants to reach their full potential with us.

CPI is proud to be an Equal Opportunity and Affirmdative Action employer. We do not discriminate based upon race, religion, color, national origin, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender, gender identity, gender expression, transgender status, sexual stereotypes, age, status as a protected veteran, status as an individual with a disability or other applicable legally protected characteristics.

WHAT WE OFFER:

Whether you are a seasoned professional or just embarking on your career, CPI is an ideal place to expand your knowledge and expertise. We cultivate a healthy, dynamic, and team-oriented environment that empowers our employees to develop, create and deliver innovative, reliable technology solutions to power, connect, protect, and support a better tomorrow.

We offer our employees an attractive compensation package with competitive salaries and comprehensive benefits, including health and wellness programs, career development, generous retirement savings plan with company match and more!

We do not use artificial intelligence to screen, assess or select applicants.

• Salary: $86,000 CAD annually, based on relevant experience and qualifications.