Data Analyst (SQL and Python) - Permanent Work From Home

I am looking for a SQL and Python Data Analyst for our growth marketing team in the US. This teammate manipulates data, creates and runs SQL and Python queries to build dashboards, and generates reports for data analytics requests. In addition to report creation, this teammate provides timely and accurate data or performance analysis, insights, and recommendations.

Salary Range: PHP 70,000 - 90,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 From Home
- Attendance, Performance, and Referral Bonuses
- Paid Holidays and Time Offs
- Health Insurance Card

The Role:
- Manipulate data by sorting, scrubbing, tagging, cleaning, and de-duping using MS Excel and other existing applications
- Run original or unique queries or codes within SQL and Python to compile data from Mode Analytics and Lookr
- Build reports and dashboards
- Analyze performance
- Write simple reports to summarize performance

The Requirements:
- Must have proficient to advanced knowledge in SQL and Python programming (can do the end-to-end scripting and running of queries)
- Must have experience with Mode Analytics, and Lookr, and other similar BI tools (i.e., Tableau, Domo).
- Proficient to Expert in using Microsoft Excel (can do advanced formulas) and used it for 2+ years for data manipulation and analytics is a must-have
- E-commerce experience is a must
- Understanding or showing interest in Beauty/Cosmetics is strongly preferred
- Must be detail-oriented, highly organized, data-driven, proactive, and prompt in completing deliverables
- Excellent English communication skills (both verbal and written)
- Must work on graveyard shift following any timezones in the US

Job details:
Salary range: 70,000 - 90,000
Work Schedule: EST Night shift
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. Google Analytics, 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 and Python programming (can do the end-to-end scripting and running of queries)? If yes, for how many months?
2. Tell me at least 5 or more of your favorite tasks when handling the end-to-end scripting?
3. 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?
4. Tell me at least 5 or more of your favorite tasks when handling the E-commerce platform?
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. Do you have any experience using Microsoft Excel (can do advanced formulas)? If yes, for how many months?
8. Have you used MS excel for data manipulation and analytics? If yes, for how many months?
9. 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:
10. Areyou comfortable with the prospect of working between 9:00 PM and 6:00 AM Philippine time?
11. Preferred Interview schedule or availability for an interview:

I am looking for someone who wants to grow as part of a team. Ideal candidates desire to learn and grow, take on more responsibilities along the way, and be resourceful enough to gather enough information to help provide accurate analysis and insights. Join our team now!