Retention Data Analyst (Advanced SQL) – Permanent Work From

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,000 – 100,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,000 – 100,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. Tell me at least 5 or more of your favorite tasks when handling or working with SQL & Python: Would appreciate it if you can enumerate it separately:
2. Do you have any experience working with Mode Analytics, and Lookr, and other similar BI tools (i.e., Tableau, Domo)? What tool, and for how many months?
3. Tell me at least 5 or more of your favorite tasks when handling the E-commerce platform? (Not really required, but woul be an advantage)
4. Do you have any experience using Microsoft Excel (can do advanced formulas)? How do you use Excel in your day to day tasks?
5. Have you implemented any retention marketing strategies in your previous/current employer? And/or have you processed data for analysis and reporting pulled out from these marketing strategies?
6. Have you processed marketing data sets? If YES, what metrics do you usually pull out and create for data reporting? Example: SMS or Email
7. Do you have any experience using Microsoft Excel (can do advanced formulas)? How do you use Excel in your day to day tasks?
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!