Business Insights Analyst

Who is Swire Coca-Cola? We are a family-owned bottling company with a story spanning over two centuries. We are one of the largest bottlers of Coca-Cola in North America and distribute more than 50 beverage brands and flavors creating joy for our customers every day. Our 8,000+ driven employees work hard as part of a team that delivers refreshment to over 30 million consumers across 13 states. Begin a journey with us at Swire Coca-Cola and belong to a community of dedicated team members who think big and believe in winning together.

Why you’ll love working at Swire Coca-Cola:
Swire Coca-Cola is committed to providing balance to support you in all aspects of your life, both at work and beyond. We offer the benefits you need for physical, financial, and emotional well-being.

• Health coverage (3 medical options, dental and vision). 401(k) Retirement Plan w/company match
• Health Savings Accounts w/company match
• FREE virtual primary care, acute care and physical therapy
• FREE Employee Assistance Program
• Company paid (vacation, holidays, sick time, bereavement, jury duty, maternity/parental, disability leave and volunteer time)
• Discounted & free product
• Tuition reimbursement
• Opportunities for career advancement
In addition to health benefits, Swire Coca-Cola is proud to offer you opportunities where you help give back directly to the communities and causes you care about. Note: Enrollment in a Swire Medical Plan is required for some benefits.
Job Details:
Schedule: This position is required to be on-site 5 days a week. It can be located in either Draper, UT, Tempe, AZ or Bellevue, WA.
Job Level: 5


What does a Business Insights Analyst do at Swire Coca-Cola?
We are seeking a talented and driven Business Insights Analyst II to join our Data Apps team. In this role, you will leverage your strong knowledge and experience with SQL Databases and business intelligence reporting tools to develop comprehensive business intelligence reports and conduct ad hoc analysis. You will be responsible for understanding data management policies, procedures, and best practices, and effectively communicating and presenting your findings to key stakeholders. Your proficiency with Microsoft Office and your demonstrated skills in organizational, problem-solving, and interpersonal areas will be crucial. If you have a deep understanding of Business Intelligence processes and workflows, knowledge of sales and business processes, and the ability to balance multiple priorities while being detail-oriented and an effective communicator, we want to hear from you! Preference will be given to candidates with experience in Consumer-Packaged Goods, Food and Beverage Manufacturing, or Retail business.

Responsibilities:
• Conduct end-to-end research and analysis of business opportunities, build financial models, and develop business intelligence reports with little or no direction
• Engage business units as a business intelligence consultant to develop enterprise analytics in direct support of various departments
• Enhance the efficiency of monthly processes and track key business indicators as requested by management
• Implement improvements to existing reporting through automation and integration
• Collaborate with the data warehousing team for data engineering and modeling requirements
• Guide systems development including DOMO, Power BI, and Azure SQL to help create a more accountable, performance-driven culture
• Produce intelligent analysis and reporting in support of Category and Sales teams
• Train Business Insights Analyst I in data systems, team processes, and data visualization best practices

Requirements
• Bachelor's Degree Science, Technology, Engineering, Math, or quantitative discipline required
• 2+ years’ Experience using large complex data sets to produce reporting and insights required
• 2+ years Creating Visualizations using Microsoft Power BI, Tableau, or similar reporting tools required
• 2+ years’ Experience with SQL, Python, R, and other languages required
• 2+ years ETL or data engineering specific experience preferred
• 2+ years’ Experience with Snowflake or other cloud providers preferred


Come and join our Sparkling team!


Base pay range is $90,842 to $119,231 plus bonus structure (dependent on role). Pay offered will depend on candidate’s geographic location, prior relevant experience, knowledge, skills, & abilities.


At Swire Coca-Cola, we offer a comprehensive benefits package for full-time associates and their families. Benefit options include: Medical, Dental, Vision, Pharmacy, Medical FSA, Dependent Care FSA, Health Savings Account, Life Insurance, Supplemental Life Insurance, Accidental Death & Dismemberment Insurance, Short-Term Disa