Power BI SpecialistPosition: Power BI Specialist
Location: Markham
Reports To: Director of IT Applications
POSITION SUMMARYWe are seeking a Power BI Specialist with exceptional hands-on dashboard design and development capabilities to join our IT Applications team. This role will create intuitive, interactive, and high-performing BI dashboards and reports for executive leadership, marketing, finance, customer service and global operation. The specialist will translate business priorities into trusted insights that improve visibility, strengthen customer service, identify growth opportunities, and support timely decisions.
The role will deliver reporting at executive, functional management, and operational levels, working closely with business owners, key stakeholders and the IT team members globally. Strong visual design, advanced Power BI development, and effective business partnership are essential.
ATTRIBUTES- Exceptional dashboard design and data storytelling
- Business understanding and analytical problem solving
- Hands-on execution, ownership, and accountability
- Clear communication and strong stakeholder partnership
- Attention to accuracy, usability, and continuous improvement
RESPONSIBILITIESOwn the Power BI reporting experience from requirements and visual design through development, validation, release, adoption, and ongoing improvement
ACTIVITYDESCRIPTIONAdvanced Power BI Development
Design and build polished dashboards and interactive reports with clear 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.
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.
