Senior Business Analyst, MicroStrategy

About Ross Stores, Inc.

Welcome to Ross Stores, Inc. Since 1982, our focus has been on bringing our customers a constant stream of high quality brands and trends at extraordinary savings, while providing a fun and exciting treasure hunt experience. We believe in keeping things simple: no expensive signage, displays or fancy fixtures - to us, it's far more meaningful to pass greater savings on to our customers with on trend apparel, accessories, footwear, and home furnishings. With more than 1,800 stores, including Ross Dress for Less and dd's DISCOUNTS, we are the nation's largest off-price retail chain, and we continue to grow at a rate far outpacing traditional retail.

With corporate headquarters located in Dublin, CA, we have three buying offices positioned in key markets in New York City, Los Angeles, and Boston, as well as six state-of-the-art distribution centers across the country. With FY2019 revenues of $16 billion, we are a Fortune 500, S&P 500, and Nasdaq 100 Company, committed to offering an inclusive, safe and positive workplace. Come see what's in store.

At Ross you will find an organization that invites you to be your authentic self. As part of the Ross family you will experience:

A respectful culture embedded with collaborative partnerships and humility

Opportunities to give back to your community through national charities, local volunteer initiatives, and our Ross Cares Fund

A significant investment in your career through extensive onboarding programs, continuous learning opportunities, ongoing development and the opportunity to work with engaged and knowledgeable industry leaders

Additional information is available at:

About this opportunity ….

As a member of the Business Insights team, the Senior Business Analyst will play an important business facing role by being a central point of contact. The BA will partner closely with IT to ensure that reports and data analysis get constructed based on business requests. Key responsibilities include learning the business requirements, understanding functional context of the requests, and appropriately building reports and analysis within the available reporting platforms.


Requirement Gathering and Data Validation

  • Analyze business objectives of the stakeholder and develop solutions to address their business needs
  • Collaborate with key stakeholders to define the project phase plans
  • Document functional and other requirements based on customer or business partner feedback on moderately complex projects
  • Collect and consolidate data from responsible parties to be used for reporting and dashboard creation
  • Write queries (SQL, MDX, etc.) to research and understand the data structure
  • Work with IT/technical resources to translate business requirements; ensure that the dataset/cube are built per requirement
  • Manage issue escalation and resolution during the data validation phase

Report Development and Delivery

  • Develop an understanding of strengths/limitations of various tools and technologies available. Suggest alternate methods of data presentation
  • Leverage the available reporting tools (MicroStrategy, Excel/SSAS, etc.) to create reports, confirm the data integrity via thorough testing
  • Align on the report delivery strategy and ensure the delivery per SLA
  • Lead the pilot effort of new reports and dashboard prior to the deployment and work with IT to incorporate their feedback into the final version of the deliverable
  • Collect user feedback, and provide support as needed
  • Lead post deployment validation as instructed by project leadership or management


Who you are

  • You have demonstrated proficiency in MicroStrategy and Excel and very strong understanding of productivity software (i.e. Microsoft Office.)
  • You have a Bachelor’s Degree with a concentration in Business, Economics, Finance or Computer Science, or an equivalent diploma
  • You bring 3-5 years’ experience in the Retail industry, report building, or equivalent work experience, with suitable working Retail business knowledge (Buying and Planning)
  • You have an innate ability to understand and apply instructions or suggest alternate proven methods to move projects forward
  • You are able to follow established practices, policies and procedures,
  • You bring strong communication skills, strong analytical skills, and the ability to build stable working relationships
  • You are able to create simple to complex analytical solutions, and break abstract analytical problems down into actionable tasks
  • Preferably, you have strong SQL or other database query skills
  • You are able to work in an office environment, primarily on a computer. 
  • You are able to sit, stand, walk, hear, talk on the telephone, attend in-person meetings, type, and work with paper/files, etc.
  • You are consistently on time and have regular attendance.
  • You are able to see information in print and/or electronically.

Perks and Benefits of joining our team….

Our Associates are at the heart of everything we do and we're proud to offer a range of benefits that reflect how much we value their contributions. Here's a peek into what you can expect as an eligible Ross Associate:

A broad range of affordable health insurance options*, 401(k) with employer match*, life insurance*

Ample PTO, paid holidays, and Summer Fridays, as well as the opportunity to purchase additional vacation*

Employee stock purchase plan*

Charitable donations matched by Ross Stores Foundation

Enhanced maternity and bonding leaves with 100% income replacement*

Parent support programs

And more....

* eligibility may vary based on level and tenure, subject to change

At Ross & dd’s we care about our Associates and the communities we serve. We are committed to building diverse teams and an inclusive culture that respects, values and celebrates the diversity of backgrounds, identities, and ideas of those who work and shop with us.