eCommerce Data Analyst

WCL Group

Plano (TX)

On-site

USD 80,000 - 113,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

WCL Group is seeking a data analytics professional to build the data foundation and reporting for eCommerce Operations. The role focuses on SQL development in BigQuery, production Tableau dashboards, experimentation, and advanced analysis.

You will collaborate with Operations, Category, Fulfillment, Product, BI, and Data Engineering teams to translate business questions into actionable insights. You will design data models, support data integrity, and move analyses into repeatable pipelines.

Qualifications

  • Bachelor's degree in Engineering, Computer Science, Statistics, Economics, Business or related.
  • 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: partitioning and clustering, cost-aware design.
  • Google Cloud Platform: Cloud Storage, scheduled/orchestrated query workflows, IAM fundamentals.
  • 3+ years designing, running, and measuring A/B and multivariate experiments.

Responsibilities

  • Write, optimize, and maintain SQL in BigQuery on large eCommerce datasets; ensure performance and cost-efficiency.
  • Build and maintain curated BigQuery data models as the trusted reporting layer for eCommerce Operations.
  • Partner with BI and Data Engineering on data integrity, lineage, and consistent definitions across metrics.
  • Move analysis from ad hoc notebooks into repeatable, scheduled pipelines on GCP.
  • Design, build, and own production Tableau dashboards for eCommerce Operations; onboard stakeholders to dashboards.

Skills

SQL
Tableau
Data Modeling

Education

Bachelor's degree in Engineering, Computer Science, Statistics, Economics, Business

Tools

BigQuery
Looker
Looker Studio
dbt / Dataform
Git

Job description

CLIENT HIGHLIGHT

The client you will be working for is a Top 20 Fortune Global 500 Consumer Electronics and Technology Company. This opportunity will give you experience in the technology sector in the United States with a company that is a globally recognized leader in smartphones, televisions, home appliances, and semiconductor innovation — and one of the most well-known brands in the world.

LOCATION

Plano, TX.

COMPENSATION

$70/hour.

SCHEDULE

Fully onsite.

CONTRACT TERM

6-month contract with a very high likelihood of extension/conversion to full-time.

POSITION OVERVIEW

Builds the data foundation and reporting for eCommerce Operations: SQL and data models in BigQuery, production Tableau dashboards, experimentation, and advanced analysis. Partners with Operations, Category, Fulfillment, Product, BI, and Data Engineering teams to turn business questions into analysis leaders can act on.

RESPONSIBILITIES
Analytics & SQL Development
  • Write, optimize, and maintain SQL in BigQuery on large eCommerce datasets; keep queries performant and cost-aware at terabyte scale
  • Build and maintain curated, documented BigQuery data models as the trusted reporting layer for eCommerce Operations
  • Partner with BI and Data Engineering on data integrity, lineage, and consistent definitions across shared metrics
  • Move analysis from ad hoc notebooks into repeatable, scheduled pipelines on GCP
  • Resolve data quality issues across disparate sources by tracing discrepancies to the system of record
Visualization & Business Reporting
  • Design, build, and own production Tableau dashboards for eCommerce Operations: data source and extract strategy, calculated fields, layout, performance tuning, stakeholder onboarding
  • Define KPIs with business owners, set historical benchmarks, and build a measurement plan linking operational metrics to commercial outcomes
  • Prepare and present analytics inputs for Weekly Business Reviews and help stakeholders interpret the results
Experimentation & Advanced Analysis
  • Design, run, and measure A/B and multivariate tests end to end: hypothesis, sample sizing, guardrail metrics, readout
  • Use Python for statistical analysis, cohort and funnel work, and predictive modeling where a forecast or propensity estimate will change a decision
  • Surface and size growth and efficiency opportunities across forward and reverse operations before resources are committed
Stakeholder Partnership
  • Translate business questions into analytical problems and findings into language operational and executive audiences can act on
  • Work with Operations, Category, Fulfillment, and Product partners to shape what gets built, balancing competing 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: partitioning and clustering, cost-aware design, tables of hundreds of millions of rows
  • Google Cloud Platform: Cloud Storage, scheduled/orchestrated query workflows, IAM fundamentals
  • Built and owned production Tableau dashboards: data source design, LOD expressions, parameters, 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
PREFERRED QUALIFICATIONS
  • MBA, or Master's in Analytics, Statistics, Economics, or another quantitative field
  • SQL transformation frameworks such as Dataform or dbt: version-controlled models, layered/medallion warehouse architecture
  • Git workflows and peer code review for analytics code
  • Looker or Looker Studio alongside Tableau
  • Migrating reporting from a legacy warehouse to a cloud-native stack and retiring the old layer cleanly
  • 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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Director of BI & Analytics
Sr. Director of BI & Analytics

Confidential Company • United States

Remote
USD 130,000 - 180,000
Competitive compensation
Health, Dental, and Vision insurance
401(k) Retirement Plan
+1
Digital Experience and Marketing Analyst
Digital Experience and Marketing Analyst

AutoZone, Inc. • Memphis (TN)

On-site
USD 85,000 - 120,000
Senior eCommerce Analytics Lead: SQL, Tableau, BigQuery
Senior eCommerce Analytics Lead: SQL, Tableau, BigQuery

WCL Group • Plano (TX)

On-site
USD 80,000 - 113,000
Data Analyst 3 - Telecom
Data Analyst 3 - Telecom

WCL Group • Plano (TX)

On-site
USD 73,000 - 104,000
Data and BI Lead
Data and BI Lead

Fyul • United States

Hybrid
USD 150,000 - 210,000
Health insurance
Dental & Vision insurance
401(k) with employer match
+1
eCommerce Experience Manager
eCommerce Experience Manager

WCL Group • Plano (TX)

On-site
USD 74,000 - 106,000
Lead Data & Analytics Engineer
Lead Data & Analytics Engineer

Burlebo • Austin (TX)

On-site
USD 150,000 - 210,000
eCommerce Fulfillment Analyst
eCommerce Fulfillment Analyst

WCL Group • Plano (TX)

On-site
USD 46,000 - 66,000
Director of Digital Commerce Strategy
Director of Digital Commerce Strategy

WCL Group • Plano (TX)

On-site
USD 77,000 - 109,000
Tableau Developer & Administrator
Tableau Developer & Administrator

WCL Group • Plano (TX)

On-site
USD 79,000 - 91,000