Senior Business Insights Analyst

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.

Why you’ll love working at Swire Coca-Cola

• Health coverage (3 medical options, dental and vision)
• 401(k) Retirement Plan with company match
• Health Savings Accounts with company match
• FREE virtual primary care, acute care, and physical therapy
• FREE Employee Assistance Program
• Company-paid time off (vacation, holidays, sick time, bereavement, jury duty, maternity/parental leave, disability leave, and volunteer time)
• Discounted & free product
• Tuition reimbursement
• Opportunities for career advancement
• Opportunities to give back directly to the communities and causes you care about

Note: Enrollment in a Swire Medical Plan is required for some benefits.

Responsibilities

• Lead end-to-end research and analysis of business opportunities, build financial models, and 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, with authority to delegate tasks
• Make operational decisions regarding project timelines, requirements, and BI product development
• Performs other duties as assigned

Requirements

• Bachelor's Degree (STEM-related field preferred)
• Master's Degree (MBA or related field preferred)
• 4+ years experience using large and complex data sets to produce reporting and insights
• 4+ years experience with Microsoft Power BI, Tableau, or similar reporting tools
• 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
• 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.)
• Strong organizational, problem-solving, interpersonal, and influence skills
• Ability to work under pressure, meet deadlines, and work independently
• Demonstrated ability to manage ambiguity and lead development of solutions to unsolved problems
• Proficiency in developing Business Intelligence processes and workflows
• Demonstrated proficiency in SQL

Due to the nature of our work, pre-employment screening—including a criminal background check, drug screening, and for certain roles, a motor vehicle record review—is required after a conditional offer of employment.