Job
Description
A Merchandising Analyst plays a pivotal role in driving the performance of product assortments by leveraging data to optimize strategies. They are responsible for analyzing key trends across sales, margins, inventory, turnover, and other critical KPIs. By incorporating macroeconomic factors and leveraging forecasted expectations, they develop effective strategies to maximize revenue and margins, optimize inventory levels, and ensure customer needs are met efficiently. The ideal candidate should possess strong technical expertise, enabling them to conduct root cause analyses, A/B testing, hypothesis testing, and regression analysis. Their insights should translate into actionable recommendations that drive business results. Additionally, they are expected to collaborate with cross-functional teams to integrate metrics beyond merchandising and engage stakeholders to understand and address their specific requirements effectively. Job Summary: The primary purpose of this role is to perform mathematical and statistical analysis or model building as appropriate. This includes following analytical best practices, analyzing and reporting accurate results, and identifying meaningful insights that directly support decision making. This role provides assistance in supporting one functional area of the business in partnership with other team members. At times, this role may work directly with the business function, but the majority of time is spent working with internal team members to identify and understand business needs. Roles & Responsibilities: Core Responsibilities: Conduct in-depth analysis of business trends, financial performance, and market conditions. Develop and maintain data models, dashboards, and reports to support business decisions. Identify opportunities for operational improvements and recommend strategic solutions. Collaborate with cross-functional teams to translate data insights into actionable strategies. Ensure data accuracy, integrity, and security while handling large datasets. Present findings and recommendations to leadership in a clear and concise manner Years of Experience: 1 to 3 yrs of experience data analytics Education Qualification & Certifications (optional) Required Minimum Qualifications : Bachelors degree in business administration, computer science, computer information systems (CIS), engineering, or related field (or equivalent work experience in lieu of degree) Skill Set Required Experience using basic analytical tools such as R, Python, SQL, SAS, Adobe, Alteryx, Knime, Aster Experience using visualization tools such as Power BI, Tableau Secondary Skills (desired) Experience with business intelligence and reporting tools (e.g., MicroStrategy, Business Objects, Cognos, Adobe, TM1, Alteryx, Knime, SSIS, SQL, Svr) and Enterprise level databases (Hadoop, GCP, Azure, Oracle, Teradata, DB2) Experience working with big, unstructured data in a retail environment Experience with analytical tools like Python, Alteryx, Knime, SAS, R, etc. Experience with visualization tools like MicroStrategy VI, Power BI, SAS-VA, Tableau, D3, R-Shiny Programming experience using tools such as R, Python Data Science experience using tools such as ML, Text mining Knowledge of SQL Project management experience Experience in home improvement retail
