Business Intelligence Analyst-Mars Veterinary Health

About the role

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.

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.

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.

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.

Responsibilities

• 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.
• 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.
• 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.
• 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.

Requirements

• Bachelor’s Data Analytics, Business Intelligence, Information Systems, Computer Science, Finance/Accounting, or Supply Chain & Logistics
• 3-4 years’ of hands-on experience building and maintaining reports, dashboards, and data models in Microsoft Power BI or comparable BI tools
• 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*

Qualifications

• 3+ years of experience in Coupa purchasing systems, supply chain or related field

Skills

• Data Analytics
• Business Intelligence
• Information Systems
• Computer Science
• Finance/Accounting
• Supply Chain & Logistics
• Microsoft PL300 certification
• Power BI
• Oracle SQL
• DAX Power BI functions
• AI driven analytics
• PowerApps & Power Automate*

Benefits

• Competitive salary with paid time off & holidays
• 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
• Discounts including Mars, PetSmart, Royal Canin, fitness, cellular and so much more

Pay

$74,816-116,900

Schedule

Full time