Google Sheets Data Specialist

Описание

This role entails full ownership of the company's internal Google Sheets data system.

This includes organizing, syncing, and auditing to ensure reliability and accuracy.

Responsibility begins once it is pushed from the data warehouse into Google Sheets and extends through all synced and user-facing sheets.

Upstream and Data warehouses processes are managed by the development team.

The scope includes troubleshooting when data appears incorrect in Google Sheets and is responsible for end-to-end investigation to find the root cause.

Key Responsibilities: System Ownership & Integrity: Take full ownership of the Google Sheets ecosystem, ensuring all sheets, syncs, and automations are functioning reliably.

Maintain the overall health and efficiency of the Sheets environment.

Maintain sheet organization, data formulas, queries/imports, permissions, and any scripts/automation that support syncing and usability.

Implement safeguards (checks, simple monitoring, backups/versioning where needed) to reduce breakages.

Data Quality & Validation: Ensure data in Google Sheets is accurate, consistent, and timely.

Proactively monitor for anomalies, broken syncs, or discrepancies across all connected sheets.

Regularly verify that data in Google Sheets is complete, current, and consistent across the source sheet and downstream sales sheets.

Troubleshooting & Root Cause Analysis: Serve as the first point of contact for any data accuracy issues within the Google Sheets system.

When a data discrepancy is identified, conduct a thorough investigation to determine the root cause.

If the error originates within Google Sheets (e.g., a broken formula, incorrect sync configuration, or structural issue), the specialist is responsible for fixing it directly.

If the error originates upstream in the data warehouse, the specialist is responsible for collaborating with the development team to get it resolved.

Respond to and resolve sync failures, broken references, access issues, performance/calc errors, and user-reported problems .

Feature Development & Enhancements: Maintain and improve existing sheets and automation.

Implement new features and enhancements based on user requests and management approval.

Cross-Functional Collaboration: Work closely with the development team to ensure data is syncing correctly and to resolve any upstream data issues.

Act as the primary liaison between the sales team (end-users) and the development team for all matters related to this data system.

Communicate system changes, scheduled maintenance, or known issues to all stakeholders.

Powered by JazzHR