Business Analyst- I

Role Expectations

We have access to quality data sources for major e-commerce channels. Imagine the questions you could answer and the impact you could drive if you had access to sales, advertising, promotions and inventory data for many of the top consumer brands selling on Ecommerce platforms like Amazon, Walmart, Instacart, Kroger etc. If this possibility excites you, then keep reading because at CommerceIQ we not only spend our days wading through massive quantities of ecommerce data, our analysts use it to drive millions of dollars of incremental sales for our customers. 

We are looking for a Business Analyst with a highly entrepreneurial mindset that can analyze and identify deeper patterns in data and weave a story from the data at hand. The role is centered around understanding and delivering analytical solutions using CommerceIQ data. 

You will be expected to perform the following role at CommerceIQ,

• Business problem solving:

• You will understand the interplay between various data sources, CommerceIQ platform and customer needs.  You will be expected to build customer context in depth and use it to deliver analytical solutions. You will be expected to put the business lens and present a point of view within a team of engagement managers, analysts and data services team that ensures the final solution fits the business needs and is in a position to generate tangible impact to the customer.
• You will be expected to drive and present insightful approaches to better ecommerce decisions independently. You will be expected to build hypothesis, understand the data needed to conduct the analysis, perform the analysis, synthesize the results and present in an executive friendly format
• You will be expected to partner with Engagement Managers and Clients to align on requirements and develop both recurring and ad hoc reports to meet client needs.
• You will create customer facing solutions in the form of BI dashboards, presentation documents and excel templates.

• Technical expertise:

• You will be expected to be hands-on with Excel, SQL and a programming language like Python / R so that you can process the data and build the analytical solution yourself. 
• You will be expected to develop and deploy complex dashboards in Tableau (or other BI tools) to meet customers customized needs.
• Ability to execute automations through Claude or other AI tools to demonstrate efficiency a bonus

• Ownership:

• You will jointly own the success of CommerceIQ customers with the engagement managers by playing the point person for the quality and timely delivery of the analytical solution. 
• You will need to showcase high ownership and leadership skills to independently work with people from different departments, manage work dependencies from different contributors to successfully deliver the project.
• Own strategic insights engagements with large CPG brand(s) including ownership over strategic reporting, analysis, and data-based recommendations of sales and ecommerce data
• Strategize with CIQ customers to understand their ecommerce priorities and desired outcomes, driving impact-oriented reporting and insights that will help propel their business forward

Skills, Experience & Qualifications Required

1. Extensive experience with data manipulation using Excel and SQL, moderate experience with analytical tools R/ Python, and moderate expertise in data visualization through Tableau
2. Ability to to turn large complex data into compelling actionable insights that drive business strategy and execution
3. Some experience using AI tools like Claude or others to develop code and automations to drive efficiencies preferred
4. 1-3 years of prior experience both performing and structuring advanced analyses independently
5. Successful stint at a prior fast paced work environment (start-ups, consulting etc.)
6. Desire to get into the most granular details of technical/ implementation/ operational issues and being an individual contributor.
7. Bachelor’s degree required.
8. Understanding of hypothesis testing and ability to use data and statistical tests to make an argument. Knowledge of decision trees and ANOVA technique will be an advantage. 
9. Experience in developing and maintaining measurement metrics and standardized outcome metrics based on business requirements

Preferred Qualifications: (in addition to required)

• Master’s degree in Analytics, Data sciences, or any quantitative discipline,
• Experience with ecommerce analytics is a huge plus
• High proficiency in building Tableau dashboards and executive friendly deliverables for business needs and to aid decision making
• Proficient in application of Statistical Methods
• Prior start up experience highly preferred.
• Knowledge of Ecommerce in any of the areas - supply chain advertising, marketing, merchandising, and store operations is preferred
• Prior experience with direct client relationships and liaison to understand client needs and scope actionable insights with business impact desirable