Posted 1h ago
Loading this job…
Business Intelligence Intern (dbt + Metabase)
Posted 2h ago0 views
Why this role exists
Our reporting grew organically and it shows. Twelve people write their own SQL, four of them define a signup differently, and the numbers in the Monday email rarely match the numbers in the board deck. You are joining to help fix that.
What you will do
This six month internship places you inside our small BI group, where you will move ad hoc queries into dbt models with tests and documentation attached. You will start with the jobs mart: one clean model for postings, one for applications, one for employer accounts, each with a freshness check and a schema test so a silent upstream change is caught before a recruiter notices. From there you rebuild the executive dashboard in Metabase on top of those models.
Working style
You will be fully remote and expected to write things down. Every model needs a description a non technical account manager can read. We run a weekly video review of open pull requests where you defend your naming choices, and yes, naming is a real conversation here.
You do not need to have used dbt before. You do need to be comfortable in SQL and curious about why data teams bother with version control at all.
Responsibilities
- Convert ad hoc analyst SQL into tested, documented dbt models
- Build staging and mart layers for job postings, applications and employer accounts
- Add schema and freshness tests so upstream changes surface before stakeholders notice
- Rebuild the executive Metabase dashboard on top of the newly modelled tables
- Write model descriptions that a non technical colleague can read and trust
- Take part in weekly pull request reviews and defend your structure and naming
- Keep a changelog of metric definition changes for the wider company
Requirements
- Recent graduate or final year student with solid SQL fundamentals
- Basic command line and Git comfort, or the willingness to get there in your first fortnight
- Clear written English, since this team runs mostly in writing
- Available for the full six months with a reliable remote setup
Skills
Benefits
- Fully remote across India with flexible working hours
- Weekly code review from the analytics engineering lead
- Certificate of completion plus a public dbt project you can point to
- Company funded seat on a paid analytics engineering course
- Priority consideration for openings on the data team