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 contemporary-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.

#J-18808-Ljbffr

📌 Business Intelligence Analyst - Data and Automation (Milton)
🏢 Communications and Power Ind. Canada
📍 Milton