Skip to content
Square1 Ai
Live bootcampTaught live on Zoom, one instructor

Analytics Engineer Bootcamp

SQL, modelling and AI-assisted analysis that a finance team trusts.

Analytics Engineer Bootcamp is a 12-week live online bootcamp, taught on Zoom by one instructor at about 15 hours a week, with 6 deployed projects and a one-to-one every week. The founding price is A$200, down from A$400. Live sessions run on weekday evenings from 5:30 PM Sri Lanka and India time, with full-day sessions at weekends.

Taught with
PostgreSQLPythonpandasJupyterChatGPT
Not sure it is for you?Take the free Data Science skill check
By week 12, you will have shipped
  1. Week 1Query LibraryA library of ten SQL queries over a real schema, each with a documented purpose
  2. Weeks 1–2SQL masteryA reporting layer over a real schema, deployed
  3. Week 3Staging ModelsA set of staging models that rename, cast and test raw tables
  4. Weeks 3–4ModellingA tested, documented model layer, deployed
  5. Weeks 5–6MetricsA metrics layer reconciled to the books, deployed
  6. Week 7Metric GlossaryA glossary of core metrics with definitions, owners and the SQL behind each one
  7. Weeks 7–8Self-serveAn AI assistant that answers questions over the metrics layer, deployed
  8. Week 9Freshness CheckA scheduled check that flags any model whose data is older than its agreed window
  9. Weeks 9–10Operating itThe capstone: the analytics platform with monitoring and a change process
  10. Weeks 11–12Employer brief and hiring sprintThe employer brief shipped, and demo day
weeks, live on Zoom
12
hours a week
15
projects to build
10
minutes 1-1, every week
30

Who it is for, and what you receive.

Analysts with some SQL and spreadsheet fluency who want to own the metrics layer a finance team trusts, with AI on top of it.

Before you start

Some SQL; spreadsheets fluency.

Skills
SQLdbtmetrics layersdashboardsLLMs over datagovernance
A week, about 15 hours
Live on Zoom
4h
Set reading and exercises
6h
The project
5h
  1. 1

    Six deployed projects

    Each graded by Nova against a published rubric and signed off by the instructor at the gate.

  2. 2

    The twelve-week plan

    Every week has its theme, its topics and what you build, published before you apply and taught live by your instructor.

  3. 3

    Live on Zoom every week

    A 90-minute live code review, a 60-minute squad lab, 60 minutes of office hours, and a 30-minute 1-1 with your instructor.

  4. 4

    Your hiring plan

    Opened in week 1 and reviewed in every 1-1: target roles, the gap map, the proof list, weekly actions, an interview log, the outcome.

  5. 5

    The record

    Every grade and every project with its repository at square1ai.com/u/{handle}, and the recording of your viva, verifiable by any employer.

  6. 6

    The certificate

    A credential ID that resolves at square1ai.com/verify to the real completion.

  7. 7

    The hiring sprint

    Weeks 11 and 12: CV and portfolio from graded work, applications, mock interviews scored against the role, demo day.

  8. 8

    Nova for twelve weeks

    A tutor with every submission of yours in its memory, at 2am as well as in class.

Twelve weeks in six parts.

Each part teaches for a week, then you build and deploy a project, then a gate checks it before the next part opens. The project and its gate are the part's entry on your record.

Live time each week on Zoom: a 90-minute class where the instructor reviews real submissions, a 60-minute squad lab, 60 minutes of office hours, and your own 30-minute 1-1. Nothing is lectured live; the recorded lessons do that.

  1. Key skillsAdvanced SQLWindow functions and performanceReading a query plan
    Week 1

    SQL mastery

    • Advanced SQL
    • Window functions and performance
    • Reading a query plan

    You build: A reporting layer

    Week 2

    Project 1: reporting

    • Correctness
    • Time budgets

    You build: A reporting layer over a real schema, deployed

    Project 1 · the gate at week 2

    Reporting

    A reporting layer over a real schema, deployed

    You hand in
    • Queries
    • Query plans
    • Timing report
    The gate

    Queries are correct and within a time budget.

What you can do by week 12.

Six deployed analytics systems ending in a metrics layer finance trusts and an AI assistant that cites its definitions, which is the analytics job as it now exists.

  1. 1

    Write advanced SQL, read a query plan and hit a time budget.

  2. 2

    Build dimensional models with tested, documented layers.

  3. 3

    Build a metrics layer with definitions people agree on and reconcile it to the books.

  4. 4

    Put dashboards, a semantic layer and an AI assistant over the metrics with governance.

  5. 5

    Run the analytics platform: freshness, incidents, cost, change management.

  6. 6

    Defend a number all the way to its source.

Roles this prepares you for
Analytics engineerBI engineerData analyst (senior)Metrics or semantic-layer engineer

No placement rate is shown, because there are no graduates to count yet. The roles above are what the projects are built for.

Your record at week 12.

Every exercise and project is graded by Nova against a rubric you can read, and every grade is kept on one page an employer can open and run. This is what the programme writes to it.

Graded, line by line
Nova reads every submission against the brief and the rubric and returns a score, what you did well and what to fix.
Six gates
A block does not open until the previous project passes its gate. You always know where you are and what is next.
A weekly 1-1
Thirty minutes with your instructor, who has already read your code before the call.
One page an employer can run
Every grade, project and the viva recording at /verify. An employer opens it, runs the code and watches you defend it.
Record, Analytics Engineer BootcampExample
  1. Week 2

    Reporting

    Queries are correct and within a time budget

    Graded, gate signed
  2. Week 4

    The model layer

    Every model has tests and a description

    Graded, gate signed
  3. Week 6

    Reconciled

    Revenue reconciles to the cent

    Graded, gate signed
  4. Week 8

    The assistant

    Answers cite the metric definition they used

    Graded, gate signed

The entries, not the grades: those are yours to earn. The page lives at /verify and an employer needs no account to open it.

8 entries, twelve weeks. Reserving a spot holds the founding price.

Reserve a seat

How we help you find a job.

The last block is not curriculum. It is the hiring sprint, and the proof you built in the ten weeks before it.

The course booklet

The whole plan on a few pages: the parts, the projects, the gates and the price. We email it to you.

Get the booklet
  1. 1

    Your hiring plan, from week 1

    Six parts you and your instructor keep: target roles, the gap map from real postings, the proof to send, weekly actions, an interview log, the outcome. Read before every 1-1.

  2. 2

    The hiring sprint

    Weeks 11 and 12: CV, portfolio, applications, mock interviews, and demo day in front of hiring partners.

  3. 3

    A record an employer can run

    Your deployed projects and the recorded viva on /verify. An employer opens it, runs the code and watches you defend it.

  4. 4

    The career agent

    Paste a real job posting at /career and it maps the role to your graded work and what to do next.

  5. 5

    The roles directory

    Every role we prepare people for, what it pays and what it asks, at /roles.

Questions people ask.

About Analytics Engineer Bootcamp, answered from the plan on this page.

Further reading
Related programmes

One cohort, one instructor. Hold your spot.

A cohort of 25, one instructor, 12 weeks, six things you ship. Spot holders hear the start date first, and nothing is charged before you confirm.

  • Six deployed analytics systems
  • A recorded viva
  • Your record on /verify
A$200A$400
Reserve a seat

About a minute. No account, no card, and nothing is charged until you confirm.

Reserve a seat · A$200Skill check