Apolitical
Analytics Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Overview
Reporting to: Head of Data (incoming)
Location: Hybrid, UK-based due to data handling and contractual constraints. 2 days per week onsite at our London office.
Visa sponsorship: UK national or visa holder preferred, but not a dealbreaker.
Background checks: Due to the non-partisan nature of the work we do with global governments and partners, all employees need to pass background checks, verifying your identity, education (if relevant), work history, sanctions, criminal record, adverse financial history, and right to work. To ensure we maintain high standards of political neutrality, we also perform media and social media checks.
You can expect to hear from us, no matter the outcome, by: 28th August 2026
Salary expectations: We aim for transparency on salary bands. We've set the band to attract experienced mid-level Analytics Engineers or those in a senior IC role. If our range is misaligned with your expectations, we’d welcome an open conversation as early as possible.
Role
Apolitical builds products for public-sector professionals worldwide. Our core product stack runs in a modern TypeScript mono-repo; our analytics stack centres on Google BigQuery, dbt (Core) for transformation, Airflow / Airbyte / GitHub Actions for orchestration and CI, ThoughtSpot for BI, and Colab/Jupyter notebooks for ideation and analysis. You’ll turn warehouse data into trusted, self-serve insights, define core metrics, and ship dashboards that unblock rapid, data-informed decisions across Product, Growth, Partnerships and Ops.
You’ll be the go-to partner for stakeholders, owning the modelling layer, data quality, and the BI experience end-to-end, while contributing to our Airflow-based pipelines and data contracts that keep analytics reliable.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Tasks and remit
- Model the warehouse: Design and maintain dbt models (incremental/snapshot), sources, tests, and documentation; enforce naming and folder conventions for scalable analytics.
- Define metrics & semantics: Establish a governed, reusable layer (semantic definitions / metrics catalog) so the same KPI means the same thing everywhere.
- Build business dashboards: Craft ThoughtSpot answers and dashboards for Exec, Product, Growth and Customer teams; automate refresh and distribution.
- Champion self-serve analytics: Craft intuitive star/galaxy schemas for data marts following best practices so analysts and non-technical team members can get what they need.
- Data quality & contracts: Add and maintain tests (dbt + Great Expectations), SLAs and alerting; evolve data contracts in version control and CI.
- Orchestrate & automate: Contribute Airflow DAGs for scheduled loads, dbt runs and backfills; improve observability, retries and alerts.
- Governance & privacy: Handle PII with care; partner with Eng/Legal on compliant data use and auditability across pipelines and BI.
- Stakeholder enablement: Run office hours, write playbooks, and create training resources that reduce ad-hoc analysis load.
- Incident readiness: Help operate and improve our backup/restore and environment-sync workflows to keep analytics resilient.
Role expectations
Timelines vary by onboarding needs, but most team members achieve the following:
Within one month, you will…
- Ship your first dbt model + tests to production and document it in the catalog.
- Publish a high-value dashboard (e.g., weekly growth or funnel view) consumed by one business team.
- Set up your Airflow/dev environment and complete stack onboarding.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Within three months, you will…
- Establish core metric definitions (e.g., activation, engagement, retention) with stakeholders; codify them in models and BI.
- Add quality alerts (dbt tests / Great Expectations) on critical tables; reduce false positives.
- Improve/author at least one Airflow DAG for dbt jobs or backfills; document runbooks.
Within six months, you will…
- Own a domain (e.g., revenue or content analytics) end-to-end with a trusted, self-serve dashboard suite.
- Cut time-to-insight for a key KPI by >50% via modelling and self-serve improvements.
- Propose and deliver a roadmap to evolve our semantic layer / contracts in CI.
About you
This is a great fit if you…
- Are an Analytics Engineer / BI Engineer with strong SQL and data-modelling fundamentals (star/snowflake, slowly changing dimensions, incremental patterns).
- Have hands-on experience with BigQuery + dbt Core (sources, macros, snapshots, documentation) and are comfortable reviewing SQL/PRs in Git.
- Can design effective dashboards in ThoughtSpot or other BI tools, balancing UX with performance.
- Understand orchestration (Airflow), testing (dbt tests / Great Expectations), and CI for analytics code.
- Communicate clearly with non-technical partners; you enjoy translating ambiguous questions into measurable metrics.
To highlight on your CV…
- Familiarity with Airbyte or other ingestion tools; Python for lightweight transforms; exposure to data contracts in CI.
- Prior work in a modern TypeScript/NodeJS/NestJS environment alongside product squads.
You won’t be…
- A pure data scientist or ML researcher; this role focuses on analytics engineering (modelling, quality, BI, orchestration).
- A people manager; this is an IC role with broad cross-team influence.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location