Senior Business Analyst

CooperCompanies•Trumbull, CT

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

About The Position

The Senior Business Analyst is a hands-on problem-solving role on CooperSurgical’s Global Supply Chain Data Analytics & Data Science team. The position supports Global Supply Chain by defining business requirements, translating ambiguous business problems and process needs into actionable insights and scalable analytics solutions, and driving operational improvements through reporting, KPI frameworks, and decision-support tools. The role works with supply chain processes such as planning, inventory, manufacturing, logistics, and service levels, and partners across Operations, Engineering, Sales, Finance, R&D, IT, and Global Management. The Senior Business Analyst uses the appropriate mix of Excel, SQL, Power BI, source-system knowledge, and practical business judgment to address process and data challenges. The role delivers quick, usable solutions such as Excel tools, queries, reconciliations, and lightweight dashboards while moving recurring needs toward robust, automated, scalable solutions. It develops and maintains Power BI reporting and semantic models, improves data quality and refresh reliability, and provides advanced break-fix support and root-cause analysis for global reporting products. As a senior contributor, the role manages reporting initiatives through their lifecycle and mentors Business Analysts in data modeling, DAX, visualization standards, quality assurance, documentation, and report lifecycle management. The position is based on-site in Trumbull, Connecticut, or Livingston, New Jersey, and may require up to 10% domestic travel.

Requirements

3–5 years of experience in business intelligence, analytics, business analysis, or related roles.
Experience or strong knowledge of supply chain, including 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 creation of maintainable operational tools.
Intermediate proficiency in Power BI and DAX, including report design, data modeling, visualization, and performance optimization.
Strong analytical skills and the ability to learn complex processes, understand key data flows, and identify improvement opportunities.
Experience using ERP or other 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 working with Data Engineering and IT to define data needs and troubleshoot reporting or data issues.
Strong communication skills and the ability to distill complex data into 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 or 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 a business problem.
Build interim or manual solutions—including Excel models, Power Query transformations, extracts, reconciliations, and SQL queries—while designing 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 process needs into clear analyses, data models, reports, KPIs, and decision tools.
Drive the transition from manual to semi-automated and fully automated solutions.
Develop, enhance, and maintain BI solutions and reporting using Power BI, DAX, Excel/VBA, and SAP BusinessObjects where applicable.
Design and maintain Power BI semantic models and datasets to improve usability, performance, and refresh reliability.
Validate and reconcile data and KPIs against ERP and other source systems; conduct QA, investigate variances, and document findings.
Analyze trends, risks, and opportunities and translate insights into practical recommendations.
Lead requirements-gathering workshops and document functional specifications and acceptance criteria.
Provide break-fix reporting support, including issue triage, root-cause analysis, resolution documentation, and escalation of complex issues.
Manage reporting initiatives and enhancements, including intake, prioritization, scope, timelines, risks, dependencies, stakeholder communication, and a structured backlog.
Collaborate with Data Engineering and IT on data requirements, source-system integration, dataset design, pipeline reliability, data issues, and end-to-end data lineage.
Provide timely ad hoc analysis and reporting; document logic and assumptions and standardize recurring requests where appropriate.
Collaborate with the analytics team to standardize KPI definitions, improve data literacy, and increase adoption of self-service reporting.
Support continuous improvement initiatives with business leaders and process owners.
Lead reporting initiatives through intake, discovery, requirements, development, QA/UAT, release, training, adoption, and iterative enhancement.
Communicate scope, timelines, dependencies, release cadence, status, and risks proactively to stakeholders.
Mentor Business Analysts in data modeling, DAX best practices, visualization standards, QA, documentation, and report lifecycle management.
Perform additional duties as assigned.