Job Closed
This listing is no longer active.
Panoptyc is a Micro Market security company. Giving operators margins, time and sanity back from theft and bad DVRs.
Data and Automation Specialist
Location
Philippines
Posted
7 days ago
Salary
$4 - $7 / hour
Seniority
Senior
Job Description
Data and Automation Specialist
Panoptyc
• Query Optimization: Write and optimize complex SQL queries utilizing joins, aggregations, and window functions to extract clean datasets. • BI Management: Build, deploy, and maintain intuitive BI dashboards to give teams clear visibility into key business metrics. • Data Quality Assurance: Continuously monitor data quality, flag inconsistencies, and ensure a single source of truth across all reporting. • AI Prototyping: Use advanced AI tools (Claude, ChatGPT, Copilot, or no-code AI builders) to prototype and ship scripts, tools, and workflows. • Process Automation: Identify repetitive manual tasks across the organization that can be streamlined or eliminated through automation. • Stakeholder Partnership: Collaborate with cross-functional teams to translate vague business questions into structured analysis and actionable recommendations. • Technical Validation: Maintain clear documentation for data pipelines and automated tools so they can be easily scaled by the team.
Job Requirements
- Solid SQL Foundation: Proven mastery of SQL, including deep comfort with complex joins, aggregations, window functions, and query optimization.
- Dashboarding Expertise: Hands-on, practical experience building business-facing reports in at least one major BI tool (e.g., Metabase, Power BI, Tableau, Looker, or similar).
- Provable AI Projects: Demonstrated, provable experience building and shipping an actual AI-assisted script, automation, or internal tool.
- Analytical Rigor: Ability to audit data structures, spot funnel anomalies, and maintain high-integrity reporting that stakeholders can trust without double-checking.
- Strong communication skills and ability to work effectively in a remote environment.
- Availability to work during US business hours.
Benefits
- Full remote work flexibility with a dynamic, global team
- Opportunity to deploy AI-assisted tools that visibly save team time within your first 1-2 months
Related Guides
Related Categories
Related Job Pages
More General Jobs
• Own a pipeline of homeowner applications and move each one through processing • Collect supplemental information from homeowners through our task/to-do service • Place orders with third-party vendors for documentation and reports underwriting needs • Communicate directly with vendors to track orders and resolve issues • Review all documentation for completeness and accuracy against our guidelines • Compile the full application package and complete an initial review for underwriting • Keep our Sales team informed throughout • Coordinate with our Signing and Funding team to close and fund investments
• Researching and monitoring specific billing issues, trends and potential risks • Reviewing and ensuring claims are submitted accurately with all pre-claim requirements • Tracking the status of claims and pulling reports to manage work • Reviewing denied/unpaid claims and taking appropriate corrective action • Providing administrative support for department(s) including data entry and record keeping • Navigating payor portals to check eligibility, prior authorization, claim or appeal statuses • Assisting patients with navigating the financial journey with compassion and accuracy • Verifying insurance/recipient benefits with Medicare, Medicaid and Private Insurer Payers
• Maintain personnel records in accordance with current legislation and established state standards • Maintain military records in accordance with current legislation and established state standards • Register employment, transfer, and dismissal of employees in accordance with the current labor law and regulations, instructions and orders approved by the company using appropriate forms and computer applications • Form and maintain personal files and data base of employees • Enter data into the personnel/payroll system • Fill, record keep and storage work books, accounting of employment history • Archive personnel files, prepare documents for shelving to the State Archives, if the time of storage in the enterprise has passed on • Provide personal data for accounting department, extra budgetary funds and tax inspectorate • Prepare with accountants documents required to obtain social benefits, granting of pensions, allowances and benefits to employees and their families and transfer them to the Social Welfare Authorities • Issue all kind of personnel certificates • Maintains computerized and paper records of employees, including records of annual leave, sick leave, leave without pay, and overtime. Prepares various personnel related reports for administrative staff and state authorities
• Validates expectations with customers before, during, and after project completion • Exceeds customer expectations on a regular basis while performing excellent customer service • Successfully manages multiple projects through all phases • Ability to work independently under pressure, to organize and prioritize workloads, and to keep several projects progressing to completion with little or no direction • Ability to weigh options, foresee consequences, and employ good judgment • Serves as a liaison between field technicians, department management, government bodies, and customers • Use independent judgment to handle and troubleshoot all inquiries, questions, and complaints • Proactively completes projects on time • Reviews and oversees completed plans and project documentation for accuracy • Monitors equipment production to ensure product integrity • Consistently meets the overall project deadlines in a timely manner • Builds trust and confidence with contractors and the Project Management Team • Assists with managing multiple subcontractors across multiple states • Recruits and develops business relationships with new subcontractors • Drives sales and profitability through effective and efficient project execution • Understands principles and methods for showing, promoting, and selling products or services • This includes marketing strategy and tactics, product demonstration, sales techniques, and sales control systems




