-
-
TYPE OF WORK
Full Time
-
-
SALARY
870
-
-
HOURS PER WEEK
40
-
-
DATE UPDATED
Mar 16, 2026
Senior Analytics Engineer
IMPORTANT: Candidates who don't complete Round-1 are NOT considered.
Why this role exists
Turn messy operational data into clean models, deterministic validations, reconciled outputs, and executive-ready evidence—so leadership can file on time, pass reviews, and make decisions with confidence. You’ll move quickly from MVP to repeatable, low-touch workflows.
What you’ll do (outcomes)
1. Model & Validate: Build tidy star-schema models; write rule-based checks (completeness, allowed values, tie-outs, negative/zero policies) that prevent bad data from shipping.
2. Reconcile: Prove totals reconcile to control numbers; maintain balance ? flow bridges; keep exceptions at zero by close.
3. Evidence-ready outputs: Produce clean, fixed-layout exports and one-page views that hold up under review.
4. Cadence & reliability: Own refresh schedules, light automation for deadline windows, and receipt/acknowledgment capture.
5. Iterate to MVP: Ship weekly increments, simplify the path to first-pass acceptance, and reduce manual touches.
Must-have qualifications
1. SQL + data modeling: Built analysis-ready models; can explain grain, joins, lineage.
2. Validation mindset: You write acceptance-grade rules (uniqueness, ranges, null policies, reconciliations) and block releases when controls fail.
3. Power BI competence: Data model + core DAX + clean pages; can wire simple RLS and test it.
4. Clarity & artifacts: Concise written English; tidy notes; reproducible steps.
5. Portfolio/snippets: PBIX/SQL/screenshots + a short “what changed & why” note.
We welcome adjacent profiles: strong Data Engineers with modeling/quality chops, or Power BI Analysts who write SQL and adopt modular/dbt-style patterns. If you’re great at rules and reconciliations, we’ll teach the missing bits.
Nice-to-have
- Modular SQL transforms (dbt-style).
- Expectation-style data-quality tests and exception reporting.
- Basic orchestration/automation (scheduled refresh, light UI automation, receipt capture).
- Finance literacy (control totals, variance basics).
System requirements
- Windows 10/11, Power BI Desktop, 16GB RAM (recommended minimum), stable internet ?25 Mbps.
How we work
- Async-first, low meetings: clear runbooks, quick reviews, Ship > Talk.
- Short loops: weekly deliverables that reduce rework and manual effort.
- Ownership: you propose controls, not just visuals.
- Microsoft-first, lean stack: we teach specifics.
- Acceptance bar (used in trials & ongoing work)
- Models reconcile to control totals within tolerance.
- All validations green at file time; exceptions cleared with notes.
- Evidence pages export cleanly (pagination, labels, links).
- A trained teammate can reproduce the flow at 5PM on close day.
30/60/90 milestones
Day 30: Core transaction slice modeled; ?10 validation checks; one exceptions view.
Day 60: Balance-to-flow tie-outs operational; daily variance view.
Day 90: Coverage/adequacy slice packaged with artifacts; light automations for deadline windows.
Compensation & schedule
- Core availability 2:00–8:30 PM EST; 8:30–10:30 PM EST (As-needed window). Pay applies to meetings + assigned build work only.
- Contractor, target ~$5-7 USD/hour.
How to apply (required)
- Complete a short, free Round-1 audition (30-60 min, offline).
- We provide a small regulatory-reporting sample dataset plus context.
You submit:
- A rules list (what you’d validate and why)
- A compact transform plan (SQL-like or pseudo-dbt)
- One clean Power BI page (PBIX) with a brief reconciliation note
- A 90-sec Loom walk-through showing your PBIX and transform logic
Applicant Keywords
Power BI, DAX, SQL, Star Schema, RLS, Data Modeling, ETL/ELT, Data Validation, Reconciliation, Paginated Export, Automation, Analytics Engineer, Data Engineer
