Business Intelligence Analyst – Data and Automation

On Site Full TimePrince Edward Island, CanadaCommunications and Power Industries

Role Overview

Business Intelligence Analyst – Data and Automation will join CPI Power Electronics team to turn business needs and data into reliable reporting, actionable analysis, and practical process improvements.

What You Will Do

The position will independently extract, combine, validate, and automate data, building solutions using SQL, Power BI, advanced Excel, and Python. The role combines technical development with business analysis, helping users understand results, make informed decisions, and reduce recurring manual effort.

Why It Might Be a Fit

The ideal candidate will have a bachelor’s degree in Business Analytics, Information Systems, Computer Science, Industrial Engineering, Finance, Business, or a related field, or equivalent relevant experience. The candidate should have 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.

Requirements

  • 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

Benefits

  • Competitive salaries
  • Comprehensive benefits
  • Health and wellness programs
  • Career development
  • Generous retirement savings plan with company match

To apply for this job please visit recruiting2.ultipro.com.

RevOps Careers Favicon

Get the latest RevOps jobs every Monday.

No noise. Just the best GTM roles, curated weekly.

We don’t spam! Read our privacy policy for more info.

Get the full Role Intel for this job

ReLoop.me’s full Role Intel shows the real level behind the title, an estimated pay range, a must-have checklist and the questions to ask before you apply.

Tired of manual job applications?

JobCopilot auto-applies to thousands of RevOps and GTM roles on your behalf — so you can focus on interviews, not applications.

Applying for this role?

Tailor your resume to this exact role — hiring managers notice the difference.

Latest articles on the blog

RECRUITERS!

Reduce the risk of your recruitment process (applicant quality, long and inefficient process) by selecting from a relevant pool of candidates.

POST A NEW JOB NOW!