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, usin

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