RESPONSIBILITIES Own the Power BI reporting experience from requirements and visual design through development, validation, release, adoption, and ongoing improvement ACTIVITY DESCRIPTION Advanced Power BI Development Design and build polished dashboards and interactive reports with transparent KPI hierarchies, effective visual layouts, accessible colors, and consistent navigation.

Implement DAX measures, Power Query transformations, drill-down, drill-through, tooltips, bookmarks, field parameters, and dynamic filtering.

Optimize report responsiveness and usability.

Reporting for Different Levels Build executive scorecards for strategic performance and exceptions; departmental dashboards for targets, trends, and drivers; and operational views for detailed transactions and follow-up actions.

Enable a consistent path from enterprise summaries to region, site, product, customer, and transaction details where data and permissions allow.

Business Requirements and Insights Lead discovery sessions, clarify business questions and decisions, and translate requirements into wireframes, report specifications, and acceptance criteria.

Analyze trends, variances, and drivers; explain findings in business terms and help stakeholders identify actions supporting revenue growth, margin, and customer retention.

Model Collaboration and Accuracy Use approved, reusable semantic models and KPI definitions.

Develop report-specific measures within agreed standards and collaborate with the Data and Modeling Engineer on shared calculations and model changes.

Reconcile results with source systems and business control totals, investigate discrepancies, and obtain business owner sign-off.

Delivery and User Adoption Manage the reporting backlog and agreed priorities.

Coordinate demonstrations, user acceptance testing, controlled releases,



and documentation.

Train users, support self-service reporting within governance standards, track usage and feedback, and continuously improve the reporting experience.

Security and Operational Support Implement and test approved row-level security and report access.

Support workspace and Power BI app publishing, refresh monitoring, performance tuning, incident resolution, and change control.

Maintain report inventories, calculation documentation, access evidence, and support instructions; provide cross-training and backup coverage. QUALIFICATIONS Bachelor's degree in information systems, Computer Science, Business Analytics, Finance, Engineering, or a related field, or equivalent relevant experience. 5+ years of relevant business intelligence or analytics experience, including at least 3 years of substantial hands-on Power BI dashboard and report development.

Advanced Power BI expertise with a strong portfolio demonstrating visual design, interactive analysis, executive dashboards, and business reporting.

Candidates should be able to demonstrate their work using anonymized or sample data.

Strong DAX, Power Query, SQL, dimensional modeling, and Power BI semantic model skills, including relationships, filter context, time intelligence, and performance optimization.

Practical experience with Power BI Service, workspaces, apps, refresh and gateway configuration, row-level security, and controlled development and release processes.





Ability to translate complex data into clear business insights and engage effectively with senior leadership, Marketing, Finance, and Customer Service across global locations.

Experience validating and reconciling reporting results, documenting KPI logic, coordinating user acceptance testing, and delivering user training.

Preferred Experience Manufacturing or global enterprise reporting; ERP, MES and CRM data, including QAD ERP, Plex MES, Salesforce CRM; Microsoft Fabric and Azure data platforms; Microsoft Power BI certification such as PL-300; financial, commercial, and customer service analytics.

Come join the Amphenol family! The base salary range for this position is $85,000 - $110,000 annually.

In determining the rate of pay, Amphenol considers a variety of nondiscriminatory factors, including but not limited to geographic location, relevant industry experience, qualifications, skills, and education.

It would be rare for an individual to be hired at or near the top of the range for a given role.

Base salary is one facet of Amphenol's total rewards package which includes participation in our comprehensive benefits program with medical, dental, and vision benefits, vacation, sick leave, paid holidays, life insurance, short/long term disability, and membership in our Defined Contribution Pension Plan.

Amphenol Canada is committed to developing inclusive, barrier-free selection processes and work environments.

If contacted in relation to a job opportunity you should advise Amphenol, in a timely fashion, of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.

Information received relating to accommodation measures will be addressed confidentially.

📌 Power BI Specialist (Markham)
🏢 Amphenol ICC
📍 Markham