Retention Data Analyst (Advanced SQL) - Permanent Work From

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Full Time

SALARY

80,000php - 100,000php

HOURS PER WEEK

40

DATE POSTED

Apr 23, 2024

JOB OVERVIEW

Join GrowthAssistant as a Retention Data Analyst (Advanced SQL)!

Are you ready to dive into the dynamic world of data analysis and make a tangible impact on customer retention strategies? We're seeking a talented individual to join our team and drive actionable insights through data. If you're passionate about leveraging SQL expertise and dashboarding tools to optimize retention efforts, we want you!

Salary Range: PHP 80,Upgrade to see actual info,000 per month
Note: Rate/Salary will depend on your current competencies matched to the position’s job description and requirements based on the assessment results.

The Benefits
- Work Set-up: Permanent Work From Home

Bonuses:
- Attendance Bonus of $ 25 for every monthly perfect attendance
- Performance Bonus
- Anniversary Bonus of PHP 5,000 for your 1st year in service and PHP 10,000 for 2 years in service
- Referral Bonus of $ 300 for every successful referral
- Holiday Paid Time Off (PTO) for 7 days in a year
- Paid Time Offs (PTO) for 6 days in a year
- Prepaid Health Card

The Role:
- Audit and Maintain Dashboards: Keep our data visualization tools in top shape by auditing and maintaining existing dashboards in Sigma, ensuring they accurately reflect key metrics.
- SQL Query Wizardry: Write advanced SQL queries to extract insights from large datasets, solving complex reporting challenges.
- SQL Troubleshooting Whiz: Dive into SQL tables to troubleshoot and resolve downstream reporting issues, ensuring smooth data flow.
- Become a Data Guru: Dive deep into our database and table structures, becoming the Subject Matter Expert (SME) for ad-hoc reporting requests providing insights that drive strategic decisions.
- Data Investigation and Manipulation: Roll up your sleeves to handle data entry, investigation, quality assurance, and manipulation tasks, including sorting, scrubbing, tagging, cleaning, and de-duping.
- Insightful Reporting: Deliver daily, weekly, and monthly reporting on various data sets, empowering stakeholders with actionable insights to drive retention strategies forward.
- Create and Troubleshoot Reports: Take the lead in creating, validating, and troubleshooting new reports, ensuring accuracy and reliability.
- Documentation Maven: Document standard operating procedures (SOPs) and guides as needed, ensuring transparency and knowledge transfer within the team.

The Requirements:
- 3+ Years SQL Mastery: Demonstrated expertise with advanced SQL skills, enabling you to wrangle data easily and precisely.
- 2+ Years of Sigma (or similar platform) Experience: Proficiency in dashboarding tools like Sigma, Looker, or similar, with hands-on experience creating and maintaining dashboards.
- Analytical Ace: Proven track record of analyzing and reporting on large sets of marketing data from various sources, driving actionable insights to enhance customer retention strategies.
- Retention Data Expertise: Experience working with retention data and terms, such as email, push, and SMS, to fine-tune retention strategies and improve customer engagement.
- Tech-Centric Background: Familiarity with tech-centric or app-centric environments (e.g., Grab, Food Panda), providing valuable insights into industry-specific challenges and opportunities.
- Communicator: Excellent English communication skills (both verbal and written)
- Behavioral Traits: Detail-oriented, highly organized, data-driven, proactive, and prompt in completing deliverables.
- Time-Zone Friendly: Ability to work in any timezone in the US or graveyard/night shift schedule in the Philippines, ensuring effective collaboration with our global team.

Job details:
Salary range: 80,Upgrade to see actual info,000
Work Schedule: EST Night shift (tentative 9:00pm - 6:00am Philippine time)
Work setup: Permanent Work From Home
Employment type: Contractual fulltime employment

If you're interested, please send me the following details for faster processing: I will PRIORITIZE your application, if you will provide me the ff:
Full name:

Email
:
Mobile Number:
Send your CV/Resume or send me the link of your CV (upload it to your google drive and send me the link: should be downloadable file):
Tools used before (Ex. Sigma, Looker, and other similar platforms):

Clarification: (The following information below might not be disclosed in your resume)
1. Do you have any advanced knowledge, and experience in SQL skills, enabling you to wrangle data easily and precisely? If yes, for how many months?
2. Tell me at least 5 or more of your favorite tasks when handling or working with SQL?
3. Do you have any experience working with dashboarding tools like Sigma, Looker, or similar, with hands-on experience creating and maintaining dashboards? What tool, and for how many months?
4. Tell me at least 5 or more of your favorite tasks when handling or working with analyzing and reporting on large sets of marketing data from various sources?
5. Do you have any experience with Retention Data Expertise: Experience working with retention data and terms, such as email, push, and SMS, to fine-tune retention strategies and improve customer engagement? If yes, for how many months?
6. Have you processed marketing data sets? If YES, what metrics do you usually pull out and create for data reporting?
7. Have you used MS excel for data manipulation and analytics? If yes, for how many months?
8. Have you gained any experience working during a night shift or graveyard schedule within the last six months? If not within this timeframe, please specify when. Provide the date:
9. Are you comfortable with the prospect of working between 9:00 PM and 6:00 AM Philippine time?
10. Preferred Interview schedule or availability for an interview:

If you're ready to make an impact in a fast-paced, data-driven environment, apply now and join our team of passionate professionals!

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin