Senior Business Analyst

Senior Business Analyst

CooperSurgical is a leading fertility and women's healthcare company dedicated to putting time on the side of women, babies, and families at the healthcare moments that matter most in life. As a business unit of CooperCompanies, we're driven by a unified purpose of helping people experience life's beautiful moments. Guided by our shared values dedicated, innovative, friendly, partners, and do the right thing our offerings support patients throughout their lifetimes, from contraception to fertility and birth solutions, to women's and family care, and beyond. We currently offer over 600 clinically relevant medical devices to healthcare providers, including testing and treatment options, as well as an innovative suite of assisted reproductive technology and genomic testing solutions.

Work location: Trumbull, CT or Livingston, NJ (on-site)

The Senior Business Analyst (Sr. BA) is a hands-on problem-solving role within the Global Supply Chain Data Analytics & Data Science team at CooperSurgical. The Sr. BA is a practical supply chain analytics owner who can solve immediate business problems using Excel, quick queries, and lightweight reporting solutions, while moving recurring needs toward scalable Power BI and SQL-based solutions.

In Power BI, the Sr. BA connects to approved data sources, transforms data, and builds scalable, low-maintenance reporting solutions. This role is responsible for identifying, diagnosing, and solving Supply Chain process and data challenges using the appropriate mix of analytics tools, source-system knowledge, and practical business judgment. The Sr. BA independently delivers advanced reporting, operational analysis, and decision-support tools, improves data quality, and drives continuous improvement through actionable insights. This role serves as a key support and enhancement owner for reporting products used globally.

The Sr. BA balances speed and scalability, delivering quick, simple solutions such as Excel tools, quick queries, reconciliations, and lightweight dashboards to unblock the business, while designing robust, automated, and scalable analytics products for long-term stability.

As a senior contributor, the Sr. BA serves as a technical mentor, coaching Business Analysts on data modeling, DAX best practices, visualization standards, QA, documentation, and report lifecycle management to improve team capability and delivery quality. The Sr. BA also helps establish and reinforce reporting standards, documentation practices, and reusable components to enable scalable self-service analytics.

The Sr. BA brings strong end-to-end Supply Chain process expertise (planning, inventory, manufacturing, logistics, service levels) and uses that knowledge to translate ambiguous business problems into actionable insights and solutions. The Sr. BA is a member of the Global Supply Chain Analytics & Data Science team and primarily supports Global Supply Chain by defining business requirements, translating needs into scalable analytics solutions, and driving operational improvements through reporting, KPI frameworks, and insights. The Sr. BA collaborates closely with other team members and partners broadly across Operations, Engineering, Sales, Finance, R&D, IT, and Global Management, including teams in Costa Rica. The Sr. BA provides advanced break-fix support for global reporting products, proactively identifies root causes, and leads improvements to prevent recurrence.

Responsibilities

• Own ambiguous business problems and independently drive them to resolution using data, process knowledge, and stakeholder collaboration.
• Build pragmatic, usable solutions quickly, with clear assumptions and a path toward scalable improvement.
• Challenge over-engineered solutions; prioritize simplicity, usability, and business impact.
• Translate Supply Chain process gaps into data models, KPIs, and decision tools.
• Act as a bridge between business and technical teams, ensuring solutions are both usable and sustainable.
• Collaborate primarily with Global Supply Chain stakeholders to define business requirements and translate them into actionable analytics and reporting plans.
• Build and improve dashboards and KPI frameworks supporting operational efficiency, inventory visibility, demand planning, and service levels.
• Lead reporting initiatives through the full lifecycle, including intake, discovery, requirements, build, QA/UAT, release, training, adoption, and iterative enhancement.
• Implement improvements that reduce manual effort, improve automation/reliability, and increase stakeholder self-service capability.
• Coordinate with Data Engineering/IT to improve source system integration, dataset design, refresh reliability, and data quality controls; validate end-to-end lineage from source to dashboard.
• Establish and maintain an intake and prioritization process for enhancements and ad hoc requests; define repeatable solutions for frequent asks.
• Drive stakeholder alignment by setting expectations for scope, timelines, dependencies, and release cadence; communicate status and risks proactively.
• Applies a "right tool for the problem" mindset, leveraging Excel, SQL, or Power BI depending on speed, complexity, and long-term needs.
• Rapidly builds interim/manual solutions (Excel models, Power Query transformations, quick extracts, reconciliations, and SQL queries) to solve urgent business problems while designing future-state automation.
• Identifies and resolves root cause process issues, not just data discrepancies.
• Simplifies complex problems into clear, actionable outputs for business stakeholders.
• Drives transition from manual ? semi-automated ? fully automated solutions.
• Independently develops, enhances, and maintains BI solutions and reporting using Power BI (including DAX), SAP BusinessObjects (preferred), and Excel/VBA.
• Designs and maintains Power BI semantic models and datasets, improving usability, performance, and refresh reliability.
• Conducts data validation, reconciliation, and QA to ensure accuracy and trust in reporting outputs.
• Validates reporting results by reconciling KPIs and metrics against ERPs and other source systems; investigates variances and documents findings.
• Performs analysis to uncover trends, risks, and opportunities; translates insights into recommendations and measurable actions.
• Leads requirements gathering workshops; documents functional specifications and acceptance criteria.
• Provides Tier 12 reporting support (break-fix), including incident triage, root cause analysis, and resolution documentation; implements fixes to prevent repeat issues.
• Owns and manages multiple reporting initiatives simultaneously, including intake, prioritization, scope, timelines, risks, dependencies, and stakeholder communications; maintains a structured backlog of enhancements and new requests.
• Collaborates with Data Engineering/IT to define data requirements, improve pipeline reliability, resolve data issues, and ensure governed datasets support reporting needs end-to-end.
• Provides timely ad hoc analysis and reporting support; triages requests, documents logic/assumptions, and converts recurring requests into standardized reporting where appropriate.
• Coaches and mentors Business Analysts through guidance on requirements, modeling, DAX optimization, visualization best practices, QA, and release processes; supports peer reviews and knowledge-sharing as needed.
• Collaborates within the Global Supply Chain Analytics & Data Science team to standardize KPI definitions, improve data literacy, and increase adoption of self-service reporting.
• Promotes a continuous improvement mindset; drives data-led initiatives with leaders and process owners.
• Performs additional duties as assigned.

Travel: Up to 10% domestic travel may be required to support cross-functional collaboration, operational reviews, or analytics workshops.

Qualifications

Knowledge, Skills & Abilities

• Advanced Excel skills required, including complex formulas, Power Query, pivot tables, data validation, reconciliation, scenario analysis, and creation of maintainable operational tools. VBA/macros are a plus.
• Intermediate-to-advanced proficiency in Power BI and DAX; strong capability in report design, modeling, and performance optimization.
• SAP BusinessObjects experience is a strong asset.
• Experience working with ERP platforms such as Microsoft Dynamics 365 or comparable systems is beneficial.
• Proficiency with SQL is strongly preferred; familiarity with Python/VBA is a plus.
• Strong analytical skills: ability to learn complex processes quickly and identify key data flows and improvement opportunities.
• Experience using ERP systems to perform data validation, transaction-level reconciliation, and root-cause investigation between source systems and reporting outputs.
• Demonstrated ability to manage multiple concurrent initiatives, balancing competing priorities and communicating tradeoffs effectively.
• Strong cross-functional collaboration skills, including working with Data Engineering and IT to define datasets, troubleshoot data issues, and improve pipeline reliability.
• Ability to provide mentorship and coaching to analysts; drive adoption of best practices, standards, and reusable reporting components.
• Strong communication skills: ability to distill complex data into clear, concise insights for technical and non-technical audiences.
• High attention to detail and data quality; consistent track record of meeting commitments.
• Effective