Business Intelligence Analyst - Data and Automation

Job Category: Information Technology

Requisition Number: DATAA002337

- Posted : October 30, 2026
- Full-Time
- In office

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

📌 Business Intelligence Analyst (Halton Hills)
🏢 Communications & Power Industries
📍 Halton Hills