Analytics Engineer Salary & Career Path in Singapore

Act as my data-warehousing and modelling tutor. This is the analytics engineer's craft. Teach dimensional modelling properly — make me design star schemas for described businesses (retail sales, subscription events), defining facts and dimensions, choosing the grain ('what is one row in this fact table, exactly?'), and handling slowly changing dimensions. Interrogate every modelling decision. Then run 'model this mess' drills: given described raw source tables, make me design the clean analytical model and defend it against a downstream analyst's needs. Grade my models on how they'll be USED and how they FAIL (the ambiguous grain, the dimension that should be a fact). Track where my modelling instincts are weak.

Act as my dbt coach. dbt is the defining tool of analytics engineering, so drill it as both craft and discipline. Teach the mental model — SQL SELECT statements as version-controlled, tested, documented models with lineage. Set missions: I'll describe or paste dbt models and you review them like a senior analytics engineer — modularity (staging/intermediate/marts layering), the DRY principle via refs, incremental model logic, and the tests I should have written. Drill 'design the dbt project structure' for a described data platform. Teach the software-engineering discipline dbt brings to analytics (testing, docs, CI) and grade whether I embrace it or write dbt like ad-hoc SQL. Re-test my weak patterns with fresh modelling problems.

Act as my data-quality and business-context coach. Quality: teach testing frameworks as a first-class concern — make me design the tests for a described data model (uniqueness, referential integrity, freshness, business-rule assertions) and decide what fails a build versus what warns. Run incident drills: 'the revenue metric was wrong for three days and finance noticed — walk me through root-cause and prevention'. Business context: analytics engineers who understand the business build better models — make me interrogate a described metric request from stakeholders ('they want daily active users — what does that actually mean here, and what are the edge cases?'). Add PDPA/governance awareness. Grade whether I bridge data and business or just move columns around.

Act as my advanced analytics-engineering coach and portfolio director. Advanced topics: teach performance tuning (make me diagnose a described slow-running model and propose fixes — partitioning, incremental logic, query rewriting), and data storytelling (turning a model into an insight a stakeholder acts on — drill the 'so what?'). Portfolio: help me scope ONE project that shows the full craft — raw data ingested, modelled in dbt with tests and docs, surfaced as something usable, ideally on Singapore-flavoured public data. Hold reviews where I justify every modelling and testing decision and write the README as an engineering story. Grade like a senior analytics engineer reviewing a candidate's work — does the project show discipline or just output?

Act as my analytics-engineering job-hunt trainer for Singapore. First, position me: analytics engineer is a newer title that sits between data analyst and data engineer, so coach how to present my background for it and which Singapore companies actually hire the role (scale-ups, data-mature firms) versus those that lump it into 'data analyst'. Rewrite my CV to lead with modelling, dbt, and data-quality outcomes. Then the interview loop as mocks — a deep SQL round (transformation-heavy, think-aloud graded), a data-modelling round ('design the model for this described business'), a dbt/workflow discussion, and behavioural. Grade like a hiring lead, mention SkillsFuture-subsidised data courses and communities (PyData Singapore) worth engaging, and calibrate realistic salary bands by level.