Skip to main content

We are going BIG on DATA

Mark Rochefort29 June 20202 min read
We are going BIG on DATA

See what we did there? Okay, so maybe a tad too much on the title. It is catchy, so hey.

Firstly - we are pretty chuffed to welcome Lace to our team. She joins us to spearhead our offering in all things DATA science and data engineering, which (to be completely frank) is where all roads point in this analytics game. With the advent of App plus Web (from Google Analytics), and particularly the opportunity to access raw data through BigQuery, this is an exciting place to be right now.

Secondly - we are growing the team and going BIG. It has been a crazy few months. The pandemic still prevails. People are uncertain of what the future looks like. And so this is precisely the time to grasp that nettle and carve out a path for our future. We are fortunate to already be working in a field that has become even more relevant; it is a fairly good bet right now. What all this has changed though are the parameters within which we can play. Suddenly we are all working from home - and that changes how we all look at stuff. It also means we can look to revisit the status quo for the better - forever - to create a more sustainable and scalable way of doing all this. Again - quite an exciting place to be!

So that's all... If you think any of these roles could be you then get in touch (by emailing jobs@measurelab.co.uk). In fact - get in touch if you think that Measurelab might be the right sort of place for you. We are more about finding the right people than finding people who fit a job description.

Need help with your data platform?

We build intelligence platforms on BigQuery, Dataform and Google Cloud - from setup to ongoing optimisation.

How ready is your data?

Take our short assessment to find out where your data stack stands and what to prioritise next.


Suggested content

BigQuery Tips: When your query is technically correct but BigQuery won't run it

There is a particular kind of frustration that comes from staring at a query you know is correct and watching it fail. No syntax error. No logic problem. Just a wall. We hit two of them on the same project. What we were building The job was to migrate ga4_daily_snapshot for a large enterprise client from a BigQuery scheduled query into a proper Dataform pipeline. The scheduled query had been added to over time until it was too large to maintain with any confidence. Moving it to Dataform w

Katie Kaczmarek17 Aug 2026

BigQuery Tips: The subquery in your WHERE clause that's scanning your entire table

There is a pattern that appears in a lot of BigQuery pipelines and looks completely reasonable. You have a control table that stores the latest processed date. Rather than hardcoding a date into your query, you pull it dynamically: SELECT * FROM `project.dataset.events` WHERE event_date = ( SELECT latest FROM `project.dataset.control_table` ); The query returns the right results. The logic is clean. And if your events table is large and date-partitioned, you might be scanning the entire

Katie Kaczmarek13 Aug 2026

BigQuery Tips: Arrays in BigQuery - what they are and how to get data out of them

If you have ever opened a GA4 export in BigQuery for the first time and found yourself looking at a column called event_params that seemed to contain an entire table inside each row, this post is for you. Arrays are not trying to make your life harder. Once you understand why they exist and what to do with them, they stop being intimidating. Why BigQuery uses arrays GA4 tracks events. Each event can have many parameters. A purchase event might have a transaction ID, a value, a currency an

Katie Kaczmarek10 Aug 2026