Business Analyst III

Company: Integrated Resources, Inc
Location: Miami
Posted on: January 27, 2023

Job Description:

Update:

3+ years of experience with SQL (complex queries and joins, advanced functions, etc.)
3+ years of experience producing in depth data-driven analysis with large datasets
3+ years of experience using advanced Excel features (pivot tables, embedded queries, pivots, macros, etc)

Other: Result driven, agility, analytical, experience in retail environment or inventory forecasting, bilingual plus

The Category Specialist will be located in Clients Merchandising Department in Miami, FL. You will drive budgeted sales, gross margin, and grow market share within your assigned categories. Overall, you will be responsible for delivering on the merchandising objectives as they relate to the Client Alternative formats business unit, including Hispanic and Value format focus.

Responsibilities
Contribute directly to sales and margin goals in assigned category.
Analyze profit and loss information for the category, develop sales and margin projections, and assist Category Manager in P&L reconciliation.
Responsible planogram review and assortment and flow optimization.
Analyze relevant data and incorporate findings and recommendations into Category Plans (i.e., optimal SKU mix; promotional programs) for merchandising programs from 1 to 3 years.
Drive tactical execution of day-to- day plan activities (e.g., builds off-shelf plans, seasonal programs, track promotional period and performs post appraisal to take corrective action if necessary.
Responsible for promotional strategy and execution.
Collaborate with an internal team of Client professionals in Inventory, Pricing, Promotion, Finance, Store Brands, Store Design and Store Operations.
Analyze sales records and inventory levels of current stock; seek new, alternative foreign and domestic suppliers.
Develop and maintain a strong understanding of current competition; search out new competitive opportunities and make recommendations.
Keep abreast of changes in the market.
Research customer product preferences, supplier prices and the competitive environment.

Requirements
Bachelors Degree preferred or equivalent experience
1 to 3 years of experience in a retail organization or in an analytical, merchandising, or buying position preferred
Strong working knowledge of retail math concepts and demonstrated application
Proven ability to implement strategies and use negotiation tactics to grow sales
Technical experience in MS Office, Word, Excel, SQL advanced, PowerPoint; some Access or other database knowledge.

Willingness to travel 5-10%.

Preferred Qualifications
Bilingual preferred

Position Summary:

Contribute directly to sales and margin goals in assigned category.
Analyze profit and loss information for the category, develop sales and margin projections, and assist Category Manager in P&L reconciliation.
Responsible planogram review and assortment and flow optimization.
Analyze relevant data and incorporate findings and recommendations into Category Plans (i.e., optimal SKU mix; promotional programs) for merchandising programs from 1 to 3 years.
Drive tactical execution of day-to- day plan activities (e.g., builds off-shelf plans, seasonal programs, track promotional period and performs post appraisal to take corrective action if necessary.
Responsible for promotional strategy and execution.
Collaborate with an internal team of Client professionals in Inventory, Pricing, Promotion, Finance, Store Brands, Store Design and Store Operations.
Analyze sales records and inventory levels of current stock; seek new, alternative foreign and domestic suppliers.
Develop and maintain a strong understanding of current competition; search out new competitive opportunities and make recommendations.
Keep abreast of changes in the market.
Research customer product preferences, supplier prices and the competitive environment.

Bilingual preferred (English & Spanish)
Willingness to travel 5-10%.

Duties:

Contribute directly to sales and margin goals in assigned categories.
Analyze profit and loss information for the category, develop sales and margin projections, and assist Category Manager in P&L reconciliation.
Responsible planogram review and assortment and flow optimization.
Analyze relevant data and incorporate findings and recommendations into Category Plans (i.e., optimal SKU mix; promotional programs) for merchandising programs from 1 to 3 years.
Drive tactical execution of day-to- day plan activities (e.g., builds off-shelf plans, seasonal programs, track promotional period and performs post appraisal to take corrective action if necessary.
Responsible for promotional strategy and execution.
Collaborate with an internal team of Client professionals in Inventory, Pricing, Promotion, Finance, Store Brands, Store Design and Store Operations.
Analyze sales records and inventory levels of current stock; seek new, alternative foreign and domestic suppliers.
Develop and maintain a strong understanding of current competition; search out new competitive opportunities and make recommendations.
Keep abreast of changes in the market.
Research customer product preferences, supplier prices and the competitive environment.

Experience:

1 to 3 years of experience in a retail organization or in an analytical, merchandising, or buying position preferred
Strong working knowledge of retail math concepts and demonstrated application
Proven ability to implement strategies and use negotiation tactics to grow sales
Technical experience in MS Office, Word, Excel, SQL advanced, PowerPoint; some Access or other database knowledge.

Education:

Must have Highschool diploma
Bachelors Degree preferred or equivalent experience







What days & hours will the person work in this position? List training hours, if different.





Monday -Friday 8-5






Type of Start





Individual starts










Is this an in-person, patient-facing role?





No






Onsite Requirements





Onsite as needed

Keywords: Integrated Resources, Inc, Miami , Business Analyst III, Professions , Miami, Florida