Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Xtendops

NewBe an early applicant

Data Analyst | On-site

Posted

Summary

On-site data analyst in Iloilo City turning operational and financial data into insights for executives, team leaders, and clients — extracting and cleaning data, building models and dashboards, investigating business changes, and automating work with SQL, Snowflake, Python, Google Apps Script, Excel/Sheets, and AI tools like Claude.

Salary: ₱45,000 – ₱55,000 per month

Job Overview

We are looking for a Data Analyst who can turn operational and financial data into useful insights that help executives, team leaders, and clients make better decisions.

This is more than a reporting role. You will work on data from start to finish — extracting and cleaning data, building analysis and dashboards, finding the reasons behind business changes, and presenting clear recommendations.

You will mainly use SQL, Snowflake, Python, Google Apps Script, Excel/Google Sheets, and AI tools such as Claude.


Key Responsibilities

Data Analysis & Modeling

  • Extract and combine data from Snowflake, operational systems, client files, and APIs.

  • Use SQL and automated processes instead of relying on manual data pulls.

  • Clean and validate data and identify errors or incorrect records.

  • Create checks to make sure incorrect numbers do not reach reports or dashboards.

  • Build reusable data models, tables, metrics, and semantic layers.

  • Make sure data and metrics are consistent and easy for other analysts to understand and reuse.

Reporting & Dashboards

  • Build and maintain reports, dashboards, and KPI views.

  • Create reports used by executives, team leaders, and clients.

  • Turn business processes into measurable KPIs.

  • Compare performance across different periods, locations, and clients.

  • Create clear and accurate charts and visualizations.

Root Cause & Business Analysis

  • Investigate why a metric or business result has changed.

  • Identify the key drivers behind performance changes.

  • Analyze variances, trends, and unusual results.

  • Provide recommendations based on your findings.

  • Use basic statistical methods to identify patterns, trends, and outliers.

  • Support forecasting and business decision-making.

Automation

  • Use Python to automate recurring analysis and data tasks.

  • Use Google Apps Script to automate Google Sheets and Workspace workflows.

  • Build scheduled refreshes, alerts, integrations, and other tools that reduce manual work.

  • Connect data sources to Google Sheets and other business tools when needed.

Documentation & Communication

  • Present analysis clearly to executives, team leaders, and clients.

  • Explain your findings, supporting data, and recommendations in a way that is easy to understand.

  • Document your queries, models, processes, and analysis so others can maintain or reuse your work.

Required Skills & Qualifications

Technical Skills

  • SQL: 2+ years of production experience. Strong knowledge of joins, CTEs, window functions, and query optimization.

  • Data Modeling: Understand star schemas, data grain, slowly changing dimensions (SCDs), and metric definitions.

  • Python: 1+ year of experience using Python for data analysis and automation, including pandas and API calls.

  • Google Apps Script: Experience automating Google Sheets and Google Workspace.

  • Excel & Google Sheets: Advanced skills with pivot tables, lookups, array formulas, and structured data models.

  • Data Visualization: Experience with Power BI, Tableau, or a similar tool.

  • Statistics: Understand distributions, variance, correlation vs. causation, basic forecasting, and identifying statistical noise.

  • Cloud Data Warehouses: Experience with Snowflake is preferred. Experience with another cloud data warehouse is acceptable if you can learn Snowflake quickly.

  • Communication: Strong written and spoken English, with the ability to explain findings to executives and clients.

  • Attention to Detail: Able to verify data and ensure published numbers are accurate.

AI & Claude Experience

You will use Claude or another AI assistant regularly to improve your productivity.

You should be comfortable with:

  • Giving AI enough context, including schemas, business rules, and requirements.

  • Using AI to draft and improve SQL, Python, and Google Apps Script.

  • Using AI to understand unfamiliar data pipelines or processes.

  • Asking AI to review your analysis and identify possible errors.

  • Using AI to turn analysis into clear written explanations.

  • Creating reusable prompts, skills, and project instructions.

  • Checking and testing AI-generated work before using it.

  • Understanding when a task should be handled directly instead of using AI.

Important: You should never rely on AI output without checking the numbers, logic, and results yourself.

If you have experience with another AI assistant but have not used Claude, that is also acceptable if you are comfortable learning new tools.

How You Should Work

We are looking for someone who is:

  • Proactive — You investigate problems and identify opportunities without always waiting for instructions.

  • Accountable — You take ownership of a question or analysis from start to finish.

  • Business-minded — You want to understand how the business operates, not just the data.

  • A strong communicator — You can explain technical findings clearly to executives and clients.

  • A problem solver — You can work with incomplete information, messy data, and unclear requirements.

  • Collaborative — You review other people's work, share knowledge, and ask for help when needed.

  • Honest and detail-oriented — You verify your work and are comfortable saying when you do not know something.

Nice-to-Have Skills

These are not required but would be an advantage:

  • dbt — models, tests, and documentation

  • Airflow or Astronomer — data orchestration

  • Git and code review experience

  • BPO, contact center, or workforce management experience

  • Financial analysis, including:

    • Profit margins

    • Cost per unit

    • Revenue recognition

  • Experience creating a metric definition or data dictionary

  • Advanced statistical modeling or forecasting

Experience

  • 2–4 years of professional experience in data analytics or a related field

  • Hands-on experience working with SQL and business data

  • Experience building reports, dashboards, and data models

  • Experience using Python and/or automation tools for data-related tasks


Skills

Apply

See also

Data Analytics jobs by country — openings, pay and top skills →