Senior Business Analyst

CooperCompanies•Trumbull, CT

3d•$100,000 - $110,000•Onsite

About The Position

The Senior Business Analyst is a hands-on analytics role within CooperSurgical’s Global Supply Chain Data Analytics & Data Science team. The role solves supply chain process and data challenges using the appropriate mix of Excel, SQL, Power BI, source-system knowledge, and practical business judgment. The Senior Business Analyst delivers advanced reporting, operational analysis, and decision-support tools; improves data quality; and drives continuous improvement through actionable insights. The position also supports and enhances global reporting products, balancing rapid interim solutions with automated, scalable analytics products for long-term stability. The role applies working knowledge of supply chain processes—including planning, inventory, manufacturing, logistics, and service levels—to translate ambiguous business problems into actionable insights and solutions. It defines business requirements, develops scalable analytics solutions, and supports operational improvements through reporting, KPI frameworks, and analysis. The Senior Business Analyst works with Global Supply Chain and cross-functional partners in Operations, Engineering, Sales, Finance, R&D, IT, and Global Management. As a senior contributor, the role provides technical mentoring to Business Analysts on data modeling, DAX, visualization standards, QA, documentation, and report lifecycle management. The position is on-site in Trumbull, Connecticut, or Livingston, New Jersey. Up to 10% domestic travel may be required. The starting base pay is $100,000–$110,000 for U.S. locations requiring compensation disclosure; actual pay may vary and the position may also be eligible for other compensation and benefits.

Requirements

3–5 years of experience in business intelligence, analytics, business analysis, or a related role.
Experience or strong knowledge of supply chain, such as inventory, planning, manufacturing/operations, logistics, or service levels.
Experience building operational Excel-based tools, reconciliations, trackers, or semi-automated reporting solutions for business users.
Bachelor’s degree in IT, Industrial Engineering, Business Administration, Data/Analytics, Programming, Engineering, Computer Science, or a similar field, or equivalent experience.
Advanced Excel skills, including complex formulas, Power Query, pivot tables, data validation, reconciliation, scenario analysis, and maintainable operational tools.
Intermediate proficiency in Power BI and DAX, including report design, data modeling, visualization, and performance optimization.
Strong analytical skills and ability to learn complex processes, understand data flows, and identify improvement opportunities.
Experience using ERP or operational systems for data validation, transaction-level reconciliation, and root-cause investigation between source systems and reporting outputs.
Ability to manage multiple concurrent initiatives, balance competing priorities, and communicate status, risks, and tradeoffs.
Strong cross-functional collaboration skills, including partnering with Data Engineering and IT to define data needs and troubleshoot data or reporting issues.
Strong communication skills and ability to present complex data as clear, concise insights for technical and non-technical audiences.
High attention to detail and data quality, with a consistent track record of meeting commitments.
Effective verbal and written communication in English.
Successful completion of a background check, including employment and education verification where applicable.

Nice To Haves

VBA/macros experience.
SAP BusinessObjects experience.
Experience with ERP platforms such as Microsoft Dynamics 365 or comparable systems.
Working proficiency with SQL.
Familiarity with Python.
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.

Responsibilities

Use Excel, SQL, or Power BI according to the speed, complexity, and long-term needs of the problem.
Build interim solutions such as Excel models, Power Query transformations, quick extracts, reconciliations, and SQL queries while planning future-state automation.
Investigate process and data issues, identify root causes with business and technical partners, and document findings.
Translate complex problems and supply chain needs into actionable insights, data models, analyses, reports, KPIs, and decision tools.
Develop, enhance, and maintain BI solutions and reports using Power BI, DAX, SAP BusinessObjects, and Excel/VBA.
Design and maintain Power BI semantic models and datasets, improving usability, performance, and refresh reliability.
Validate and reconcile data and KPIs against ERP and other source systems; perform QA and investigate variances.
Analyze trends, risks, and opportunities and provide practical recommendations to stakeholders.
Lead requirements-gathering workshops and document functional specifications and acceptance criteria.
Provide advanced break-fix reporting support, including triage, root-cause analysis, resolution documentation, and escalation when appropriate.
Manage reporting initiatives and enhancements through intake, prioritization, scope, timelines, risks, dependencies, stakeholder communications, and backlog maintenance.
Collaborate with Data Engineering and IT to define data requirements, improve pipeline reliability, resolve data issues, and ensure governed datasets support reporting end-to-end.
Provide timely ad hoc analysis and reporting, document logic and assumptions, and standardize recurring requests where appropriate.
Standardize KPI definitions, improve data literacy, and increase adoption of self-service reporting.
Support continuous improvement initiatives with business leaders and process owners.
Mentor Business Analysts on data modeling, DAX best practices, visualization standards, QA, documentation, and report lifecycle management.
Communicate scope, timelines, dependencies, release cadence, status, and risks to maintain stakeholder alignment.
Perform additional duties as assigned.