We are seeking a highly skilled and experienced Data Analyst to join our team. The ideal candidate will have a strong background in working with various spreadsheet applications, creating automated reports and dashboards, and leveraging advanced formulas and functions to automate data processing. Additionally, proficiency in Google App Scripts, Google Data Studio, Looker, and REST APIs is required.
Key Responsibilities:
• Develop, maintain, and automate reports and dashboards using Google Sheets.
• Utilize a wide range of formulas and functions, from simple to complex, including VLOOKUP, INDEX MATCH, IMPORTRANGE, IF Functions, NESTED IF, NESTED QUERY, and NESTED ARRAYS.
• Write and implement Google App Scripts for data automation, including data entry, data transfer between sheets, connecting various spreadsheets, and scheduling automated tasks.
• Create and manage data visualizations using Google Data Studio and Looker.
• Connect and integrate API endpoints with Google Sheets or other applications to facilitate data flow and reporting.
• Analyze data sets to identify trends, patterns, and insights that can inform business decisions.
• Collaborate with various departments to understand their data needs and provide tailored solutions.
• Ensure data accuracy, integrity, and security across all reports and dashboards.
Qualifications:
• A minimum of 4 years of experience working with spreadsheet applications, including Google Sheets.
• Proven experience in creating automated reports and dashboards.
• Extensive knowledge of advanced spreadsheet formulas and functions.
• At least 2 years of experience with Google App Scripts for automation purposes.
• Proficiency in Google Data Studio and Looker for data visualization.
• Experience with REST APIs, including connecting API endpoints to Google Sheets or other applications.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Detail-oriented with a strong focus on data accuracy and quality.
• Experience with other data visualization tools and platforms.
• Knowledge of SQL and database management.
• Experience in a similar industry or business sector.
For you to apply for this position:
Please fill out this form:
/forms/583ad684563ed2520da88a78b59b2043?r=use1
Keep your skype notifications active so we can reach you there.”
APPLY FOR THIS JOB:
Company: Kooshy Kids / Ms Fierce
Name: Maan Calizar
Email: