Remote Excel Vba Jobs in Toronto, ON (NOW HIRING)

We are the people who give possibilities purpose

BD is one of the largest global medical technology companies in the world. Advancing the world of health is our Purpose, and it's no small feat. It takes the imagination and passion of all of us-from design and engineering to the manufacturing and marketing of our billions of MedTech products per year-to look at the impossible and find transformative solutions that turn dreams into possibilities.

The Business Analyst provides strategic decision support to the Sales and Marketing organization to drive the achievement of business objectives and revenue goals. This role leads the collection, analysis, and interpretation of market intelligence, customer, pricing, and financial data to deliver actionable insights that support informed business decisions.

A key focus of the role is developing financial models and business cases to support RFPs, proposals, pricing strategies, and incentive agreements. The Business Analyst is also responsible for designing and maintaining dashboards, KPIs, and reports that monitor business performance, identify trends, and uncover growth opportunities.

By leveraging data mining, analytics, forecasting, and reporting tools, this individual transforms complex internal and external data into meaningful business intelligence, enabling leadership to make data-driven decisions and execute strategic initiatives with confidence.

Job Responsibilities:

• Provide business decision support through market and sales analytics in support of overall pricing strategy and offer customer/market insights that will drive sales growth.
• Build solutions to combine multiple sources of data accurately to enhance sales and market intelligence.
• Work closely with sales and marketing to gather reporting requirements and build new capabilities. Includes performing data validation, combining multiple complex data sets, and end user testing of dashboards to ensure data accuracy and usability and self-serve dashboarding capabilities as required.
• Responsible for the management, continual customization and development of dashboards, reports, forms, templates and models utilizing varying technologies (QlikView, Power BI, PowerPivot, Excel, VBA Macros, Access etc.) in support of the business.
• Build alternate proposal models with the business based on market insight. Liaise with Finance and Commercial Operations Teams to ensure all financial and compliance/legal considerations are assessed.
• Work with businesses to build value add options/alternatives for customers. Responsible for developing model/calculations required for customer contract incentives and to ensure accrual, reconciliation, and payment process can be executed based on terms of proposal.
• Participate, lead and/or manage other Customer Intelligence and global projects as required. Share and leverage best practices, new learnings and developments from other businesses locally and globally.

Education and Experience required:

• University Degreecombined with 2+ years of business or finance data analytics experience.
• Experience with financial modelling and interpreting contractual agreements/proposals.

Knowledge and Skills:

• Proficient in Microsoft office tools such as Word, Outlook, Teams.
• Demonstrated advanced proficiency in Microsoft Excel, including the ability to analyze and manage large data sets, develop complex formulas and functions (VLOOKUP/XLOOKUP, INDEX-MATCH, IF statements, nested formulas), create Pivot Tables and dashboards.
• Ability to translate complex data into clear, actionable insights and present findings effectively to business leaders and executive stakeholders. Demonstrates strong communication, executive presence, and confidence in delivering data-driven recommendations, influencing decisions, and driving alignment across cross-functional teams.
• Strong organizational, prioritization, and analytical skills.
• Customer-focused, proactive, and results-oriented.
• Able to manage multiple priorities in a fast-paced environment.
• Adaptable, self-directed, and effective working independently.
• Demonstrates professionalism, integrity, and a continuous improvement mindset.

Preferred qualifications

• Fluency in French (read, write, speak) a strong asset.
• Experience with uncertainty analysis, forecasting, and general decision support is an asset
• Experience with accruals, general ledger entries, and account reconciliations is an asset
• QlikView,Power BI, SAP, BI/BW, Microsoft Access experience is an asset.

At BD, we prioritize on-site collaboration because we believe it fosters creativity, innovation, and effective problem-solving, which are essential in the fast-paced healthcare industry. For most roles, we require a minimum of 4 days of in-office presence per week to maintain our culture of excellence and ensure smooth operations, while also recognizing the importance of flexibility and work-life balance. Remote or field-based positions will have different workplace arrangements which will be indicated in the job posting.

For certain roles at BD, employment is contingent upon the Company's receipt of sufficient proof that you are fully vaccinated against COVID-19. In some locations, testing for COVID-19 may be available and/or required. Consistent with BD's Workplace Accommodations Policy, requests for accommodation will be considered pursuant to applicable law.

To find purpose in the possibilities, we need people who can see the bigger picture, who understand the human story that underpins everything we do. We welcome people with the imagination and drive to help us reinvent the future of healthcare. At BD, you'll discover a culture in which you can learn, grow and thrive.

We believe that when people connect in person, we learn faster, collaborate more deeply, and build a stronger culture. Join us and enjoy a culture where face-to-face collaboration supports your learning, your progress, and your success.

To learn more about BD visit https://bd.com/careers.

Becton, Dickinson, and Company is an Equal Opportunity Employer. We evaluate applicants without regard to race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status, and other legally protected characteristics.

Required Skills

Optional Skills

.