Bigquery/Dataform Developer For Ecommerce

About Us:

AlexB Solutions is a Data Analytics agency specializing in tailored data engineering and visualisation for e-commerce clients across the US, Canada, and Europe.
We provide e-commerce businesses with bespoke data solutions that drive insights and create impact.
We are looking for a SQL Developer with experience in Shopify & Woocommerce data schema to work on data cleaning and transformations using BigQuery & Dataform.

Key Responsibilities:
Develop and optimize SQL queries in BigQuery.
Develop assertions in Dataform to ensure data quality.
Ingest data into BigQuery using Airbyte and develop custom API data connections.
Clean & transform data for further visualisations.
Ensure data accuracy and consistency.
Merge and blend data from various ecommerce and marketing sources: Shopify, Meta, Google Ads, Klaviyo.

Qualifications:
Strong experience with Shopify's data schema, GitHub, BigQuery.
Strong experience with writing analytical SQL queries to clean and transform data, including window functions, cte's, udf's
Ability to troubleshoot and resolve data issues.
Excellent collaboration and communication skills.
Experience with GA4 raw data schema is a plus.
Experience with Dataform, Airbyte is a plus.

Candidates will be invited to complete a test task to showcase their SQL experience.

To apply, please fill in the contact form: