Junior Excel Data Analyst Jobs in Rochester, NY (NOW HIRING)

At CooperVision, a division of CooperCompanies, we're driven by a unifying purpose to help people to experience life's beautiful moments. We are connected through our shared values - dedicated, innovative, friendly, partners, and do the right thing. As a leading global manufacturer of contact lenses, we are committed to helping improve the way people see each day. Through our diverse lens portfolio, we tackle the toughest vision challenges - including astigmatism, presbyopia, and childhood myopia. We offer the most complete collection of spherical, toric, and multifocal products available, enabling us to fit 99% of all contact wearers. Learn more at www.coopervision.com.

Job Summary:

Collects, analyzes, and interprets operational data to improve distribution performance and support data-driven decision-making. Focuses on executing well-defined analytic work with growing autonomy. This involves creating new analyses, and dashboards, or updating more complex dashboards/reporting. The role develops reports, KPIs, dashboards, and analytical tools using SQL and data visualization platforms such as Tableau or Power BI. This position collaborates closely with management and business partners to define analytical requirements, recommend solutions, and communicate insights to both technical and non-technical audiences. Strong analytical reasoning, data storytelling, and attention to data quality are essential. This role provides mentorship to junior analysts.

Knowledge, Skills and Abilities:

Required:

• Bachelor's degree in a related field required (Data Analytics, Data Science, Computer Science, Math, Cyber Security, Information Technology, etc.), or 5+ years of relevant experience.
• Relevant experience with Tableau or PowerBI required.
• Preferred experience in a warehouse setting or manufacturing.
• 1-3+ years of experience in SQL, including queries, joins, transformations, and data aggregation.
• 1-3+ years of experience with Tableau Desktop, PowerBI, or equivalent data visualization tools.
• Entry-level to moderate experience performing data analysis and reporting, and utilizing analytical and problem-solving skills.
• Working knowledge of data warehousing concepts, data modeling, and ETL processes.
• Proficiency in Microsoft Office tools, including Excel and SharePoint.
• Ability to follow standardized processes related to project management, data governance, and IT security.
• Strong verbal and written communication skills, with the ability to explain technical concepts to non-technical audiences.

Preferred:

• Experience with Snowflake, Microsoft SQL Server Management Studio (SSMS), Oracle GoldenGate, DBeaver, etc.
• Experience with Tableau Prep, Alteryx, or similar data preparation tools.
• Experience using Python or R for analytics or automation.
• Experience working within a team, and with other teams or departments.

Work Environment:

• Normal warehouse and office environment with some exposure to dust, heat, and cold.
• May include prolonged sitting in front of a computer.

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 $71,971.00 and $ 95,961.00 per year and may include cost of living adjustments.  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.

• Collect, cleanse, transform, and analyze large operational datasets to identify trends, risks, and opportunities for improvement. 
• Develop, enhance, and maintain dashboards, reports, and visualizations using Tableau Desktop or similar tools. 
• Apply statistical and analytical techniques to perform descriptive, diagnostic, and trend-based analysis. 
• Translate business questions into structured analytical approaches and clearly communicate findings and recommendations. 
• Validate and quality-check data sources, queries, and visualizations to ensure accuracy, consistency, and reliability. 
• Partner with cross-functional teams to understand operational needs and deliver analytical solutions aligned with business priorities. 
• Support the implementation of improved reporting methodologies, automation, or analytical tools. 
• Maintain documentation and adhere to established departmental, IT, and project management standards. 
• Prioritize and manage multiple analytical requests in alignment with business objectives and timelines. 
• The role progresses through impact, autonomy, and analytical complexity, as well as ability to handle sensitive information. 

Travel: 

Occasional travel may be required (5-10%+ annually). This is an on-site position requiring daily in-office attendance Monday through Friday, and as needed.