Power BI Analyst - Contract
Vaughan, ON, CA, L4K 4Y1
Mattr delivers advanced material technologies and complex manufacturing expertise. Through a portfolio of brands, we offer highly engineered solutions, technology and products to support infrastructure markets worldwide.
Shawflex is the market leader and a trusted brand in the Electrical Infrastructure industry with a wide variety of wire and cable solutions from common to custom. Our business model thrives on our strong channel relationships and entrepreneurial culture where we champion in providing unique engineered-to-order product offerings to our customers.
1 Year Hybrid Fixed Term Contract
POSITION SUMMARY:
Shawflex is undergoing a major reporting modernization initiative, transitioning from Excel-based reports into scalable, automated Power BI dashboards. This transformation is a cornerstone of our digital strategy, designed to centralize analytics, improve data integrity, and enable real-time decision-making across departments including Sales, Planning, Procurement, Production, Engineering, Finance, and Quality.
DUTIES & RESPONSIBILITIES:
A) Power BI Development and Data Modeling – 35%
1) Design and develop semantic models, dataflows, and dashboards using Power BI, DAX, and M language
2) Integrate data sources including ODBC connections and ERP systems
3) Optimize performance and usability of dashboards for business users
4) Ensure adherence to Shawflex’s branding, layout, and accessibility standards"
B) Stakeholder Collaboration and Requirements Gathering – 20%
1) Conduct stakeholder interviews to gather reporting requirements
2) Attend weekly check-in/project meetings for progress reviews
3) Conduct User Testing & Acceptance (UTA) sessions with stakeholders
4) Refine dashboards based on UTA feedback to meet business expectations"
C) Legacy Report Migration and Dataflow Design – 20%
1) Collaborate with Business Systems & Data Analyst and IT/Data teams to migrate legacy reports into Power BI
2) Review existing dataflows provided by the IT team and design new ones where required"
D) Documentation and Knowledge Transfer – 15%
1) Document processes and provide knowledge transfer to internal teams
2) Deliver training for end-users and developers"
E) Post-Deployment Support – 10%
1) Provide optional post-deployment support as needed"
REQUIREMENTS:
• Minimum 4 years of experience in Power BI development and data modeling.
• Microsoft Certified: Power BI Data Analyst Associate demonstrating advanced proficiency and best practices.
• Strong proficiency in:
- DAX for advanced calculations and measures.
- Power Query and M language for data transformation and shaping.
- SQL for querying and integrating relational data sources.
• Microsoft Excel, especially for legacy report analysis and migration.
• Demonstrated success in migrating Excel-based reports into scalable Power BI dashboards.
• Proven experience integrating data from ERP systems (Preferrably IFS)
• Experience conducting User Testing & Acceptance (UTA) sessions and refining deliverables based on feedback.
• Familiarity with semantic modeling, dataflows, and report automation.
• Strong expertise in semantic layer design and enterprise data architecture.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field. - Preferred
• Proficiency with Power BI Service: workspace management, sharing, and security configuration - Preferred
• Experience working in manufacturing or industrial sectors is a strong asset.
• Experience with project management tools (e.g., Jira, Trello, MS Project) and agile methodologies. - Preferred
• Ability to engage stakeholders to define KPIs, reporting needs, and dashboard requirements.
• Excellent communication and stakeholder engagement skills, with the ability to translate business needs into technical solutions.
WHAT MATTR OFFERS
• At Mattr, safety comes first! We go the extra mile to ensure our employees are safe and healthy
• We understand times have changed and so have we. Mattr offers flexible work arrangements (where possible) to suit your needs
• Comprehensive total rewards package that includes competitive salaries, annual incentives, medical benefits, retirement savings plans, paid vacation days, education assistance programs, corporate discounts and more!
• Participation in service milestone awards and recognition opportunities
• Access to mental health support resources such as our Headversity mental health and wellness platform and free, confidential access to our Employee and Family Assistance Program (EFAP)
• Rewarding growth opportunities (may include global career and travel opportunities) supported by personalized training, development and mentoring programs
• Commitment to providing a diverse, inclusive and accessible workplace environment
• We prioritize our Environment, Social and Governance (ESG) values and offer a paid Impact Day, allowing employees an opportunity to support charitable organizations in their communities
• Company events, social gatherings and team building activities that promote fun!
• We’re working to create a better world. Join us!
Mattr delivers advanced material technologies and complex manufacturing expertise through brands offering engineered products, technology and solutions to support infrastructure projects & markets world-wide. Mattr brands: Shawflex, DSG-Canusa, Flexpipe, and Xerxes.
At Mattr, we have built a true team environment where all employees are empowered to contribute to the success of the company. We want you to join our team!
#IND1