Business Operations Analyst

Planet Pharma; St. Louis (MO); On-site; USD 60,000 - 80,000; Full time

Job summary

A leading pharmaceutical company in St. Louis has an immediate need for a Business Operations Analyst. This role involves developing Excel-based financial summaries, operational dashboards, and supporting decision-making across various teams. Ideal candidates will have at least 2 years of experience in business operations and high proficiency in Excel. This position offers a 6-month renewable contract with potential for long-term engagement. Strong analytical skills and the ability to work cross-functionally are essential.

Qualifications

• 2+ years of experience in business operations, project analysis, or financial reporting.
• High proficiency in Excel with advanced functions.
• Experience with enterprise tools used in purchasing and financial reporting.

Responsibilities

• Build and maintain Excel based financial summaries.
• Create project dashboards and data views for better understanding.
• Support analysis of business processes to identify gaps and inefficiencies.

Skills

Analytical thinking

Problem solving skills

High proficiency in Excel

Attention to detail

Cross-functional communication

Tools

SAP

Ariba

Job description

Immediate Need for a Business Operations Analyst with a pharmaceutical company. 6 month renewable contract with the potential for long term.

Summary

The Business Operations Analyst supports business partners across Operations, Engineering, Procurement, Finance, and PMO teams by delivering clear, accurate, and timely business insights. This role is responsible for developing Excel based financial summaries, project status reports, operational dashboards, and standardized reporting tools used to support decision making. The ideal candidate is analytical, organized, and comfortable working with cross‑functional teams in a dynamic project environment.

Key Responsibilities

• Build and maintain Excel based financial summaries for project status reporting, including budget tracking, actuals, forecasts, cost rollups, and variance explanations.
• Create project dashboards, pivot tables, and data views that help PMs and leadership clearly understand project and/or operations health.
• Consolidate data from SAP, Ariba, Manage, Time Tracker, SmartBuy, and other internal systems.
• Ensure reporting accuracy, version control, and consistency across all PMO reporting artifacts.
• Support analysis of business processes, identifying gaps, inefficiencies, and opportunities for standardization or automation.
• Assist with project‑related purchasing activities (coordinating purchase requests, tracking order status, supporting vendor transactions).
• Monitor operational spend, track key performance indicators, and help teams understand cost trends.
• Partner with Finance, Procurement, Engineering, and Operations teams to align reporting needs, clarify requirements, and maintain accurate data flow.
• Provide data insights that support planning discussions, capital project submissions, and operational reviews.
• Support communication of business needs to technical teams when improvements or system integrations are needed.
• Maintain clear documentation of processes, templates, reporting logic, and workflow standards.
• Assist in implementing new processes or tools, including training documentation and rollout support.
• Contribute to the development of consistent reporting structures across PMO teams.

Qualifications

Required:

• 2+ years of experience in business operations, project analysis, financial reporting, or related roles.
• High proficiency in Excel (pivot tables, advanced formulas, lookups, data modeling, creating summaries, interpreting data).
• Experience supporting or learning systems such as SAP, Ariba, or other enterprise tools used in purchasing and financial reporting.
• Strong analytical thinking, problem solving skills, and attention to detail.
• Ability to work cross‑functionally and communicate clearly with both technical and non‑technical stakeholders.

Preferred:

• Experience working with PMO or project‑based teams.
• Familiarity with forecasting, cost accounting concepts, or operational budgeting.