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)

   

New Brunswick Region Pay Range Information:
The expected base salary range for this position is $60,000 to $90,000. Placement in the salary range will be based on relevant job-related factors like candidate experience, education, skills and qualifications.

Ontario Region Pay Range Information:
The expected base salary range for this position is $66,000 to $99,000. Placement in the salary range will be based on relevant job-related factors like candidate experience, education, skills and qualifications.

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