Google Apps Script & VBA Developer

Data Ikseer, based in Saddar, Karachi, is looking for a talented Google Apps Script and VBA Developer to join their Engineering/Automation team on a full-time, onsite basis. The role focuses on creating tools, automating workflows, and delivering dependable Apps Script web applications across Google Workspace products such as Sheets, Docs, Slides, Forms, Gmail, Drive, and Calendar. The developer will oversee projects from scoping and design through development, testing, deployment, documentation, and light training. Close collaboration with operations and business stakeholders is essential to ensure solutions align with organizational goals.

Key Responsibilities
Design and develop Apps Script and VBA solutions, including custom menus, sidebars, add-ons, triggers (time-driven/installable), and HTMLService web apps with intuitive user interfaces. Automate workflows within Google Workspace by building pipelines, approval systems, and document generation for Docs, Slides, and Gmail. Experience with Power Apps is advantageous. Integrate external APIs (REST/JSON) using UrlFetchApp and Advanced Services like Sheets, Drive, Gmail, Admin Directory, and SharePoint, managing OAuth2 authentication, pagination, rate limits, retries, and error handling. Optimize script performance through batch operations, caching with CacheService, configuration via PropertiesService, and quota management. Develop secure solutions applying least-privilege scopes, protected ranges, audit trails, logging, and careful handling of personally identifiable information (PII). Use version control and continuous integration tools such as clasp and Git; structure code for reuse with libraries/modules, and implement linting and basic test coverage. Monitor and support applications using Cloud Logging, alerts, and fail-safes, maintaining SLAs for critical automations. Document solutions thoroughly by writing user guides and runbooks, and conduct brief training sessions for non-technical teams. Maintain and develop VBA macros in Excel for reporting, PDF export, data cleaning and reshaping, workbook structuring, printing/formatting, image handling, and cross-sheet consolidation, aligning with Google Apps Script workflows where applicable. Collaborate with stakeholders to gather requirements, estimate timelines, prioritize tasks, and deliver incremental value.

Required Qualifications
2 to 5+ years of experience developing production Google Apps Script solutions, including triggers, web apps, add-ons, and Advanced Services. Proven ability to connect Apps Script to Looker Studio data sources or build lightweight ETL processes between Sheets and databases involving read/write operations, batching, scheduling, and data transformations. Working proficiency in Python for scripting ETL, data processing, file operations, and simple REST API integrations. Strong expertise in spreadsheet formulas and functions in both Google Sheets and Excel, including lookups, array formulas, regex, date/time functions, and dynamic ranges. Solid VBA skills with the ability to design clean, maintainable macros featuring robust error handling and optimized performance. Fundamental knowledge of JavaScript/TypeScript, HTML, CSS, and vanilla JS for building HTMLService user interfaces. Strong UI/UX sensibility with an eye for design. Excellent problem-solving skills with structured debugging, clear trade-offs, and pragmatic solutions under constraints. Ability to work independently, owning projects end-to-end with minimal supervision and proactive communication.

Preferred Qualifications and Benefits
Familiarity with Google Cloud services such as Cloud Run, Cloud Functions, Firestore, BigQuery, Pub/Sub, and Cloud Scheduler, including service account management. Experience with Zapier or Make integrations, Docs/Slides templating, mail merge, and PDF generation. Knowledge of testing frameworks, ESLint/Prettier, and CI pipelines for clasp projects. Security awareness covering OAuth, scope reviews, PII handling, and access governance. Exposure to Power Apps and eagerness to learn additional automation tools. The position offers performance bonuses, health coverage, a learning stipend, and support for certifications. Employees benefit from modern equipment, a collaborative fast-paced environment, and internal upskilling opportunities to address skill gaps.

This is an onsite role based in Karachi, with working hours from 9:00 AM to 6:00 PM, six days a week, including a one-hour lunch break. There is a six-month probation period. The hiring process includes a brief introductory call, a video interview, a practical take-home assignment involving Google Apps Script and VBA automation with API integration and logging, followed by an onsite technical interview that includes a UI review of HTMLService projects. Offers are contingent on reference checks.

Data Ikseer is an equal-opportunity employer that values skill, curiosity, and integrity, welcoming candidates from diverse backgrounds. The monthly salary range for this role is Rs40,000 to Rs70,000. Candidates should hold a Bachelor’s degree or have completed at least two years of study in a technical field.
Job Skills
Pub/Subdynamic ranges)UI/UX DesignGitclaspCloud LoggingGoogle Cloud services (Cloud RunCloud FunctionsFirestoreBigQuerydate/time functionsCloud Scheduler)Zapier or Make integrationsTesting FrameworksESLint/PrettierCI PipelinesSecurity awareness (OAuthPII handlingaccess governance)REST/JSON API integrationVBAGoogle Workspace products (SheetsdocsslidesFORMSGmailDriveCalendar)Power AppsGoogle Apps ScriptOAuth2 AuthenticationJavaScript/TypeScriptHTMLCSSPythonSpreadsheet formulas and functions (lookupsArray FormulasRegex
Job Details
Industry:
Business Development
Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
First Shift (Day)
Job Location:
Karachi, Pakistan
Gender
No Preference
Age
18 - 65 Years
Minimum Education
Bachelor
Career Level
Entry Level
Maximum Experience
Doesn't Matter
Apply Before:
Oct 16, 2025
Posting Date:
Sep 15, 2025