We are looking for a skilled Google Sheets expert to help us automate data analysis and create dashboards for our client payment data. The ideal candidate will have experience with Google Sheets formulas, Google Apps Script, and data visualization.

Responsibilities:

• Set up and organize Google Sheets for importing and managing patient payment data.
• Create and implement formulas to calculate key metrics such as patient lifetime value and monthly revenue.
• Develop Google Apps Scripts to automate data updates and analysis.
• Design and create interactive dashboards in Google Sheets for data visualization.
• Ensure data validation and consistency across sheets.
• Optimize performance for handling large datasets.

Requirements:

• Proven experience with Google Sheets, including advanced formulas and functions.
• Proficiency in Google Apps Script for automation.
• Strong understanding of data analysis and visualization techniques.
• Attention to detail and ability to ensure data accuracy.
• Excellent communication skills and ability to work independently.

Deliverables:

• Organized Google Sheets with monthly tabs and a master data sheet.
• Automated data import and consolidation using Google Apps Script.
• Formulas to calculate patient lifetime value, follow-up rates, and other key metrics.
• Interactive dashboards displaying key metrics and trends.
• Documentation of formulas and scripts for future reference.

Posted On: July 23, 2024 01:18 UTC
Category: Scripting & Automation
Skills:Google Apps Script, Google Sheets, Automation, Microsoft Excel, Scripting

Country: United States

click to apply