IT Specialist

Description

Job Summary: We are seeking a data administration and dashboard development specialist who designs, optimizes, and automates processes using Google Workspace and AppSheet. Key Highlights: 1. Database design and optimization in Google Sheets. 2. Development of interactive dashboards using Google Sheets and AppSheet. 3. Process automation with Google Apps Script and AppSheet. **Key Responsibilities:** * **Data Administration and Reporting:** * Design, maintain, and optimize databases in **Google Sheets** (data normalization, validations, named ranges, SQL-like queries using QUERY). * Manage information capture systems via **Google Forms**, including branching logic, validations, and integration with spreadsheets. * Create and maintain **automated reports** (daily, weekly, monthly) with scheduled email delivery or embedded dashboards. * **Dashboard and Visualization Development:** * Build interactive dashboards in **Google Sheets** (dynamic charts, slicers, checkboxes, advanced conditional formatting) and/or in **AppSheet** (dashboard views, charts, KPIs). * Implement real-time or on-demand update controls for dashboards. * **Automation with Google Apps Script:** * Develop, debug, and maintain **custom functions** and **macros** in Apps Script to automate repetitive tasks (data cleaning, report generation, mass email sending, document/PDF creation). * Create **time-based or event-driven triggers** (on form submission, cell edit, file opening). * Integrate Google Sheets with other Google services (Calendar, Drive, Gmail, Slides) and external APIs such as UrlFetchApp. * **App Development with AppSheet:** * Design, implement, and maintain **mobile and web applications** in AppSheet connected to Google Sheets or SQL databases. * Configure security (user-based filters, roles), workflows (Workflows), bots, PDF reports, and native AppSheet automations. * Write advanced AppSheet expressions (ANY(), FILTER(), SELECT(), custom actions using AppSheet Automation). * **Data Integrity and Security Management:** * Implement backup and versioning systems for critical databases. * Control access permissions to spreadsheets, forms, scripts, and applications. * Monitor and resolve errors in scripts, data connections, or dashboard performance. * **Continuous Improvement and Documentation:** * Identify bottlenecks in current reporting processes and propose automated solutions. * Document script logic, database structure, and user manuals for dashboards and applications. **Daily / Weekly Activities (Examples):** * **Morning:** Review Apps Script triggers consolidating data from 10 forms into a master sheet. Verify sales dashboards display correct data. * **Development:** Write an Apps Script function that pulls data from a sheet, generates a PDF with charts, and emails it to 5 managers. * **Maintenance:** Add a new field to a Google Form, modify the associated script, and update the AppSheet app to display that data. * **Optimization:** Redesign a flat database in Sheets to use faster QUERY functions and reduce dashboard loading time. * **App Creation:** Build an inventory app in AppSheet with barcode scanning, offline synchronization, and automatic stock updates in Sheets. * **Support:** Resolve incident: an automated report failed to send because the reference cell had a formatting error. Adjust validation. **Minimum Requirements:** **Technical:** Advanced proficiency in Google Sheets (complex formulas, arrays, QUERY, IMPORTRANGE, validations). **Expert Spreadsheet Management:** (branching logic, sections, integration with Sheets). **Programming applicable to Google Apps Script / AppSheet:** (basic/intermediate JavaScript, SpreadsheetApp, DriveApp, MailApp, triggers, advanced services). Proven experience developing applications in AppSheet (UX knowledge for apps, expressions, actions, security, deployment). Ability to read and write SQL-like queries (within QUERY or for AppSheet). **Desired Competencies:** * Analytical ability and problem-solving orientation. * Autonomy to propose improvements and execute them. * Meticulous attention to detail (especially in data logic and permissions). * Clear communication skills to explain dashboards and automations to non-technical users. Requirements: \* Conversational English is indispensable \* Bachelor's Degree \* Experience in the automotive industry (2 years) We offer: \-Transportation \-Subsidized Cafeteria \-Benefits by law \-Ag 12 days \-V.B 50 % \-S.F 8% \-F B $400p/week \-Holidays by law Salary: $30,000\.00 \- $40,000\.00 per month Benefits: * Transportation assistance or service * Company parking * Free parking * Option for indefinite-term contract * Cafeteria service * Company phone * Grocery vouchers Work Location: On-site employment