What are the responsibilities and job description for the Business Insights Analyst position at Swire Coca-Cola?
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.
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:
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 Disability Insurance, Long-Term Disability Insurance, Accident Insurance, Critical Illness Insurance, Employee Assistance Program, Telehealth, Virtual Mental Health Counseling, 401(k) with Company Match, and Tuition Reimbursement. We also offer the following paid time off benefits on a calendar year or anniversary year basis: 120 hours of Paid Vacation, 1 hour of Paid Sick Leave for every 40 hours worked (unless otherwise subject to a more generous local requirement), 7 Paid Holidays, 3 Paid Floating Holidays, 8 hours of Paid Volunteer Leave, up to 8 weeks of Maternity Disability Paid Leave (based on eligibility), and up to 2 weeks of Parental Paid Leave (based on eligibility).
Swire Coca-Cola is an equal employment opportunity and affirmative action employer that participates in the E-Verify program as required by law. All qualified applicants will receive consideration for employment without regard race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status or other legally protected characteristics. Swire Coca-Cola does not sponsor applicants for work visas.
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
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
- 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
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 Disability Insurance, Long-Term Disability Insurance, Accident Insurance, Critical Illness Insurance, Employee Assistance Program, Telehealth, Virtual Mental Health Counseling, 401(k) with Company Match, and Tuition Reimbursement. We also offer the following paid time off benefits on a calendar year or anniversary year basis: 120 hours of Paid Vacation, 1 hour of Paid Sick Leave for every 40 hours worked (unless otherwise subject to a more generous local requirement), 7 Paid Holidays, 3 Paid Floating Holidays, 8 hours of Paid Volunteer Leave, up to 8 weeks of Maternity Disability Paid Leave (based on eligibility), and up to 2 weeks of Parental Paid Leave (based on eligibility).
Swire Coca-Cola is an equal employment opportunity and affirmative action employer that participates in the E-Verify program as required by law. All qualified applicants will receive consideration for employment without regard race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status or other legally protected characteristics. Swire Coca-Cola does not sponsor applicants for work visas.
Salary : $90,842 - $119,231