Business Intelligence Analyst

Business Intelligence Analyst

Company: ABARTA Coca-Cola Beverages

Job Location: 4900 Pitts. Support Center, PA

Other Potential Locations: Altoona, PA; Bellefonte, PA; Bethel Park, PA; Bethlehem, PA; Bloomsburg, PA; Butler, PA; Carlisle, PA; Chester County, PA; Cleveland, OH; Coal Region, PA; Coatesville, PA; Cranberry Township, PA; Danville, PA; Dingmans Ferry, PA; Dover, PA; Downingtown, PA; Dubois, PA (Drop Site); Ebensburg, PA; Elizabethtown, PA; Elverson, PA; Enola, PA; Ephrata, PA; Erie, PA; Exton, PA; Fairmont, WV; Gettysburg, PA; Greensburg, PA; Hamburg, PA; Hanover, PA; Harrisburg, PA; Hazleton, PA; Hermitage, PA; Hershey, PA; Honesdale, PA; Houston, PA; Huntingdon, PA; Indiana, PA; Jamestown, NY; Kennett Square, PA; Lancaster, PA; Lebanon, PA; Lehigh Valley; Lehighton, PA; Lemoyne, PA; Lewisburg, PA; Lionville, PA; Meadville, PA; Mechanicsburg, PA; Middletown, PA; Mifflintown, PA; Milford, PA; Milton, PA; Mount Pocono, PA; Muncy, PA; North Hills, PA; North Versailles, PA; Oxford, PA; Palmyra, PA; Parkesburg, PA; Pittsburgh HQ, PA; Pittsburgh, PA; Pittston, PA; Pottstown, PA; Pottsville, PA; Reading, PA; Schuylkill, PA; Scranton, PA; State College, PA; State College, PA; Stroudsburg, PA; Sunbury, PA; Tamaqua, PA; Titusville, PA; Washington, PA; West Chester, PA; West York, PA; Wheeling, WV; Wilkes-Barre, PA; York, PA

We are actively seeking enthusiastic team players who want to work with the world's most trusted and iconic brands.

About ABARTA

ABARTA Coca-Cola Beverages is a family-owned company committed to being a visible, engaged partner to the customers and communities we serve. We value diversity and individuality and when you thrive, we thrive. ABARTA offers the perks of a large corporation with the personalized touch of a smaller company. We are a workplace that encourages sharing ideas in a supportive environment, growing professionally, maintaining a healthy work/life balance, and interacting with all levels of the organization. We would love for you to become a part of our family to help make our vision of Quenching the Thirst of Our Neighbors a reality!

Summary

The Business Intelligence Analyst will couple creative analytical thinking and resourcefulness to design, build and steward insightful business analysis and scalable reporting products. The Analyst II will operate with autonomy, pursue creative ideas, and leverage knowledge of Coca-Cola data to deliver strategic, consultative expertise as well as tactical support to stakeholders.

Responsibilities

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

• Interpret and refine reporting requirements, providing requestors with thoughtful recommendations and explanations based on knowledge of Coca-Cola data and existing suite of reporting products.
• Apply analytical and mathematical concepts to provide customers with meaningful, visually robust 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. Champion change and best practices among peers to continuously elevate the quality of the team's services.
• 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.)

(30% of Time)

• Deepen subject matter expertise in Coca-Cola data, including data lineage and a thorough understanding of the business activities and concepts represented by the data.
• Pursue new ideas for simplifying and automating the execution of reporting services. Drive toward a goal of limited repetition and dynamic automation.
• 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

(30% of Time)

• Steward reporting solutions 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
• Anticipate stakeholder needs and proactively offer data-driven ways to add value and improve the quality of their business routines.

Qualifications

• Advanced SQL & PowerBI
• Python programming

• Mastery of concepts of relational data, reporting, and data manipulation

• Ability to quickly learn new technologies, tools, and syntax

• Articulate, precise communication of complex, technical, or data-oriented content

• Experience in ADF, Power Platform and/or DAX preferred.

Education:

Minimum: High School or GEDWith minimum required experience

Preferred:4 Year / Bachelors Degree

Years of experience: 3-8years of experience in data analysis and reporting

Additional Information

ABARTA Coca-Cola Beverages, LLC applicants must submit to a background verification process prior to commencing employment with the company. Employment with ABARTA Coca-Cola Beverages, LLC is contingent on a pre-employment background check which may include drug screening, driving records (including minor moving violations) and will be evaluated according to ABARTA Coca-Cola Beverages, LLC guidelines to determine eligibility for this position. ABARTA Coca-Cola Beverages, LLC is an Equal Opportunity Employer Minorites/Women/Veterans/Disable/Sexual Orientation/Gender Identity.

For more job postings and additional information about our company and culture, please visit our careers site at

Nearest Major Market: Pittsburgh