Senior Business Analyst

About CooperSurgical

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 (Nasdaq: COO), 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. Learn more at www.coopersurgical.com.

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

Scope:

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.

Job Summary:

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.

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 verbal and written communication in English required.
• Successful completion of a background check (employment/education verification where applicable).

Required Experience:

• 3-5 years of experience in business intelligence, analytics, or related roles.
• Experience in Supply Chain (inventory, planning, manufacturing/operations, logistics, service levels).
• Experience building operational Excel-based tools, reconciliations, trackers, or semi-automated reporting solutions for business users.

Required Education:

• Bachelor's degree in IT, Industrial Engineering, Business Administration, Data/Analytics, Programming, Engineering, Computer Science, or similar (or equivalent experience).

Preferred Certifications:

• Microsoft Power BI Data Analyst certification or equivalent training
• Microsoft Excel certification or advanced Excel training
• Data Visualization training
• PMP or agile project management training

#LI-KA1

Our Benefits:

As an employee of CooperSurgical, you''ll receive an outstanding total compensation plan. As we believe your compensation goes beyond your paycheck, we offer a great compensation package, medical coverage, 401(k), parental leave, fertility benefits, paid time off for vacation, personal, sick and holidays, and multiple other perks and benefits. Please visit us at www.coopersurgical.com to learn more about CooperSurgical and the benefits of becoming a member of our team.

To all agencies: Please, no phone calls or emails to any employee of CooperSurgical about this opening. All resumes submitted by search firms/employment agencies to any employee at CooperSurgical via-email, the internet or in any form and/or method will be deemed the sole property of CooperSurgical, unless such search firms/employment agencies were engaged by CooperSurgical for this position and a valid agreement with CooperSurgical is in place. In the event a candidate who was submitted outside of the CooperSurgical agency engagement process is hired, no fee or payment of any kind will be paid.

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

For U.S. locations that require disclosure of compensation, the starting base pay for this role is between $128,000.00 - $160,000.00. The actual base pay includes many factors and is subject to change and modification in the future. This position may also be eligible for other types of compensation and benefits.

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

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