Business Intelligence Analyst I

Job Summary

The CCBSS Data Strategy & BI organization is responsible for collecting, managing, and stewarding a complex suite of business data to a broad array of stakeholders across the Coca-Cola system. Business Intelligence Analyst I will employ insatiable curiosity, fastidious attention to detail, and strong aptitude for data analysis and data concepts to deliver reporting products and services with excellent customer service. The objective of this role is to serve as a conduit between Coca-Cola’s dense and highly nuanced data and reporting assets and the business teams that rely on them. The CCBSS Data Strategy & BI organization is responsible for collecting, managing, and stewarding a complex suite of business data to a broad array of stakeholders across the Coca-Cola system. Business Intelligence Analyst I will employ insatiable curiosity, fastidious attention to detail, and strong aptitude for data analysis and data concepts to deliver reporting products and services with excellent customer service. The objective of this role is to serve as a conduit between Coca-Cola’s dense and highly nuanced data and reporting assets and the business teams that rely on them.

Duties and Responsibilities

BI & Reporting Projects (e.g. Power BI dashboards, custom data sets/feeds, etc.) ( 40% of Time )

• Interpret and deliver reporting requirements, ensuring results are accurate, logical, and performant.
• Apply analytical and mathematical concepts to provide customers with meaningful, accurate business metrics (trend, impact analysis, segmentation, change contribution, penetration, churn, etc.)
• Ensure deliverables are successfully adopted. Publish internal and external facing documentation for your reporting solutions.
• Deepen technical skills in a variety of technologies and applications by leveraging peer knowledge, online resources, and informal training materials
• Work with manager and peers to rationalize disparate reporting methodologies, standardize approach where it makes sense, and promote transparency, consistency, and accessibility of Coca-Cola system data
  
  

Reporting Services (e.g. data analysis and research, consultative support, etc.) ( 40% of Time )

• Develop subject matter expertise in Coca-Cola data, including data lineage and a thorough understanding of the business activities and concepts represented by the data.
• Leverage subject matter expertise and efficient data querying and manipulation skills to perform research and analysis on data anomalies, data quality gaps, and business insights.
  
  

Stakeholder Engagement (20% of Time)

• Steward reporting projects and services through a variety of customer facing avenues including formal and informal presentations, training, and documentation.
• Work closely with internal and external customers to understand their business routines, performance metrics, audience, and overall role in the Coca-Cola system
• Act as an extension of customers’ teams, anticipating needs and providing excellent service in analysis and reporting
  
  

Disclaimer: This job description is not intended to be a comprehensive list of the duties and responsibilities of the position and that the duties and responsibilities may change with or without notice.

Key Skills And Abilities

• Proficient in SQL including joins and aggregations
• Proficient with concepts of relational data, reporting, and data manipulation
• Expert Excel skills
• Ability to quickly learn new technologies, tools, and syntax
• Articulate, precise communication of complex, technical, or data-oriented content
• Proficient in PowerBI
  
  

Education Requirements

Min/Preferred

Education Level

Preferred

4 Year / Bachelors Degree

Minimum

High School or GED

With Minimum Required Experience

Years of Experience

Years Of Experience

Minimum Years of Experience

Maximum Years Of Experience

Comments

1

4

Of experience in data analysis and reporting

Required Travel

Willingness and ability to travel as needed

Hybrid Work Environment

CCBSS operates a hybrid working environment. This is a teleworking role that requires working at a CCBSS office location on a regular basis (or a minimum number of days per month or week) at the manager’s discretion. The number of days required at a CCBSS office location is at the manager’s discretion and is subject to change depending on business needs.

Total Rewards, Totally Rewarding

We are one family supporting the Coca-Cola bottling system in North America. Our work is indispensable to our partners and makes an impact in the communities where we operate. We are committed to workplace diversity and to rewarding exceptional performance. We expect a lot from our team — after all, it’s their exceptional work that helps CCBSS support the Coca-Cola bottling system in North America. To keep everyone motivated and energized, we offer a comprehensive benefit and rewards package.

• Work-Life Integration- Vacation, floating holidays, parental leave, flexible work environment
• Competitive Base Salary- A base salary or hourly wage rate in line with market rates for the job duties and skills required
• Rewards & Recognition- Acknowledging our employee’s contributions
• Retirement Plans & Guidance- Programs to assist associates in saving for retirement
• Health & Welfare Plans- Medical, life, and disability insurance plans
  
  

Company Message

Coca-Cola Bottlers’ Sales and Services, LLC is an Equal Opportunity Employer and does 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.