Business Intelligence Analyst-Mars Veterinary Health

JOB TITLE: Business Intelligence Analyst-Mars Veterinary Health LOCATION & SCHEDULE: Support Office - Vancouver, Full time COMPENSATION: $74,816.00 - $116,900.00 As part of the Mars Petcare family of businesses, Mars Veterinary Health is a global network of veterinary practices made possible by 75,000 Associates who care for millions of pets across nearly 3,000 clinics in more than 20 countries each year. We are committed to leveraging our reach to make a long-term positive impact on people, pets, and the planet and know our Purpose – A BETTER WORLD FOR PETS – starts with the people who care for them. We strive to offer unparalleled veterinary care for pets by first and foremost enabling and empowering our Associates to do what they love, whether in primary, specialty, and emergency care or management and leadership. This role requires associates to work out of a MVH Hub location in Santa Monica, CA | Tampa, FL | Vancouver, WA. Why This Role Matters: Build and maintain data pipeline, complex dashboards and create data-driven insights on MVH Commercial strategic initiatives while understanding our fundamental business drivers. Analyze, scope, develop and implement standard reporting/dashboards & analytics, working with various MVH Business Units. Be one of the primary points of contact on Purchasing/Commercial data for MVH, supporting end users and maintaining data governance. You Will: Design, manage and maintain global spend cube by bringing in all procurement data from all BUs so our teams can use them to look for opportunities and make strategic decisions and drive value Support and maintain Procurement system (OrderRight), strategic sourcing management system and inventory solution by ensuring data is current, the systems are working appropriately and assisting end users with questions and/or troubleshooting issues. Decompose high-level business and user requirements into functional requirements, identifying the data needs, creating dashboards and analytics, and communicating results to management and project teams. Extract data from different source systems, draw key insights, and produce clear and concise reporting and analytics. Lead cross-functional and cross BU teams in managing team-based projects by scoping work, clarifying dependencies on others, and completing projects in a timely manner, documenting processes along the way. Create and maintain metrics dashboards (e.g. P2P, price exception, contract pricing etc.) for all MVH BUs so Procurement and Finance team can help drive purchasing and invoicing efficiencies. Build tools using approved technologies to manage our savings intake, tracking and reporting Understand our COGS, identify inventory cost reduction opportunities, making recommendations to automate and streamline inventory forecasting and procedures. Contribute to strategic planning, analysis activities and documentation of inventory & supply chain management projects. Provide necessary training to all the sourcing and buying-ops team on various tools and technology to do their job efficiently and effectively Helps bring in innovative ideas using AI technology unlocking new possibilities for the broader Commercial team and MVH business overall Other job duties as assigned. Your Experience Should Include: Required - Bachelor’s Data Analytics, Business Intelligence, Information Systems, Computer Science, Finance/Accounting, or Supply Chain & Logistics Preferred Microsoft PL300 certification is a strong plus Years of Experience Required: 3+ In what area: Coupa purchasing systems, supply chain or related field Required 3-4 years’ of hands-on experience building and maintaining reports, dashboards, and data models in Microsoft Power BI or comparable BI tools Required 3-4 years’ of experience writing and optimizing queries using Oracle SQL or similar SQL-based databases, with solid working knowledge of the Microsoft technology stack. Preferred 1+ years’ experience in using DAX Power BI functions, AI driven analytics, PowerApps & Power Automate* or the equivalent combination of education, training and experience that provides the required knowledge, skills, and abilities Salary: $74,816-116,900 Compensation is determined based on education, experience, and other relevant credentials. Our salary ranges are determined by role, level, location, and market competitiveness. Does this sound like you? Want to join an organization that values Quality, Efficiency, Responsibility, Mutuality, and Freedom? Apply today to be considered and join us to advance our mission to create A BETTER WORLD FOR PETS. What We Offer You: Competitive salary with paid time off & holidays so you can spend time with the people you love. Medical, dental, and vision insurance for you and your loved ones. Fertility and family-building assistance. Paid Parental leave. Practice Paid Basic Life Insurance. Practice Paid Short- and Long-Term Disability. Automatic enrollment 401(k) Savings Plan after 60 days of employment with generous company match. Commuter Benefits. Legal Plan. Health Savings Account & Flexible Spending Account. Mental health support and resources. Paid Volunteering. Optimum Wellness Plans® for up to three pets. Continuing Education allowance & MED hours for eligible positions. Student Debt Relief (for full-time DVMs). A Variety of discounts including Mars, PetSmart, Royal Canin, fitness, cellular and so much more. Special Working Considerations: Ability to work at a computer for long periods of time. Must have mental processes for reasoning, remembering, mathematics and language ability (reading, writing, and speaking the English language) to perform the duties proficiently. Ability to carry out instructions furnished in written, oral, or diagram form and to solve problems involving several variables. The noise level in the work environment is normally moderate. Environment where pets are present. WE ARE A DRUG-FREE, SMOKE-FREE, EQUAL OPPORTUNITY EMPLOYER. Mars Veterinary Health (MVH)® strongly supports and values the uniqueness of all individuals and promotes a work environment where diversity is embraced. MVH is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, genetic information, status as a protected veteran, or status as a qualified individual with disability. MVH complies with all applicable federal, state and local laws governing nondiscrimination in employment in every MVH location. Part of the Mars Petcare family of businesses, Mars Veterinary Health is a purpose-driven team of 70,000 passionate, pet-loving Associates spanning preventive, general, specialty, and emergency veterinary care. We set a standard for high-quality care delivered through millions of pet visits each year across 3,000 veterinary clinics worldwide. Together, we are dedicated to harnessing our combined knowledge, talent, and resources to lead the veterinary profession in making A Better World For Pets – and the people who care for them.