SCM Analytics Engineer

What You Need To Know

Shape a remarkable future with us. Build a career working for an industry leader that truly invests in their people and equips them with leading technology continuous learning and the ability to bring their best selves to work. As the premier wine and spirits distributor Southern Glazers isnt just one of Forbes Top Private Companies; its a family-owned business with deep roots dating back to 1933.

The reputation of Southern Glazers is well-established and its no surprise that we are regularly recognized for our culture. Southern Glazers has been recognized by Newsweek as one of Americas Greatest Workplaces for Inclusion and Diversity as well as for Women and Parents and Families. These accolades speak volumes about our commitment to creating a supportive and inclusive culture of belonging for all employees.

As a full-time employee you can choose from a wide-ranging menu of our Top Shelf Benefits including comprehensive medical and prescription drug coverage dental and vision plans tax-saving Flexible Spending Accounts disability coverage life insurance plans and a 401(k) plan. We also offer tuition assistance a wellness program parental leave vacation accrual paid sick leave and more.

By joining Southern Glazers you would be part of a team that values excellence innovation and community. This is more than just a job its an opportunity to build the future of beverage distribution and grow with a company that truly cares about its people.

Must be eligible to work as a full-time employee in the US without sponsorship.

Overview

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 leveraged SharePoint Site servicessuch as lists and workflowsintegrated 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 (KPI)s 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

• Bachelors 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 Glazers 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 applicants arrest and/or criminal conviction records. Southern Glazers 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 Glazers Wine and Spirits and do not reflect Southern Glazers pay bands or ranges.

#LI-JL1

If you have any questions or concerns about whether this posting complies/adheres with local pay transparency requirements please contact the SGWS talent acquisition team at