Data Analyst | On-site
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
Sign in to read and join the discussion.