Consultant, Supply Chain Business Analyst

Location(s):

United States of America

City/Cities:

Remote

Travel Required:

00% - 25%

Relocation Provided:

No

Job Posting End Date:

December 18, 2024

Shift:

First Shift (United States of America)

Job Description Summary:

Position Overview: This role offers an opportunity to design and implement end-to-end Data & Analytics solutions, following the software development life cycle principles. Responsibilities will include ETL (extract, transform & load), data processing, data modeling, visualization through reports and dashboards, and ensuring system security. The candidate will also create interfaces to other systems and manage migrations from AWS SQL Server databases to Azure Synapse.

The developer will operate independently, serving as both software architect and development lead for extracting specific data streams from SAP, SQL, and Azure while adhering to DevOps practices.

Function Related Activities/Key Responsibilities:

• End-to-End Analytics Solution Development:
  • Design, build, and implement ETL processes, data models, and analytics dashboards.
  • Ensure compliance with company standards for performance and information security.
  • Collaborate with cross-functional teams to develop solutions that meet business requirements and technical specifications
• System Integration & Migration:
  • Perform migration of AWS SQL Server databases to Azure Synapse.
  • Migrate all stored procedures, SSIS packages, and views to Azure.
  • Rewire reports, Power Apps, Cloud Flows, Desktop Flows, and ETL processes to Azure Synapse.
  • Validate Azure datasets against AWS SQL datasets and SAP data.
• Data & Reporting Automation:
  • Design and drive reporting project automation using tools like Power BI, Alteryx, and Azure Synapse.
  • Coordinate and manage testing of solutions, including UAT, and post-implementation validation.
  • Build automation to improve reporting efficiency and quality across systems.
• System Maintenance & Enhancement:
  • Actively participate in system improvements, including SQL databases, Azure Synapse, Power BI, Anaplan, and other integrated applications.
  • Perform system maintenance, tuning, troubleshooting, and user support.
  • Deliver technical documentation, training, and process improvement recommendations.
• Collaboration & Communication:
  • Partner with planning, operations, customer service, and co-packers to ensure smooth SAP transactions.
  • Support daily SAP activities for raw materials, production, shipments, and procurement.
  • Collaborate with other teams to ensure seamless system integration and communication across platforms.
• Business Process Improvement:
  • Identify and implement process improvement opportunities, focusing on both end-user and operational efficiency.
  • Monitor business metrics, perform root cause analysis, and develop mitigation plans for pain points.
  • Align data solutions with broader organizational goals, delivering business value through technology.
• Co-Man Manual Transaction Support:
  • Support over 12 Co-man facilities by entering manual transactions into SAP.
  • Manage daily manual SAP entries for good receipts of raw materials, finished goods productions.
  • Collaborating with sales, operations, and customer service teams to investigate and resolve post goods issues for shipments.
• Manage and create purchase order procurement process.

Education Requirements:
Bachelor or higher degree in Computer Engineering, Computer Science or equivalent work experience.

Related Work Experience:

• 2-5 years of related work experience
• Strong experience with SAP, SQL, Azure Synapse, Power BI, and data modeling.
• Ability to design and implement end-to-end Data & Analytics solutions.
• Experience migrating databases, stored procedures, and ETL processes to cloud environments.
• Familiarity with process automation tools like Power BI, ORI, Anaplan, Power Apps, Microsoft Desktop Automation and Azure Synapses.
• Ability to collaborate across functions and communicate complex solutions effectively.
• Strong problem-solving skills with a focus on continuous improvement and process optimization.

Technical Skills:

• AGILE
• Python
• Workday
• SQL
• Power Apps
• Power BI
• Power Automate
• Azure Synapse
• Purview
• SAP
• Dev Ops

Skills:

Adaptability, Agile Methodology, Algorithms, Analytical Thinking, Artificial Intelligence Technologies, Azure Bot Service, Cascading Style Sheets (CSS), Chatbots, Customer Service, Data Mining, Data Modeling, Group Problem Solving, Hyper Text Markup Language (HTML), JavaScript, Machine Learning, Natural Language Processing (NLP), Oral Communications, Self-Starter, Server-Side Development, Teamwork, Written Communication

Pay Range:

$97,800 - $116,000

Base pay offered may vary depending on geography, job-related knowledge, skills, and experience. A full range of medical, financial, and/or other benefits, dependent on the position, is offered.

Annual Incentive Reference Value Percentage:

7.5

Annual Incentive reference value is a market-based competitive value for your role. It falls in the middle of the range for your role, indicating performance at target.

Our Purpose and Growth Culture:

We are taking deliberate action to nurture an inclusive culture that is grounded in our company purpose, to refresh the world and make a difference. We act with a growth mindset, take an expansive approach to what’s possible and believe in continuous learning to improve our business and ourselves. We focus on four key behaviors – curious, empowered, inclusive and agile – and value how we work as much as what we achieve. We believe that our culture is one of the reasons our company continues to thrive after 130+ years. Visit Our Purpose and Vision to learn more about these behaviors and how you can bring them to life in your next role at Coca-Cola.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class. When we collect your personal information as part of a job application or offer of employment, we do so in accordance with industry standards and best practices and in compliance with applicable privacy laws.