Data Analyst (Excel, SQL & Python)

Data Analyst (SQL & Python)

Salary: $2,100 USD Monthly
Location: Remote
Schedule: Monday – Friday, 8 AM – 5 PM CT (Night shift in the Philippines)

Role Overview:

We are seeking a detail-oriented Data Analyst to provide critical operational relief for a leading US-based media agency. This role is a unique blend of high-integrity execution and future innovation. Initially, you will own the manual data collection and processing workflows that power our 15-person analytics team, freeing them to focus on high-level client strategy.

The ideal candidate is technically literate, thrives on data integrity, and has the natural curiosity to "dig" into datasets to ensure every number ties out. While the immediate focus is execution, we are looking for a professional who will eventually use their Python and SQL skills to streamline and automate these processes once they become the subject matter expert.

Key Responsibilities:

- Manual Data Ownership: Perform daily manual data collection, grabbing/moving files, and ingesting data into our warehouse with 100% accuracy.
- Data Integrity & QA: Execute rigorous QA on datasets to ensure they follow strict naming conventions and file structures (CSV, etc.) required for platform ingestion.
- Pattern Recognition: Proactively flag discrepancies or "broken" patterns (e.g., identifying when data volume unexpectedly drops) and investigate the "why" behind the error .
- Visual Reporting: Create and modify dashboards and quick visualizations to clearly communicate data issues or performance trends to the team.
- Operational Support: Proactively communicate with managers regarding priorities, roadblocks, and deadlines to ensure workflows stay on track.

Qualifications:

- Education: Bachelor’s degree in Data Science, Computer Science, Statistics, Engineering, or a related quantitative field.
- Experience: Minimum of 2 years of professional experience in a data-focused role.

-Technical Skills:
- Excel Mastery: (Non-negotiable) Must be highly comfortable navigating and manipulating complex Excel files daily.
- SQL & Python: Proficiency required to support current data needs and future automation initiatives.
- Visualization: Experience with Power BI, Tableau, or Looker Studio; ability to "show" an issue through data.
- Databricks: Familiarity with Databricks is a significant plus.

Soft Skills:
- Technical Literacy: Ability to clearly explain the "why" behind technical roadblocks to non-technical stakeholders.
- Detail Obsession: A natural drive to ensure data is clean, consistent, and follows all internal standards.

Success Milestones:

- 3 Months: Fully onboarded to all scheduled manual workflows; producing accurate work with zero naming convention errors.
- 6 Months: Independently owning the end-to-end scheduled process; beginning to support ad-hoc "emergency" requests.
- 12 Months: Operating as a solid performer and contributing to innovation-based projects and proprietary tech initiatives.

Work Requirements:

- Excellent English: Must be highly "understandable" to facilitate fast-paced team coordination.
- Professional Setup: Quiet home workspace, stable internet with backup, and a reliable headset.

Benefits:

- Paid Vacation, Holiday & Sick Leave (after probation).
- Bi-Monthly, tax-free payroll via Wise.
- Dedicated Workspark support and leadership guidance.
- Opportunity to work with a high-impact team on national TV and streaming campaigns.

Application Instructions:

- Apply using this link: ---------- .
- Required: Include a short voice or video recording. In your recording: Highlight your Excel and SQL experience, share an example of a time you caught a data error by noticing a "pattern change," and explain why you enjoy the "digging" aspect of data analysis.

**Applications without a voice/video intro will not be review**