Analyst, Process Improvement

Ross Stores, Inc.; Dublin (CA); Hybrid; USD 81,000 - 122,000; Full time

Job summary

Ross Stores, Inc. is seeking an Analyst, Process Improvement to design and modernize data-driven tools for the Allocation organization.

The role emphasizes building scalable reports, dashboards, and interfaces using Excel (VBA), Access, and SQL Server, with cross-functional collaboration. The position requires the ability to analyze complex data, troubleshoot production reports, and document technical solutions while reducing technical debt and ensuring reliability.

Qualifications

• Bachelor's degree preferred.
• Strong analytical skills to interpret data and generate actionable insights.
• Excellent written and verbal communication, with ability to explain technical concepts to non-technical stakeholders.

Responsibilities

• Design, build, enhance, and maintain moderately complex tools and reports for Allocation.
• Use Excel (VBA), Access, and SQL Server to implement data solutions and business logic.
• Troubleshoot defects and data issues in production reports and applications.
• Refactor legacy solutions to improve stability, scalability, and maintainability.
• Document technical designs and maintain end-to-end production support.

Skills

Analytical thinking

Documentation

Communication

Team collaboration

Education

Bachelor's Degree

Tools

VBA

Microsoft Access

SQL Server

Python

Job description

Our values start with our people, join a team that values you!

Bring your talents to Ross, our leading off-price retail chain with over 2,200 stores, and a strong track record of success and growth. Our focus has always been bringing our customers a constant stream of high-quality brands and on-trend merchandise at extraordinary savings. All while providing a fun and exciting treasure hunt experience.

As Part Of Our Team, You Will Experience

• Success. Our winning team pursues excellence while learning and evolving
• Career growth. We develop industry leading talent because Ross grows when our people grow
• Teamwork. We work together to solve the hard problems and find the right solution
• Our commitment to Diversity, Equality & Inclusion, and our community. We celebrate the backgrounds, identities, and ideas of those who work and shop with us because our differences make us stronger. We strive to be a positive force in our community.

Our Corporate headquarters are in Dublin, CA, we have 3 buying offices in key markets in New York City, Los Angeles, and Boston, and 8 distribution centers nationwide. With 2025 revenues of $22.8 billion, we are a Fortune 500 company who is committed to providing an inclusive work environment with continuous learning opportunities and development for our teams.

GENERAL PURPOSE

The Analyst, Process Improvement is an individual contributor role responsible for the design, enhancement, support, and ongoing modernization of business critical, data driven tools and reporting solutions that enable the Allocation organization. The role applies technical expertise and business knowledge to deliver reliable, scalable solutions that improve operational efficiency, data accuracy, and decision making.

This position independently analyzes complex business problems, interprets ambiguous requirements, and determines appropriate technical approaches using established technologies, including Excel (VBA and advanced functions), Microsoft Access (macros and queries), and SQL Server. The Analyst exercises discretion and judgment in balancing speed, quality, risk, and long term maintainability when delivering solutions.

The Analyst works both independently and as part of cross functional project teams, partnering closely with business stakeholders, project managers, and technical peers. In addition to project delivery, the role is accountable for maintaining and supporting production tools, resolving defects, improving performance, end to end designs and reducing technical debt. The position requires continuous learning to adopt new tools, methods, or technologies as business needs evolve.

Essential Functions

Technical Standards

• Design, build, enhance, and maintain moderately complex tools, reports, and automated processes that support core Allocation business functions
• Utilize Excel (including VBA), Microsoft Access (queries and macros), and SQL Server to implement data solutions and business logic.
• Troubleshoot and resolve defects, data issues, and performance concerns in production reports and applications.
• Refactor and modernize legacy solutions to improve stability, scalability, performance, and long term supportability.
• Develop technical designs that meet current business requirements while enabling future enhancements.
• Produce and maintain clear technical documentation to support ongoing maintenance, knowledge transfer, and auditability.
• Adhere to internal development standards, data governance practices, and security requirements.
• Ensure solutions are tested, validated, and delivered with a high degree of accuracy and reliability.

Planning and Organizing

• Independently scope assigned work, assess complexity, and estimate effort and timelines for projects and enhancements.
• Plan and prioritize personal workload in alignment with business priorities and project commitments.
• Balance project deliverables with ongoing production support and operational requests.
• Identify risks, constraints, and dependencies, and proactively communicate concerns or needed adjustments.
• Recommend alternative technical approaches when appropriate to manage risk, cost, or timing.

Communication

• Collaborate with business partners, project managers, and technical team members to gather requirements and deliver solutions.
• Translate business needs into clear technical designs and explain technical concepts to non technical stakeholders.
• Provide regular updates on work progress, risks, and outcomes.
• Partner with Process Improvement team members to share knowledge, best practices, and lessons learned.
• Contribute to team discussions and process improvements through documented outcomes and recommendations.

ESSENTIAL FUNCTIONS (cont.)

COMPETENCIES

• Communication
• Analytics & Data Analysis
• Innovation
• Decision Quality
• Attention to Detail
• Drives Results
• Planning & Organizing
• InitiativeInterpersonal Effectiveness
• Builds Relationships
• Collaboration
• Process Improvement
• Technical / Functional Competence
• Customer Focus
• Business Acumen
• Change Management
• Adaptability

Qualifications & Special Skills Required

• 1-2 years’ experience developing, enhancing, or supporting business critical reports, databases, or automated processes in a professional environment.
• Proficiency in VBA for developing, maintaining, and debugging Excel based automation; experience with Python or similar scripting languages is a plus.
• Proficiency in Microsoft Access, including creating and maintaining macros, queries, and data-driven applications used for reporting or operational workflows.
• Working proficiency in SQL Server, including:
• Writing and optimizing SQL queries involving joins, aggregations, and subqueries
• Working with tables, views, and basic stored procedures
• Understanding relational data models and data dependencies
• Ability to integrate and manage data flows between Excel, Access, and SQL Server solutions.
• Strong analytical skills with the ability to independently analyze complex data sets, identify issues, and develop actionable recommendations.
• Ability to document technical solutions, logic, and processes for long term support and knowledge transfer.
• Strong verbal and written communication skills, with the ability to explain technical concepts to non technical audiences.
• Knowledge of retail math concepts (e.g., sales, inventory, forecasting), preferred.
• Retail software experience, a plus (JDA or Other Allocation Software)

EDUCATION / CERTIFICATIONS

Bachelor’s Degree, preferred

Physical Requirements

Consistent timeliness and regular attendance

However, this role can perform duties effectively using a combination of in-office and remote work

Job requires ability to work in an office environment, primarily on a computer

Requires sitting, standing, walking, hearing, talking on the telephone, attending in-person meetings, typing, and working with paper/files, etc

This role requires regular in-office presence, including to engage in in-person team interaction, meetings and collaboration, client support, and/or feedback

Vision requirements: Ability to see information in print and/or electronically

DISCLAIMER

This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at management's discretion.

Ross is an equal employment opportunity employer. We consider individuals for employment or promotion according to their skills, abilities and experience. We believe that it is an essential part of the Company's overall commitment to attract, hire and develop a strong, talented and diverse workforce. Ross is committed to complying with all applicable laws prohibiting discrimination based on race, color, religious creed, age, national origin, ancestry, physical, mental or developmental disability, sex (which includes pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), veteran status, military status, marital or registered domestic partnership status, medical condition (including cancer or genetic characteristics), genetic information, gender, gender identity, gender expression, sexual orientation, as well as any other category protected by federal, state or local laws.

The base pay range for this role $81,000.00 to $121,800.00. The base pay range is dependent on factors including, but not limited to, experience, skills, qualifications, relevant education, certifications, seniority, and location. The range listed is just one component of the total compensation package for employees. Other rewards vary by position and location.