eCommerce Data Analyst
Job Description
WCL Group is seeking an eCommerce Data Analyst to build the data foundation and reporting that supports eCommerce Operations. The role emphasizes production SQL and BigQuery data modeling, Tableau dashboards, experimentation, and advanced analysis, delivered in close partnership with Operations, Category, Fulfillment, Product, BI, and Data Engineering teams.
Role Overview
The eCommerce Data Analyst will develop trusted reporting capabilities for eCommerce Operations using SQL (BigQuery) and curated BigQuery data models. The role also includes production Tableau dashboards, designing and running A/B and multivariate tests, and performing advanced analysis to translate business questions into actionable insights for operational and executive audiences.
Key Responsibilities
- Write, optimize, and maintain SQL in BigQuery on large eCommerce datasets, ensuring queries remain performant and cost-aware at terabyte scale
- Build and maintain curated, documented BigQuery data models that serve as the trusted reporting layer for eCommerce Operations
- Partner with BI and Data Engineering to support data integrity, lineage, and consistent metric definitions across shared reporting
- Move analysis from ad hoc notebooks into repeatable, scheduled pipelines on GCP
- Investigate and resolve data quality issues across disparate sources by tracing discrepancies to the system of record
- Design, build, and own production Tableau dashboards for eCommerce Operations, including data source and extract strategy, calculated fields, layout, performance tuning, and stakeholder onboarding
- Define KPIs with business owners, establish historical benchmarks, and build a measurement plan linking operational metrics to commercial outcomes
- Prepare and present analytics inputs for Weekly Business Reviews and support stakeholder interpretation
- Design, run, and measure A/B and multivariate tests end to end, including hypothesis development, sample sizing, guardrail metrics, and readout
- Use Python for statistical analysis, cohort and funnel work, and predictive modeling when forecasts or propensity estimates impact decisions
- Identify and size growth and efficiency opportunities across forward and reverse operations before resource commitments
- Translate business questions into analytical problems and communicate findings in language operational and executive audiences can act on
- Collaborate with Operations, Category, Fulfillment, and Product partners to shape what gets built while balancing requests against priority and strategy
- Continually evolve analytics processes, tooling, and data sources to deepen understanding of the client’s digital business
Required Qualifications
- Bachelor’s degree in Engineering, Computer Science, Statistics, Economics, Business, or a related quantitative field
- 5+ years in data analytics, with exposure to operations, fulfillment, or supply chain analytics
- 5+ years writing production SQL, including window functions, CTEs, complex joins, and query optimization
- Google BigQuery at scale, including partitioning and clustering, cost-aware design, and experience with tables containing hundreds of millions of rows
- Google Cloud Platform experience, including Cloud Storage, scheduled or orchestrated query workflows, and IAM fundamentals
- Built and owned production Tableau dashboards, including data source design, LOD expressions, parameters, and performance optimization
- 3+ years designing, running, and measuring A/B and multivariate experiments
- Python for data analysis, including pandas and a statistics or modeling library
- eCommerce or digital commerce experience
- Strong problem solving, written communication, and data presentation skills
Technologies
- SQL
- BigQuery
- Tableau
- Python
- GCP, Google Cloud Platform
- Cloud Storage
- A/B testing
- Multivariate tests
- pandas
Client and Opportunity
The client is a Top 20 Fortune Global 500 Consumer Electronics and Technology Company. This contract offers experience in the technology sector in the United States with a company recognized for smartphones, televisions, home appliances, and semiconductor innovation.
Location and Schedule
Plano, TX (Fully onsite).
Contract Details
This role is a 6-month contract with a very high likelihood of extension or conversion to full-time.
Compensation
$70/hour.
Preferred Qualifications
- MBA, or Master’s in Analytics, Statistics, Economics, or another quantitative field
- SQL transformation frameworks such as Dataform or dbt (including version-controlled models and layered or medallion warehouse architecture)
- Git workflows and peer code review for analytics code
- Experience with Looker or Looker Studio alongside Tableau
- Experience migrating reporting from a legacy warehouse to a cloud-native stack while retiring the old layer
- Experience with clickstream, digital analytics, or customer identity resolution datasets
- Statistical analysis and predictive modeling in R, SAS, or STATA in addition to Python
Top Skills
- SQL
- Tableau
- Data Modeling