E-Commerce BI Analyst (ZR 20977 JOB)

This is a remote position.

Job Highlights:

• Contract type: Independent Contractor
• Scheduled: Monday to Friday, 8:00 AM to 5:00 PM Pacific Time with 1-hour unpaid break

About Us

We are looking for a
 
BI Analyst 
to help maintain and improve our data pipelines, ensuring seamless data integration and high-quality reporting, which is an integral part of the business decisions made by our internal teams and clients.

About the Role

As a BI Analyst, you will be responsible for maintaining and optimizing our
 
medallion data architecture
 
(bronze, silver, gold) leveraging BigQuery SQL and Terraform. You will work closely with the internal data analytics team to ensure that datasets are structured, clean, and efficient for use in
 
Tableau, Looker Studio, and/or Google Sheets
.

You will also contribute to
 
enhancing data infrastructure
 
by automating exception reporting, optimizing data transformations for advanced analytics models, and advising on schema requirements for new reports. Additionally, you will support
 
code versioning, data flow documentation, and change management
. We are looking for you to bring a strong perspective on scalable, reusable transformations that we can deploy across the numerous brands we support.

Responsibilities:

• Maintain ETL/ELT processes which transform raw JSON data into structured, analytics-ready tables in BigQuery.
• Develop and maintain automated exception reporting using Great Expectations to proactively identify and surface data anomalies; ensure data accuracy and integrity by performing QA and reconciliation against platform data sources when updates or changes occur.
• Automate and scale onboarding of new brands into the data pipeline, ensuring seamless integration into existing reporting structures.
• Standardize and scale transformations, such as using CTE’s and dynamic queries to apply reusable logic across multiple brands.
• Develop new tables, views, attributes, and metrics as needed, collaborating with the Analytics Team to validate and deploy updates to production.
• Productionalize advanced analytics models developed by the data team, ensuring they are efficiently integrated into the BI platform.
• Manage code versioning to track, review, and maintain SQL and ETL pipeline updates.
• Optimize data flows, ensuring clear documentation of dependencies, transformations, and change management processes; continuously improve data organization as-needed by optimizing queries, metadata management, and overall data structure for scalability.
• On occasion, you may need to set up, configure, and troubleshoot API data feeds including integrating new data sources or in the event of schema changes.

Why Join Us?

• Gain hands-on experience in a scalable cloud analytics environment.
• Work with modern data tools and real-world datasets from top digital platforms.
• Opportunity to grow skills in advanced SQL solutions, API’s, and AI.
• This role is ideal for recent graduates or students looking for full-time work.

If you are passionate about data, eager to solve problems, and looking to support a best-in-class data environment, we’d love to hear from you!

Requirements

• Strong SQL expertise (must-have); Python knowledge.
• Familiarity with BigQuery and cloud-based data environments.
• Understanding of ETL/ELT processes and data pipeline management.
• Experience with Terraform (or similar Infrastructure as Code (IaC) tools).
• Experience with Great Expectations (or other data quality frameworks).
• JSON and API data handling knowledge is a plus
• Interest in BI tools like Tableau or Looker Studio (bonus if you have hands-on experience).
• Ability to work independently, troubleshoot data issues, and collaborate with analytics teams.

Benefits

Independent Contractor Perks

• HMO Coverage for eligible locations
• Permanent work from home
• Immediate hiring
• Steady freelance job

Please note that since this is a permanent work-from-home position and an “Independent Contractor” arrangement, the candidates must have their own computer and internet connection. They will handle their own benefits and taxes. The professional fees are on hourly rates and the rate depends on your performance in the application process.

ZR_20977_JOB