Share This Job
Consultant, Supply Chain Business Analyst
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:
Hyper Text Markup Language (HTML); Cascading Style Sheets (CSS); Analytical Thinking; Customer Service; Chatbots; Algorithms; Data Modeling; Agile Methodology; Natural Language Processing (NLP); Group Problem Solving; Server-Side Development; Oral Communications; Azure Bot Service; JavaScript; Artificial Intelligence Technologies; Written Communication; Data Mining; Teamwork; Adaptability; Self-Starter; Machine Learning
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.
