Entry-Level Product & E-commerce Analytics Analyst

christian caine design • United State
Remote
Apply
AI Summary

We're seeking an entry-level analyst to join our design-focused team, supporting product, marketing, and customer experience decisions. The role involves extracting, transforming, and analyzing data for insights and actionable recommendations. Must-have skills include experience in SQL, Python, Excel, and data visualization tools like Tableau or Power BI.

Key Highlights
Support product, marketing, and customer experience decisions
Analyze and extract insights from data for actionable recommendations
Entry-level position with opportunities for growth and skill development
Key Responsibilities
Collect, clean, and validate structured and unstructured data
Build and maintain interactive dashboards and visual reports
Perform quantitative and statistical analysis
Automate routine reporting processes and create reproducible workflows
Collaborate with cross-functional teams
Technical Skills Required
SQL Python Excel Tableau Power BI Data visualization Data cleaning and transformation ETL concepts Cloud data warehouses Analytics platforms Web analytics tools Google Analytics Adobe Analytics
Benefits & Perks
100% remote role with flexible hours
Hands-on exposure to product and marketing analytics
Opportunities for upskilling and mentorship
Nice to Have
Power BI or Looker experience
Cloud data warehouses and analytics platforms
Web analytics tools
Visualization libraries and reporting automation
Product analytics concepts, event tracking, and instrumentation

Job Description


A role in the Creative Design & Services sector supporting digital product and e-commerce analytics. This is a fully remote, United States-based opportunity for an entry-level analyst to join a design-focused team that leverages data to inform product, marketing, and customer experience decisions.

Role & Responsibilities

  • Collect, clean, and validate structured and unstructured data from multiple sources to ensure high-quality datasets for analysis (ETL best practices, data validation).
  • Build and maintain interactive dashboards and visual reports that track key metrics for product and marketing performance using Tableau, Power BI, and visualization libraries (matplotlib, seaborn).
  • Write SQL queries (e.g., PostgreSQL, MySQL, BigQuery) and Python scripts (pandas, NumPy) to extract, transform, and prepare data for ad-hoc analyses and recurring reports; optimize queries and document data models.
  • Perform quantitative and statistical analysis (hypothesis testing, regression analysis, A/B testing) to identify trends, user behaviour patterns, and opportunities for optimization.
  • Automate routine reporting processes and create reproducible workflows using Python, Jupyter notebooks, and version control (Git) to increase team efficiency.
  • Leverage Excel for quick analysis and stakeholder-ready summaries (pivot tables, VLOOKUP/XLOOKUP, advanced formulas) when appropriate.
  • Collaborate with cross-functional teams (design, product, marketing) to translate business questions into measurable analytics tasks and present insights through clear data visualizations and storytelling.

Skills & Qualifications Must-Have

  • Microsoft Excel (advanced: pivot tables, complex formulas, XLOOKUP/VLOOKUP).
  • SQL (proficient in writing joins, aggregations, window functions; familiarity with databases such as PostgreSQL, MySQL, or BigQuery).
  • Python (experience with pandas, NumPy; comfortable building reproducible scripts and working in Jupyter notebooks).
  • Tableau (dashboard building, calculated fields, and visual best practices) or equivalent data visualization tools.
  • Foundational statistics and experimentation knowledge (hypothesis testing, confidence intervals, A/B testing principles).
  • Data cleaning and transformation experience (ETL concepts, handling structured and unstructured data).

Preferred

  • Power BI or Looker experience.
  • Experience with cloud data warehouses and analytics platforms (BigQuery, Snowflake).
  • Familiarity with web analytics tools (Google Analytics / GA4, Adobe Analytics).
  • Experience with visualization libraries (matplotlib, seaborn) and reporting automation.
  • Knowledge of product analytics concepts, event tracking, and instrumentation.

Keywords: SQL, Python, Excel, data visualization, Tableau, Power BI, pandas, NumPy, Jupyter, statistics, A/B testing, ETL, BigQuery, Snowflake, Google Analytics, matplotlib, seaborn

Benefits & Culture Highlights

  • 100% remote role with flexible hours to support work-life balance across U.S. time zones.
  • Hands-on exposure to product and marketing analytics within a creative, design-led environment.
  • Opportunities for upskilling and mentorship to accelerate growth from entry level to mid-level analytics roles.

Skills: design,data visualization,commerce,analytics,tableau,microsoft excel,customer,power bi,data,sql,balance,creative design,ad-hoc,python

Similar Jobs

Explore other opportunities that match your interests

Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

Stott and May

United State

Senior Data Engineer

Data Science
•
2h ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

Accelerant

United State

Regional Staffing Manager

Data Science
•
1d ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

US Foods

United State

Subscribe our newsletter

New Things Will Always Update Regularly