SCM Analytics Engineer

Southern Glazer's•Miramar, FL

About The Position

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 Glazer’s isn't just one of Forbes’ Top Private Companies; it's a family-owned business with deep roots dating back to 1933. The reputation of Southern Glazer’s is well-established, and it's no surprise that we are regularly recognized for our culture. Southern Glazer’s has been recognized by Newsweek as one of America’s 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 Glazer’s, you would be part of a team that values excellence, innovation, and community. This is more than just a job – it's 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.

Requirements

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

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 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 (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
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