Power BI Specialist
- Markham, ON, Canada
The base salary range for this position is $85,000 - $110,000 annually. · Full-time
Applications open in a new tab.
Job details
- Pay
- The base salary range for this position is $85,000 - $110,000 annually.
- Job type
- Full-time
- Apply by
- 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.
- Posting language
- English
- Posted
Original job description
Wage Max: 110,000.00 Annual Wage Min: 85,000.00 Annual Position Type: Full Time
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. Amphenol Corporation is one of the world’s largest designers and manufacturers of electrical, electronic and fiber optic connectors and interconnect systems, antennas, sensors and sensor-based products and coaxial and high-speed specialty cable. ACS has an expansive global presence in research and development, manufacturing, and sales. We design and manufacture a wide range of innovative connectors as well as cable assemblies for diverse applications including server, storage, data center, mobile, RF, networking, industrial, business equipment, and automotive.
Amphenol is one of the largest manufacturers of interconnect products in the world. The Company designs, manufactures and markets electrical, electronic and fiber optic connectors, coaxial and flat-ribbon cable, and interconnect systems. The primary end markets for the Company's products are communications and information processing markets, including cable television, cellular telephone and data communication and information processing systems; aerospace and military electronics; and automotive, rail and other transportation and industrial applications.
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. Amphenol Corporation is one of the world's largest designers and manufacturers of electrical, electronic and fiber optic connectors and interconnect systems, antennas, sensors and sensor-based products and coaxial and high-speed specialty cable. ACS has an expansive global presence in research and development, manufacturing, and sales. We design and manufacture a wide range of innovative connectors as well as cable assemblies for diverse applications including server, storage, data center, mobile, RF, networking, industrial, business equipment, and automotive.
Amphenol High Speed Products Group is the market leader for high-speed IO products. Our products help to enable the electronics revolution and remain a key enabler for all the major Tier 1 OEMs globally.
Power BI Specialist
Position: Power BI Specialist
Location: Markham
Reports To: Director of IT Applications
Position Summary
We 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
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 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.
- 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.
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.
Amphenol Corporation is proud of our reputation as an excellent employer. Our focus is to provide the highest level of support and responsiveness to both our employees and our customers, the world's largest technology companies. Amphenol Corporation offers the opportunity for career growth within a global organization. We believe that Amphenol Corporation is unique in that every employee, regardless of his or her position, has the ability to positively impact the business.
Amphenol is an “Equal Opportunity Employer” - Minority/Female/Disabled/Veteran/Sexual Orientation/Gender Identity/National Origin. For additional company information please visit our website at https://www.amphenol-cs.com/
More about this job
Responsibilities
Design, develop, validate, and maintain interactive Power BI dashboards and reports for executive, departmental, and operational users. Translate business needs into trusted insights, manage reporting delivery and adoption, and support security, performance, accuracy, and ongoing improvements.
Requirements
Requires a bachelor's degree in a relevant field or equivalent experience, at least five years of business intelligence or analytics experience, and at least three years of hands-on Power BI development. Candidates should have advanced Power BI, DAX, Power Query, SQL, modeling, and Power BI Service skills, along with experience communicating insights, validating data, and supporting users.
Skills
- Power BI Dashboard Development
- Dashboard Design
- DAX
- Power Query
- SQL
- Dimensional Modeling
- Semantic Models
- Data Visualization
- Data Storytelling
- Business Analysis
- Data Reconciliation
- Performance Optimization
- Row-Level Security
- Stakeholder Management
- User Acceptance Testing
- User Training
Benefits
- Medical Benefits
- Dental Benefits
- Vision Benefits
- Vacation
- Sick Leave
- Paid Holidays
- Life Insurance
- Short-Term Disability
- Long-Term Disability
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Manufacturing
- Finance & Accounting
- Customer Service & Support
Keywords
- Power BI
- DAX
- Power Query
- SQL
- Power BI Service
- Microsoft Fabric
- Azure Data Platforms
- QAD ERP
- Plex MES
- Salesforce CRM
- PL-300
- Business Intelligence
- Analytics
- Dashboard Design
- Interactive Reports
- Executive Dashboards
- Data Storytelling
- Semantic Models
- Dimensional Modeling
- KPI Definitions
- Time Intelligence
- Performance Optimization
- Row-Level Security
- Data Reconciliation
- User Acceptance Testing
- Manufacturing Reporting
- Financial Analytics
- Customer Service Analytics
- Refresh and Gateway Configuration
- Controlled Release Processes