Role Objective - This role is responsible for leading the design, development, and implementation of business intelligence solutions to support Supply Chain Management. The Associate Manager will ensure data integrity, develop robust ETL pipelines, and provide actionable insights through multidimensional analysis and reporting. This includes collaborating across departments to meet business needs and troubleshoot any data-related challenges. On a typical day you will drive the following•Design, develop and implement technical solutions to support supply chain decision-making•Write and optimize SQL queries and stored procedures for ad-hoc data extraction and reporting•Develop and maintain SSIS packages for ETL processes from various sources (Files, Redshift) into the data warehouse•Build and maintain SSAS Multidimensional Cubes and SSRS reports•Analyze and troubleshoot data discrepancies, debug complex SQL logic, and support production systems•Work with different teams to make sure reports and data are delivered on time and are correct.You will bring the following to the table:
