Business Intelligence Analyst

Position Summary: Support the Ecommerce Fulfillment Strategy and Services across each Brand Team along with Operational, Transportation and Customer Care Insights in their mission to deliver a superior understanding (competitive advantage) of our customers, operational performance and quality, plus any other insights that support informed decision making and fact-based analysis. These positions conduct in-depth analytics, ad hoc and advanced analytic analyses often synthesizing multiple data sources and provide objective interpretation of this information considering their overall knowledge of the business and consumers. These positions mine, merge, and manipulate multiple data sources including the Peapod Digital Labs data warehouse, AUSA CDW/IDW/EDW, Power Bi, Data Lake, Third Party Data Sources (e.g., Instacart, Shipt) and customer insights survey data. These positions are responsible for preparing, summarizing, and interpreting data assuring the quality and integrity of their work.

Principle Duties and Responsibilities:

• Conduct both routine and complex analyses using all available data sources to answer specific business questions.

• Measure the impact of major programs/initiatives on consumer behavior and perceptions, the response to varieties of digital experience testing, updating, and explaining business results, uncovering cause/effect relationships, and understanding relative returns on investments.

• Development of goal setting model to assist brands to set goals across multiple operational KPI’s

• Determine of relevant data sources applicable to the business question and diligently verify the data quality and accuracy of the results.

• Design and develop reporting tools that monitor key performance indicators and trigger actions to reinforce or redirect the measures of success.

• Partner with PDL/Brand/RBS/ADUSA Supply Chain teams to determine business objectives, key drivers of the success measures and identify KPIs to collect and measure.

• Continually assess the utility of ongoing reporting to optimize the set of reports used for business measurement.

• Represent Consumer and Market Insights across the organization through presentations, consultation, and participation in cross-functional teams.

• Develop strong PDL/Brand/RBS/ADUSA Supply Chain relationships that enable learning about the business and how their work directly impacts decisions. For specific projects, draw out critical information that impacts the learning objectives and incorporate into all work.

• Stay current on new analytical approaches, new technologies and new tools.

• Structure, build and maintain consumer and business intelligence databases.

• Assist in building and maintaining databases enabling more efficient and effective analyses for many other Analysts and Insights Leads and assure consistency of information used across functions (e.g., Power BI).

• Identification of additional data requirements and partner with the database administrators to collect and organize new data elements.

• Maintain proficiency with major business systems and the data on which it relies, including (but not limited to): Data Warehouse, Manhattan’s SCI, Weblogs (User, Client and API logs), Google Analytics, AUSA CDW/IDW, and FiONA Data Lake.

Knowledge:

• The person in this position should have exposure to and some experience in a variety of Advanced Analytical tools/methods/knowledge (Inc. Tools such as very advanced Excel, SQL, OLAP functions, statistical packages, etc.); Methods/Knowledge such as test-control/experimental design, regression (Inc. multivariate), data modeling techniques, cluster and factor analysis, etc.).

• Construct algorithms and measure performance of models in applications such as search optimization, product recommendations, and marketing offer optimization.

• Manipulate and prepare data for optimal use for various programs, projects & pilots

• Experience with Advanced Analytics or Primary Research methods and tools. Can work with considerable independence.

• Advanced knowledge and experience with various methodologies and data sources used in a consumer insights environment. Ability to analyze data, employing statistical concepts, and present recommendations based on that data.

• SQL Proficiency, Database Structure knowledge (Relational, Columnar, Hadoop

Skills:

• Oral/written communication, initiative, negotiation, attention to detail, customer focus

• Expert writing and presentation skills

• Intermediate to Expert SQL

• Power Bi, Power Point

Education:

• Bachelor’s Degree

Experience:

• 4 – 6 years

Job Type: Full-time

Pay: $70,000.00 - $85,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift

Supplemental Pay:

• Bonus pay

Experience:

• SQL: 1 year (Preferred)

Work Location: Multiple Locations