Senior Business Intelligence Analyst

Open 30d

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