Power BI Developer

Company Overview

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, is a world leader in interconnect solutions for Communications, Mobile, RF, Optics, and Commercial electronics markets. ACS has an expansive global presence in research and development, manufacturing, and sales, designing and manufacturing a wide range of innovative connectors and cable assemblies for server, storage, data center, mobile, RF, networking, industrial, business equipment, and automotive applications.

Power BI Developer –
Markham, ON – Hybrid

As a key technical member of the IT team, you will lead the development of robust data pipelines, including data cleansing and loading into the data warehouse, to enable reliable and scalable reporting solutions. Beyond technical build, you will bring expertise in visualization and dashboarding, analytical thinking to choose the right metrics and charts, and design an executive dashboard that turns dense operational data into a clear, decision‑ready view.

You will design intuitive user‑experience layouts, build impactful visualizations, conduct functional testing, and develop reports that align with business requirements, translating user needs into stable, efficient system solutions that support informed decision‑making.

The ideal candidate has a deep, practical understanding of data modeling and how to structure relationships across tables and systems so that executive dashboards and KPIs are accurate, performant, and trustworthy. You are comfortable in the language of the business as in DAX: you understand financial management fundamentals, sales and marketing metrics, and how to take detailed production and operational data from the plant floor and translate it into KPI‑level visualizations that executives rely on.

You have strong experience developing enterprise‑grade Power BI solutions within ERP and complex technology environments, following SDLC standards and disciplined version control, with expertise in data pipelines, ETL processes, and transforming raw data into scalable data models and impactful visualizations, along with a commitment to governance, quality, and deployment best practices.

• Design and implement end‑to‑end data pipelines, extracting raw data from internal systems, cleansing, and loading into the BI tool.
• Lead the extraction, transformation, and loading (ETL) of data from business‑critical systems such as ERP, CRM, and other data sources.
• Design and maintain efficient, scalable semantic data models, applying strong knowledge of database relationships (primary/foreign keys, cardinality, star and snowflake schemas) to ensure data accuracy and consistency.
• Integrate data from other sources (e.g., SQL databases, Excel, SharePoint) to build a unified view for analytics across finance, sales, marketing, and production.

• Lead the design, development, and maintenance of company‑wide Power BI dashboards and analytical tools, focusing on executive‑level dashboards and KPI reporting.
• Design and develop interactive dashboards, reports, and analytical tools using Power BI Desktop, applying strong visualization and UI/UX principles to ensure every dashboard is intuitive and visually clear.
• Utilize advanced DAX to create complex calculated measures, KPIs, and business logic that accurately reflect financial, sales, marketing, and operational performance.
• Translate detailed production and manufacturing data into concise, executive‑friendly KPI visualizations that surface trends, bottlenecks, and performance against target.
• Ensure dashboard design is intuitive, visually appealing, and provides an excellent user experience for audiences ranging from plant‑floor supervisors to senior executives.

• Proactively engage with finance, sales, marketing, and operations departments to understand their reporting challenges and analytical needs.
• Apply working knowledge of financial management (budgeting, cost, margin) and sales/marketing metrics (pipeline, conversion, revenue) to build KPIs that are meaningful to the…