Data Analyst

Who Are We Looking For?

Citylitics is looking for a Data Analyst to own our Custom Solutions practice. You’ll scope and deliver client-specific data requests that don’t fit our standard product.

You will partner directly with Sales, Customer Success, Product and leadership to triage incoming requests, assess feasibility before anything is promised to a client, query and validate data in BigQuery, and build the one-off dashboards or reports that answer a client’s actual question.

This role fits someone analytical, comfortable with ambiguity, and disciplined about scope. You size up a vague ask fast, align stakeholders when it’s over-committed, and educate clients on data availability and nuances while developing solution options to discuss with them. Once you’ve validated an approach with the customer, you hand the engineering work to the team. You don’t need to be an engineer, but you need enough confidence in SQL and data structures to know what’s realistic. You’re also comfortable presenting data findings and methodology directly to clients and helping them interpret what the results mean. You move quickly and decisively, without overanalyzing.

This role is based in our downtown Toronto office and requires 3+ days in-office per week.

Vacancy Status: This position is for an existing and active vacancy that Citylitics is currently seeking to fill.

What Will You Accomplish?

Triage and Scope Custom Solution Requests

You will own the front door for custom solutions requests, deciding what’s worth committing to before it reaches a client.

Responsibilities include:

Field new custom-solution requests from Sales and Customer Success as they come in (Slack, demo follow-ups, live calls)
Assess feasibility and turnaround before anything is committed to a client
Align stakeholders when a request is over-scoped or under-priced
Educate clients on data availability and nuances
Develop solution options to discuss with the client before committing to delivery
Query, Validate, and Build One-Off Deliverables

You will do the actual data work behind each request, once it’s been scoped.

Responsibilities include:

Query BigQuery to test and validate client-specific hypotheses
Build or update lightweight dashboards (Looker, etc) for one-off client deliverables
Disambiguate against existing coverage to avoid duplicating work

Hand Off to Engineering Once Customer Validation Is Achieved

You validate the approach with the customer before engineering builds it.
Responsibilities include:

Write up findings and requirements clients or account teams can act on directly
Hand off anything requiring pipeline or scraper-level work to engineering, with a clear spec
Surface it immediately when a client’s own criteria don’t hold up
Other duties as assigned

Requirements
Must-Have Experience

2+ years of experience in data analysis, solutions consulting, business analysis, or a similar role
Strong SQL fluency (BigQuery a plus), comfortable self-serve querying
Scopes an ambiguous request before diving in and defines what “done” looks like from the start
Strong written and verbal communication for client-facing summaries
Comfortable working directly with clients or internal commercial teams under a fast turnaround pace
Comfortable presenting data findings and methodology directly to clients and helping them interpret results, not just retrieving data
Moves quickly and decisively, without overanalyzing

Nice-to-Have Experience

Enough SQL/notebook fluency to spec engineering work credibly (not to build it)
Prior consulting or client-facing analyst background
Familiarity with a BI/dashboarding tool (Looker, Tableau, etc.)