Business Analyst

Business Analyst

Location: Mississauga, Ontario

Role: Business Analyst (Hybrid)

Position Summary:

The Business Analyst plays a key role in managing reporting and analytics by developing relevant reports and providing accurate, timely, and actionable insights. Reporting to the Sr. Analytics Manager, the Business Analyst will support the development and maintenance of reports and dashboards to drive business performance and support business decision-making. This role will work closely with our Client Services team and clients to deliver value and ensure reporting & analytics align with business goals and client expectations.

Primary Responsibilities:

Team Assistance & Client Manager Support (40%)

• Manage the integration of client and retailer data with Brand Momentum’s in-store data.
• Generate compelling insights that tell a clear story and uncover opportunities to accelerate business growth for our clients
• Leverage AI and analyze large datasets to identify trends, insights, and performance gaps
• Assist in developing and enhancing reporting processes, ensuring consistency and accuracy across programs
• Collaborate with internal teams to gather reporting requirements and implement changes based on feedback
• Monitor performance metrics and proactively flag inconsistencies or issues
• Support the development of client-facing presentations and business reviews with relevant data and insights

ETL & Data collection automation (30%)

• Lead the development and implementation of strategies to automate key business processes, enhancing efficiency and scalability.
• Conduct thorough systems analysis to identify & propose improvements to existing workflows.
• Design, develop, and maintain robust ETL pipelines to ensure a seamless and efficient data flow.
• Utilize programming languages like Python and VBA, as well as tools such as Power Automate and MS Fabric, to build cutting-edge data solutions.
• Drive the modernization of legacy production reports, upgrading them to 2.0 versions or higher and integrating machine learning as needed.
• Establish a comprehensive documentation and library system for all production reports and ETL processes, ensuring knowledge transfer and maintainability.
• Contribute to data migration projects, ensuring the accurate and seamless transfer of data between systems.

Power BI Dashboard Development (15%)

• Develop and design new Power BI reports and dashboards that deliver key insights and support business decisions.
• Support client requests by gathering and analyzing detailed requirements to create effective reporting solutions.
• Work towards co-ownership of Power BI report development and client interactions, taking on greater responsibility over time.
• Contribute to the data model development within Power BI to optimize performance and enhance the usability of dashboards.

Client Presentations & Data Insights (15%)

• Craft compelling presentations that translate complex data into clear, actionable insights for clients like JVF, ensuring a deep understanding of their business goals and challenges.
• Proactively extract, clean, and analyze data from the centralized platform to identify key trends and opportunities for client growth and optimization.
• Go beyond raw data to build "smart data narratives" that tell a story, highlighting key successes, uncovering potential issues, and recommending strategic next steps.
• Work closely with the sales, product, and data science teams to ensure client insights are shared effectively.
• Develop and present strategic recommendations to clients, demonstrating how the platform can drive better retail merchandising, improve sales, and reduce costs.
• Act as the primary point of contact for clients regarding data insights, reporting, and dashboard functionality

Qualifications:

• Proven experience in data analysis & reporting
• Strong proficiency in Power BI
• Expertise in SQL query development
• Experience with ETL pipeline development and ETL processes
• Familiarity with MS Fabric and its components is highly desirable.
• Proficiency in Excel, including advanced functions
• Experience with automation tools and programming languages such as Python, VBA, and Power Automate.
• Ability to extract meaningful insights from large datasets and perform system analysis.
• Experience with data migration and data lake development concepts.
• Basic understanding of DBA principles is a plus.
• Excellent communication and presentation skills, with the ability to articulate complex data findings to clients and stakeholders.
• Strong analytical and problem-solving abilities, with a proactive approach to identifying and addressing data challenges.

Our Commitment:

Enduring Success- We are not just about achieving success; we're about sustaining it. As a market leader in quality and innovation, we foster a fun culture where both employee and client aspirations can be realized.

Delivering on Promises- We are passionate about delivering on our promises to both clients and our people. Our innovative approach ensures we consistently provide exceptional value and flexibility, always striving to exceed expectations.

Core Values- Our commitment to integrity, respect, empowerment, and fun is woven into the fabric of our company. We believe in fostering a responsible and flexible work environment that allows our team members to thrive.

Sustainability- We prioritize sustainable suppliers and work with vendors and clients to offset the environmental impact of our programs, contributing to a greener future.

Diversity and Inclusion- We are dedicated to fostering a culturally diverse workplace. We value diverse perspectives and are committed to building a team that celebrates individual backgrounds, experiences, and talents. We believe in the power of diversity to drive stronger, more innovative outcomes.

#BMI1