Business Analyst This is the world's leading animal health pharmaceutical company, they are driven by a singular purpose: to nurture our world and humankind by advancing care for animals. After nearly 70 years innovating ways to predict, prevent, detect, and treat animal illness, they continue to stand by those raising and caring for animals worldwide - from livestock farmers to veterinarians and pet owners. The company's leading portfolio and pipeline of medicines, vaccines, diagnostics, and technologies make a difference in over 100 countries. In 2020, they generated revenue of $6.7 billion with 11,300 employees worldwide.They are looking for a talented Business Analyst for its Canadian operations. The role will partner with commercial sales teams and provide value added insights on sales performance metrics, contract profitability and sales discount analysis to help drive the achievement of business goals. He/she will leverage core analytic skills to deliver for the company's brands and Business Units tasks like evaluation of opportunities, risks, ROI and provide ad hoc analyses to drive strategic commercial decisions. This role is a maternity replacement however they say there is a good chance that should it go well, they will bring you on as a permanent employee or extend the contract if you wish. Title: Business Analyst Location: Hybrid, with 2 days in office. 16740 Trans-Canada Highway, Kirkland, Quebec, H9H 4M7. Position status: 16- month contract + chance of going permanent after or extension. Maternity replacement. Salary: Salary, will be discussed over phone. For the contract you get, 3 weeks vacation, + benefits, Sun Life insurance that includes medical (including vision) and dental. Their spouse/children are also eligible. Sun Life premiums. We pay: 95% medical premium, 90% dental premium. Additional details at end of description. RESPONSIBILITIES strategic consultation to uncover commercial drivers and define solutions to address business requirementswith the commercial teams in the negotiation of customer contracts, providing analytic insight and ensuring that all agreements align with corporate standards and support the achievement of the operating plan forecastssales information to prepare and present ROI analysis for business promotions and business partnership agreementsmarket dynamics and key learnings to commercial teams (e.g., weekly monthly reports, sub-committee meetings, monthly presentations)commercial teams in the implementation of new products , customer contracts and price updatesMonthly sales close and reconciliation for marketing promotions and credits for Distribution centercalculations and implementation of accruals for sales discount structures and offersautonomously across different software's and platforms for data mining, data preparation and data cleansing to deliver high quality reportson special projects, as neededQUALIFICATIONS degree (BA, BSc, BBA) or equivalent work experience with Business and Finance3-5 years' experience as an Analyst in Compensation planning , sales or finance. General understanding of mathematical functions , analytic, finance and related concepts.2-3 years' experience with order to cash processes and or data with ERP platforms like SAP or Oracle etc.accounting skillscomputer skills (e.g., BI Platforms, SQL, Excel, Microsoft Word, Microsoft Outlook, Salesforce.com )to query databases via SQL codeto BI tools such as Azure Synapse, Power BI, or other analytic toolswith Excel proficiency/mastery: Formulas, Power Query/Pivot, Visualizations(French, English) , basic French is okaywritten and verbal skillsto operate in a fast-paced, rapidly changing environmentmultiple projects and priorities Strong combination of organizational, analytical, communications and presentation skillsto approach tasks with a sense of urgency to meet deadlinesNice-to-have but not requiredWholesaler / Buying groups sales experience, preferredcare customer sales data (claims, promotional data, sales), preferredsales and management data, preferredAdditional benefits offered:• Three (3) weeks' vacation • 1 paid volunteer day• Sun Life insurance that includes medical (including vision) and dental. Their spouse/children are also eligible.Sun Life premiums. We pays: 95% medical premium, 90% dental premium• Virtual health clinic through Dialogue, access to virtual consultations with healthcare professionals (includes family)• Employee Assistance Program (EAP) which offers counselling for a variety of topics (includes family)• Personal Spending Account (PSA) which provides $450 each year to spend on eligible expenses related to health and wellness. (pro-rated the first year)• Lunch subsidy of $10/day at the office