Senior Full-Stack Engineer — Reporting

2 days ago

Karachi, Sindh, Pakistan The Dev Studio Full time 1,800,000 - 6,600,000 per year

Location:
Karachi (Pakistan residents only; hybrid/remote with occasional office days)

Type:
Full-time
•
Senior (5+ years)

About the role

Own the
reporting stack
and an
AI-assisted "build a report" experience
. You'll model data, ship dashboards in

, and use an
AI SDK
to turn natural-language requests into safe, auditable report specs (not free-form SQL). Domain: healthcare/dental practice data.

What you'll do

  • Design a
    metrics/semantic layer
    ), pre-aggregations, caching & freshness SLAs.
  • Build

    (App Router) reporting UIs: filters, access control, scheduling/exports.
  • Write robust SQL for
    PostgreSQL
    (window functions, indexes, EXPLAIN).
  • Implement
    SCD-2 history
    , incremental loads, and
    data-quality tests
    (uniqueness, FK, ranges).
  • Use an
    AI SDK
    to generate report artifacts/specs and prevent unsafe queries.
  • Own performance, observability, and documentation.

Must-have experience

  • 5+ years
    with
    TypeScript/Node
    and

    (App Router, Route Handlers/Server Actions).
  • PostgreSQL
    mastery (window functions, CTEs, indexing, query plans).
  • Real-world
    reporting/analytics
    : metrics modeling, pre-aggs, cache invalidation.
  • SCD-2
    and incremental data patterns; strong testing mindset.
  • Hands-on with an
    AI SDK
    (e.g., Vercel AI SDK) to orchestrate NL → structured spec.

Nice to have

  • or dbt (models/tests/docs), Great Expectations.
  • Inngest/Temporal, scheduled reports, background jobs.
  • Healthcare/PMS data familiarity.

Compensation & benefits

  • Target salary:
    ~
    PKR 550,000/month (gross)
    — negotiable based on seniority.
  • Benefits:
    Medical coverage, provident fund,
    company laptop/monitor & licensed tools
    , paid annual leave, yearly review,
    occasional international travel
    for on-sites/customer work.

Screening Puzzle

You're building "
Active Patients (Last 28 Days)
per clinic" with
local-time correctness
and
historical accuracy
.

Tables

  • fact_event (event_id, clinic_id, patient_id, event_type, amount, occurred_at_utc, ingest_id)
  • – events include: appointment_attended, appointment_canceled, payment_received, etc.
  • dim_patient_scd2 (patient_key, source_id, full_name, email, is_test, valid_from, valid_to, is_current)
  • – SCD-2: a row is valid where ts >= valid_from AND ts < COALESCE(valid_to, 'infinity').
  • dim_clinic_tz (clinic_id, tz_name)
  • – IANA time zone per clinic.

Metric (read carefully)

"Active Patient" = a patient who had
≥2
appointment_attended events
in the past 28 calendar days
in the clinic's local time
, excluding is_test = true. Count each patient
once per clinic
(no double-counting across SCD-2 versions). Ignore appointment_canceled. Late events may arrive up to
48 hours
after they occurred.

Tasks (concise is fine):

  1. Write
    PostgreSQL SQL
    to compute the
    current
    per-clinic count (convert UTC → clinic local time; join SCD-2 by
    event time
    ).
  2. Outline an
    incremental refresh
    that's
    idempotent
    and handles
    48h
    late arrivals (keys/watermarks you'd use).
  3. List
    three pitfalls
    a naive solution would get wrong (e.g., SCD-2 double-count, DST/zone boundaries, canceled events, duplicate ingests).

Note: A naive GROUP BY patient_id HAVING COUNT(*) >= 2 or filtering with now() - interval '28 days' in
UTC
will fail.Apply Now

About The Dev Studio / Bonded.PK

The Dev Studio (est is posting this role on behalf of Bonded.AI a business division of The Dev Studio and the Pakistan regional entity of Bonded, an AI-driven patient-journey platform for healthcare practices. We unify clinic data across legacy PMS, automate communications, and streamline financial workflows.

Supported locally by The Dev Studio's management team.

  • Senior Full Stack Engineer

    3 weeks ago

    Karachi, Sindh, Pakistan Stellic Full time

    Join to apply for the Senior Full Stack Engineer role at StellicJoin to apply for the Senior Full Stack Engineer role at StellicGet AI-powered advice on this job and more exclusive features.Stellic EngineersStellic engineers combine a rare blend of curiosity, creativity, and business acumen with the ability to deliver pragmatic solutions at high velocity...

  • Full Stack Engineer

    3 weeks ago

    Karachi, Sindh, Pakistan SnarkLabs Full time

    As a Full Stack Developer, your responsibilities will span the entire software development life cycle, with a focus on both backend and frontend technologies, particularly , React, and You will:Develop and maintain web applications using for frontend and for backend.Collaborate with UI/UX designers to translate design vision into functional web...

  • Full Stack Engineer

    3 weeks ago

    Karachi, Sindh, Pakistan ibex Full time

    Are you passionate about creating robust and scalable software solutions?Join us as a Full Stack Developer and play a key role in building impactful applications. We're looking for someone with a strong technical background, problem-solving mindset, and collaborative attitude to help shape our innovative projects.What You'll Do:• Design, develop, and...

  • Senior Full Stack Developer

    2 weeks ago

    Karachi, Sindh, Pakistan MarkyTech Full time

    OverviewJob Title: Senior Full Stack DeveloperLocation: Bahadrabad, KarachiJob Type: Full-timeJob DescriptionWe are seeking an experienced Senior Full Stack Developer to design, develop, and deploy scalable and efficient web applications. You\'ll work closely with our teams to deliver high-quality solutions that meet our clients\'...

  • Full Stack Engineer

    2 days ago

    Karachi, Sindh, Pakistan Impleko Full time 900,000 - 1,200,000 per year

    Company DescriptionImpleko offers end-to-end services such as MVP development, product design, automation, integration, and AI assistant development. They assist businesses in bringing creative concepts to reality and optimizing processes with automation. Impleko serves various industries like Healthcare, eCommerce, Finance, Education, and more, helping them...

  • Full Stack Engineer

    1 week ago

    Karachi, Sindh, Pakistan At Web Technologies Full time $104,000 - $130,878 per year

    Company DescriptionAt Web Technologies builds intelligent digital solutions that automate, optimize, and scale businesses. We specialize in AI-driven development, integrating tools such as ChatGPT APIs, AI agents, and n8n for workflow automation. Our solutions range from smart websites and automated mobile apps to AI-powered e-commerce and CRM integrations,...

  • Senior Full Stack Engineer

    2 weeks ago

    Karachi, Sindh, Pakistan Stellic Full time

    Senior Full Stack EngineerLocationHybridEmployment TypeFull timeAbout StellicWe're building a future where every student can move through their education with clarity, confidence, and purpose. Our platform transforms the student experience, giving them the tools they need to make the right decisions about their degree plans, track their journey, and build an...

  • Sr Full Stack Developer Engineer

    3 weeks ago

    Karachi, Sindh, Pakistan Nativebrains Full time

    Looking for a Sr. Full Stack Engineer with strong expertise in both back-end and front-end technologies to join our Native Brains Team.Back-end SkillsLaravel (Must)PHP (Other frameworks)Front-end Skills (Must)Tailwind CSS(Experience with other front-end frameworks is a plus)Database SkillsProven track record of working on complex projects.ExperienceMinimum...

  • Senior Full Stack Software Engineer

    6 days ago

    Karachi, Sindh, Pakistan beBeeEngineer Full time 400,000 - 450,000

    Key Job Responsibilities:We are seeking a highly skilled engineer to fill this role. As an engineer, you will be responsible for designing and developing full-stack web applications using the MERN stack.Responsibilities: Design and develop robust backend APIs and services using Node.js and TypeScriptDevelop responsive and dynamic frontend interfaces using...

  • Full stack Engineer

    2 weeks ago

    Karachi, Sindh, Pakistan Softechww Full time

    Full stack Engineer (Angular & .Net) at Softech WorldwideVIDIZMO, a USA company headquartered in Tysons, Virginia, is a Microsoft Gold Applications & Cloud Partner recognized in Gartner Magic Quadrant for Enterprise Video Content Management. We provide cutting-edge technology solutions for Fortune 500 companies, large, medium-sized enterprises, and the...