Senior 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.

Job Details: Job Level: 6

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.

What does a Senior Business Insights Analyst do at Swire Coca-Cola?Lead the development and implementation of routine business intelligence reporting and ad hoc analysis for the total business in support of the overall profitability of the company as subject matter expert. In addition, collaborate with other teams to build and own Swire Coca-Cola's reporting layer of data.Responsibilities:

• Lead end to end research and analysis of business opportunities, build financial models, and the develop business intelligence reports with little or no direction

• Partner closely with data engineers to architect and build the reporting layer of data that supports our enterprise source of truth, structuring the data to balance an intuitive user experience with technical performance

• Engage business units as a business intelligence consultant to lead development of enterprise analytics in direct support of various departments

• Research and explore new (raw and unprocessed) data sources to identify growth use cases and test hypotheses.

• Develop and maintain SmartSheet resources including annual budget trackers and funding request systems between Swire and business partners

• Direct systems development including PowerBI and Snowflake to help create a more accountable, performance-driven culture.

• Responsible for effectively training Business Insights Analyst I in data systems, team process, and data visualization best practices

• Responsible for managing workflow and projects for Business Insights Analyst I & II, authority to delegate tasks

• Make operational decisions regarding project timelines, requirements, and BI product development

• Performs other duties as assigned.

Requirements:

• Bachelor's Degree Bachelor's Degree in related field required; STEM related field preferred required

• Master's Degree MBA or related Master's Degree preferred preferred

• 4+ years Experience using large and complex data sets to produce reporting and insights required

• 4+ years Experience with Microsoft Power BI, Tableau or similar reporting tools required

• 4+ years Experience using large and complex data sets to produce reporting and insights required

• 2+ years Experience with Snowflake or other cloud providers preferred

• 2+ years Experience with Python, SQL, VBA, R and other languages preferred

• 1+ years ETL or data engineering specific experience preferred

• 1+ years Building and Managing Smartsheets required

• Demonstrated ability to lead team workflow, manage project milestones, and train junior members.

• Understanding of data management policies, procedures, and best practices

• Ability to communicate and present findings to key stakeholders

• Demonstrated proficiency with Microsoft Office (Excel, Word, PowerPoint, etc.)

• Demonstrated skills – organizational, problem solving, interpersonal, influence, ability to work under pressure and meet deadlines, and work independently

• Demonstrated ability to manage ambiguity and lead development of solutions to un-solved problems

• Proficiency in developing Business Intelligence processes and workflows

• Demonstrated proficiency in SQL

Come and join our Sparkling team!

Due to the nature of our work and to help maintain a safe workplace for our employees and customers, after a candidate receives a conditional offer of employment, they will be required to complete pre-employment screening. This includes a criminal background check, drug screening, and for certain roles, a motor vehicle record review.

Screening results are evaluated based on several factors, including the nature and severity of an offense, how much time has passed, the relevance to the position, patterns of repeated offenses, and driving history for roles that require operating a vehicle.

All results are reviewed fairly and in accordance with applicable state and federal laws, including the Fair Credit Reporting Act.

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.