Senior Full-Stack Engineer — Reporting

4 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 roleOwn thereporting stackand anAI-assisted "build a report" experience. You'll model data, ship dashboards in, and use anAI SDKto turn natural-language requests into safe, auditable report specs (not free-form SQL). Domain: healthcare/dental practice data.What you'll doDesign 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 experience5+ 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 & benefitsTarget 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 PuzzleYou're building "Active Patients (Last 28 Days)per clinic" withlocal-time correctnessandhistorical accuracy.Tablesfact_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≥2appointment_attended eventsin the past 28 calendar daysin the clinic's local time, excluding is_test = true. Count each patientonce per clinic(no double-counting across SCD-2 versions). Ignore appointment_canceled. Late events may arrive up to48 hoursafter they occurred.Tasks (concise is fine):Write PostgreSQL SQL to compute the current per-clinic count (convert UTC → clinic local time; join SCD-2 by event time ).Outline an incremental refresh that's idempotent and handles 48h late arrivals (keys/watermarks you'd use).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' inUTCwill fail.Apply NowAbout The Dev Studio / Bonded.PKThe 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

    2 weeks ago

    Karachi, Sindh, Pakistan Digitrends Full time 720,000 - 1,080,000 per year

    Senior Fullstack Engineer 15, React 19, TypeScript + Ruby on Rails yrs)Responsibilities· Design, develop, and maintain scalable fullstack web applications.· Build robust GraphQL APIs using Ruby on Rails 7.1.· Implement modern, responsive UIs with 15, React 19, and TypeScript.· Collaborate with product managers, designers, and engineers to deliver...

  • Full Stack Engineer

    4 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

    2 weeks ago

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

    Introduction:VerraCloud is seeking a Full Stack Engineer & React)with 5+ years of professional experience to join our fully remote team. This is aproject-based contract rolewith competitive pay. As a key contributor, you'll design, build, and maintain secure, scalable, and high-performance full-stack applications while working in a collaborative, agile...

  • Full Stack Engineer

    2 weeks ago

    Karachi, Sindh, Pakistan At Web Technologies Full time 600,000 - 1,200,000 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,...

  • Full Stack Engineer

    2 weeks ago

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

    Job Title:Full Stack Developer (Mid-Level)Location:Karachi (On-site)Job SummaryWe are seeking a proactive and fast-learningFull Stack Developerwith mid-level experience to join our engineering team. The ideal candidate combines strong frontend and backend development skills with alow-code/no-code mindset, leveraging tools likeZapier, n8n, and Maketo automate...

  • Full Stack Engineer

    4 days ago

    Karachi, Sindh, Pakistan HashOne Global Full time 1,800,000 - 2,700,000 per year

    About the RoleWe're seeking an 1-2 year experienced Full Stack Developers who can bridge the gap between traditional web development and AI solution implementation. In this role, you'll work on building scalable web applications while integrating AI capabilities to enhance product functionality and user experience.ResponsibilitiesDesign, develop, and...

  • Senior Full Stack Developer

    2 weeks ago

    Karachi, Sindh, Pakistan PublishEX Solutions Pvt. Ltd. Full time 2,500,000 - 3,000,000 per year

    Simpaisa is looking for a skilled Senior Full Stack Developer who is proficient in both backend and frontend development. You will be responsible for designing, developing, and maintaining scalable applications, ensuring seamless integration between server-side logic and user-facing interfaces.Key ResponsibilitiesDesign, develop, and maintain web...

  • Senior Full Stack Developer

    5 days ago

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

    Job Title: Senior Full Stack Developer & )Location: Gulshan, Block 13Timings: 11:00 AM – 8:00 PMKey Responsibilities:Design, develop, and maintain scalable web applications using (frontend) and (backend).Write clean, efficient, and maintainable code following best practices.Collaborate with cross-functional teams to deliver high-quality solutions on...

  • Full Stack Engineer

    2 weeks ago

    Karachi, Sindh, Pakistan Vinspyre (Pvt.) Ltd Full time 1,200,000 - 2,400,000 per year

    Job Title: Full Stack DeveloperLocation:Defence Phase 8, KarachiJob Type:On-site (Full-time)Timings:6:00 PM – 3:00 AM (Night Shift)Experience Required:2–3 YearsSalary:Market CompetitiveJob Description:We are looking for a skilled and motivatedFull Stack Developerto join our growing team. The ideal candidate will have hands-on experience in both front-end...

  • Full Stack Engineer

    5 days ago

    Karachi East District, Sindh, Pakistan OpenPort Full time 600,000 - 1,200,000 per year

    Company DescriptionOpenPort is a pan-Asian start-up committed to making trucking, logistics, and supply chain operations more efficient in Emerging Markets with its open, secure, and AI-based platform. Our solutions provide visibility, reliability, and security, ensuring higher cash flows and stronger sales for our clients. We are proud to help move some of...