Women of the Vine & Spirits
Overview
Must be eligible to work in the US without sponsorship. The SCM Analytics Developer will partner with functional members of Supply Chain to understand the current and future business requirements. They will be responsible for gathering data across various sources, analyzing it, and providing insights used for informed decision-making. They will ensure the appropriate use of analytical tools so that analysis and reporting are accurate, timely, thorough, and professional. They will also optimize existing data processes and resources, setting clear goals and benchmarks for improvement, development, and effective management of sound business practices. Primary Responsibilities
Develop reporting on SAP Business Objects, Tableau Dashboards, and create Excel refreshable files through Open Database Connectivity (ODBC) connections and Power Queries Automate processes using Amazon Web Services (AWS), including Step Functions, EventBridge, Simple Storage Service (S3) Buckets, and AWS Glue. Additionally, leverage SharePoint Site services—such as lists and workflows—integrated through Power Automate Maintain data quality through identifying issues, removing duplicates, data cleansing, and enriching data quality Develop, design, and manage efficient processes, tabular reports, list reports, score cards, dynamic models, and dashboards that effectively monitor various key performance indicators (KPIs) and assist the supply chain business teams Apply the appropriate use of analytical tools to optimize reporting for current business requirements and create new processes and solutions for future business requirements Provide mentoring and support to other analysts to assist in their development surrounding data, processes, reporting, and utilizing self-service tools Assist with timely, accurate, pertinent information and analysis, as well as aid in monitoring, evaluating, and improving performance and related metrics of the Supply Chain Additional Primary Responsibilities
Support the long-term vision of the supply chain through the effective implementation of data reporting Ability to understand and translate data into business insights Summarize analysis and findings for users Ability to join data from multiple systems and sources through the use of Excel, SQL, Python, AWS services, and other components Ability to mine large sets of data analytics and insights Perform other job-related duties as assigned Minimum Qualifications
Bachelor's Degree and three years of experience or equivalent education and related experience Experience in data preparation, blending, discovery, and visualization using modern BI & Analytics tools such as AWS services like Step Functions, Glue, Sage Maker, and other components, SAP Business Objects, Tableau, Alteryx, and Excel Expert knowledge in Excel, including pivot tables, Power Queries, vlookup, and other advanced formulas Intermediate knowledge of SQL (Joins, Stored Procedures, Views, Jobs, and Troubleshooting) Experience developing, improving, and streamlining processes and reporting Thorough analytical, investigative, and problem-solving skills Timeliness, accuracy, and professionalism Physical Demands
Physical demands include a considerable amount of time sitting and typing/keyboarding, using a computer (e.g., keyboard, mouse, and monitor), or a mobile device Physical demands with activity or condition may occasionally include walking, bending, reaching, standing, squatting, and stooping May require occasional lifting/lowering, pushing, carrying, or pulling up to 20lbs EEO Statement
Southern Glazer's Wine and Spirits, an Affirmative Action/EEO employer, prohibits discrimination and harassment of any type and provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. SGWS complies with all federal, state and local laws concerning consideration of a qualified applicant's arrest and/or criminal conviction records. Southern Glazer's Wine and Spirits provides competitive compensation based on estimated performance level consistent with the past relevant experience, knowledge, skills, abilities and education of employees. Unless otherwise expressly stated, any pay ranges posted here are estimates from outside of Southern Glazer's Wine and Spirits and do not reflect Southern Glazer's pay bands or ranges.
#J-18808-Ljbffr
Must be eligible to work in the US without sponsorship. The SCM Analytics Developer will partner with functional members of Supply Chain to understand the current and future business requirements. They will be responsible for gathering data across various sources, analyzing it, and providing insights used for informed decision-making. They will ensure the appropriate use of analytical tools so that analysis and reporting are accurate, timely, thorough, and professional. They will also optimize existing data processes and resources, setting clear goals and benchmarks for improvement, development, and effective management of sound business practices. Primary Responsibilities
Develop reporting on SAP Business Objects, Tableau Dashboards, and create Excel refreshable files through Open Database Connectivity (ODBC) connections and Power Queries Automate processes using Amazon Web Services (AWS), including Step Functions, EventBridge, Simple Storage Service (S3) Buckets, and AWS Glue. Additionally, leverage SharePoint Site services—such as lists and workflows—integrated through Power Automate Maintain data quality through identifying issues, removing duplicates, data cleansing, and enriching data quality Develop, design, and manage efficient processes, tabular reports, list reports, score cards, dynamic models, and dashboards that effectively monitor various key performance indicators (KPIs) and assist the supply chain business teams Apply the appropriate use of analytical tools to optimize reporting for current business requirements and create new processes and solutions for future business requirements Provide mentoring and support to other analysts to assist in their development surrounding data, processes, reporting, and utilizing self-service tools Assist with timely, accurate, pertinent information and analysis, as well as aid in monitoring, evaluating, and improving performance and related metrics of the Supply Chain Additional Primary Responsibilities
Support the long-term vision of the supply chain through the effective implementation of data reporting Ability to understand and translate data into business insights Summarize analysis and findings for users Ability to join data from multiple systems and sources through the use of Excel, SQL, Python, AWS services, and other components Ability to mine large sets of data analytics and insights Perform other job-related duties as assigned Minimum Qualifications
Bachelor's Degree and three years of experience or equivalent education and related experience Experience in data preparation, blending, discovery, and visualization using modern BI & Analytics tools such as AWS services like Step Functions, Glue, Sage Maker, and other components, SAP Business Objects, Tableau, Alteryx, and Excel Expert knowledge in Excel, including pivot tables, Power Queries, vlookup, and other advanced formulas Intermediate knowledge of SQL (Joins, Stored Procedures, Views, Jobs, and Troubleshooting) Experience developing, improving, and streamlining processes and reporting Thorough analytical, investigative, and problem-solving skills Timeliness, accuracy, and professionalism Physical Demands
Physical demands include a considerable amount of time sitting and typing/keyboarding, using a computer (e.g., keyboard, mouse, and monitor), or a mobile device Physical demands with activity or condition may occasionally include walking, bending, reaching, standing, squatting, and stooping May require occasional lifting/lowering, pushing, carrying, or pulling up to 20lbs EEO Statement
Southern Glazer's Wine and Spirits, an Affirmative Action/EEO employer, prohibits discrimination and harassment of any type and provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. SGWS complies with all federal, state and local laws concerning consideration of a qualified applicant's arrest and/or criminal conviction records. Southern Glazer's Wine and Spirits provides competitive compensation based on estimated performance level consistent with the past relevant experience, knowledge, skills, abilities and education of employees. Unless otherwise expressly stated, any pay ranges posted here are estimates from outside of Southern Glazer's Wine and Spirits and do not reflect Southern Glazer's pay bands or ranges.
#J-18808-Ljbffr