Senior Business Intelligence Analyst
What We Offer:
Irving Consumer Products is proud to offer a competitive salary and benefits package, including but not limited to:
- Flexible medical, dental, and vision plan
- Employee & family assistance program
- RRSP matching program
- Health & Wellness reimbursements
- Product purchase program
- Opportunities to take part in job-related training and development
- Relocation cost (if applicable)
- $69,300 - $102,400 (please note that this is an estimate and actual pay will vary depending on location, experience, qualifications, and professional certifications.)
As a Sr. Business Intelligence Analyst, you will be a pivotal member of the Corporate Business Data team, leading the design and development of advanced solutions that drive data-informed decision-making across ICP’s operations. Reporting directly to the Business Data Manager, you will take a lead role in collaborating with our manufacturing facilities to architect sophisticated reporting and analytics solutions using data from machine sensors and production systems to drive strategic objectives.
- Drive the development and implementation of innovative reporting and analytics solutions that align closely with overarching business objectives and strategic initiatives.
- Provide strategic leadership in the end-to-end development of complex reporting and analytics solutions, leveraging extensive experience and expertise to deliver high-impact outcomes.
- Develop and execute comprehensive strategies to enhance the overall data literacy and analytical capabilities of the team, fostering a pervasive data-informed culture that permeates all levels of the organization.
- Provide strategic mentorship and coaching to senior supervisors, leaders, managers, and process engineers, leveraging extensive expertise to elevate their analytical capabilities and drive data-driven decision-making across diverse manufacturing sites.
- Champion the establishment and dissemination of advanced best practices and standards for leveraging Power BI, ensuring the consistent adoption of industry-leading methodologies and approaches across the organization.
- Undertake the rigorous testing and publication of complex reports to Power BI Service, ensuring the seamless delivery of high-quality, actionable insights to stakeholders throughout the organization.
- Lead proactive research and self-education efforts on emerging technologies and trends within the realm of Business Intelligence, demonstrating a commitment to staying at the forefront of industry advancements and leveraging this knowledge to drive innovation within the organization.
- Undertake comprehensive assessments of new technologies and innovative approaches, and spearhead initiatives to advocate for their adoption and integration across the organization, demonstrating a strategic vision for leveraging cutting-edge tools and methodologies to enhance data analytics capabilities.
- Postsecondary education in Business Intelligence, Business Analytics, Data Science and Analytics, Computer Science, Engineering, Software Engineering, or similar field of study
- PL-300 Microsoft Power BI Data Analyst Certification Preferred
- 7+ years of Business Intelligence experience:
- Designing and implementing reporting solutions in various BI tools as required (Excel, PowerBI, Cognos, Jupyter Notebook, etc.)
- Querying SQL/NoSQL databases/data warehouses
- Designing, developing, and communicating KPIs to business stakeholders
- Creating mockups and prototypes to facilitate report design
- Teaching others how to effectively build reporting solutions
- Developing reporting solutions that are scalable, sustainable, and easy to maintain
- 7+ years of Microsoft Power Platform experience:
- Developing and publishing reports and dashboards in Power BI
- Developing data models in Power BI
- Developing Power Automate Flows
- Developing Power Apps
- Administrating Power BI Service and Workspaces
- 7+ years of solution design experience:
- Communicating complex technical solutions to business stakeholders
- Performing stakeholder analysis as part of Systems Analysis and Design
- Soliciting requirements from stakeholders at all leadership levels
- Implementing Design Thinking and Agile methodologies to improve solution adoption
- Monitoring and collecting usage statistics on solutions once implemented
- Working as an influencer and evangelist for data-informed decision making
- Fluent in
- Power BI
- Power Query and DAX
- Excel, querying relational databases/data warehouses (T-SQL)
- Microsoft Office Suite
- Design Thinking and Agile methodologies
- Project management and delivering on multiple initiatives
- Competent in Python for data analysis (NumPy/pandas)
- Effective change management and conflict resolution skills