We deliver the right information, to the right person, at the right moment.

Business Intelligence Analyst

Business Intelligence DeveloperBusiness Intelligence DeveloperFull TimeRemoteTeam 501-1,000Since 2013H1B SponsorCompany Site LinkedIn

Location

United States

Posted

136 days ago

Salary

$75K - $95K / year

Bachelor Degree3 yrs expEnglishBig QueryCloudSQLTableau

Job Description

• Build and maintain performance dashboards • Validate data across Shopify, Amazon, Recharge, GA4, Klaviyo, and marketing platforms • Investigate and reconcile discrepancies across systems • Work directly with the Head of Data to ensure metrics definitions and transformations are consistent • Surface actionable insights and trends for decision-makers quickly • Build clean, self-service dashboards (in Sigma Computing but has similar experience - Tableau, Looker, Power BI) • Oversee weekly and ad-hoc reporting needs for marketing, operations, and finance • Document logic and sources to keep dashboards accurate as data models evolve

Job Requirements

3–4 years hands-on SQL experience building and validating datasets
Comfortable joining large tables, using window functions, CTEs, aggregations, and troubleshooting discrepancies
Familiar with Snowflake, BigQuery or a similar cloud data warehouse (permissions, basic query tuning, lineage awareness)
Capable of validating metrics (e.g., Shopify vs Snowflake vs Amazon totals)
Strong attention to layout, speed, and usability
Prior experience with Shopify and Amazon Seller Central data
Exposure to subscription platforms (Recharge, Loop, etc.)
Familiar with Google Analytics / GA4, Google Ads, Facebook Ads, and Klaviyo metrics
Preferred Skills:
Familiarity with dbt Core (not required to build models; just to read and test).
Basic comfort with GitHub for version control or data documentation.