MailerMen logo

Business Intelligence Intern (dbt + Metabase)

MailerMen

Actively hiring🇮🇳 Remote (India)RemoteInternship₹22K – ₹28K /moFreshers onlyData Engineer
Posted 1mo agoBe an early applicant

What this role pays, in context

This listing pays 10% above the median for Data Engineer roles in Remote (India), which sits at ₹22.8K a month.

25th pct ₹19.2K75th pct ₹81.3K

Median of 6 other live Data Engineer listings in Remote (India) on this board that state pay. Roles that do not disclose a salary are excluded rather than counted as zero.

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

Related searches