Data and Automation Specialist
New
P
PanoptycRetail Loss Prevention
Philippines, US Time, ESTFull-TimeMiddle
Salary4 - 7 USD per hour
Apply NowOpens the employer's application page
Job Details
- Required Skills
- SQLMicrosoft Power BITableauLooker
Requirements
- Proven mastery of SQL, including deep comfort with complex joins, aggregations, window functions, and query optimization.
- Hands-on, practical experience building business-facing reports in at least one major BI tool (e.g., Metabase, Power BI, Tableau, Looker, or similar).
- Demonstrated, provable experience building and shipping an actual AI-assisted script, automation, or internal tool.
- Ability to audit data structures, spot funnel anomalies, and maintain high-integrity reporting.
- Strong communication skills and ability to work effectively in a remote environment.
- Availability to work during US business hours (EST).
Responsibilities
- Write and optimize complex SQL queries utilizing joins, aggregations, and window functions to extract clean datasets.
- Build, deploy, and maintain intuitive BI dashboards to give teams clear visibility into key business metrics.
- Continuously monitor data quality, flag inconsistencies, and ensure a single source of truth across all reporting.
- Use advanced AI tools (Claude, ChatGPT, Copilot, or no-code AI builders) to prototype and ship scripts, tools, and workflows.
- Identify repetitive manual tasks across the organization that can be streamlined or eliminated through automation.
- Collaborate with cross-functional teams to translate vague business questions into structured analysis and actionable recommendations.
- Maintain clear documentation for data pipelines and automated tools so they can be easily scaled by the team.
View Full Description & ApplyYou'll be redirected to the employer's site
