Data Analyst (SQL & Python)

Ascendion; Taguig; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

Ascendion is seeking a Data Analyst to support cross-functional teams in transforming data into actionable business intelligence.

You will translate business questions into analytical frameworks, write complex SQL, build dashboards, and deliver executive-ready insights. You will collaborate with non-technical stakeholders and Data Engineering to define metrics and ensure data quality.

The role emphasizes data exploration, KPI definition, and clear storytelling to drive operational decisions.

Qualifications

• Strong SQL skills and data modeling awareness.
• Ability to partner with non-technical stakeholders and Data Engineering.
• Experience building interactive dashboards and BI reports.

Responsibilities

• Write and optimize complex SQL queries against data warehouses to extract datasets.
• Design, build, and maintain interactive enterprise dashboards.
• Conduct exploratory data analysis to uncover trends and growth opportunities.
• Translate business requirements into technical analytical specifications and document dashboards.

Skills

SQL

Data modeling

Dashboards

Job description

Role Summary

The Data Analyst will support cross-functional teams in transforming data into actionable business intelligence. The candidate will be responsible for translating business questions into analytical frameworks, writing complex SQL queries against enterprise data warehouses, building interactive dashboards, and delivering executive-ready insights.

The ideal candidate must demonstrate strong SQL skills, data modeling awareness, business acumen, and the ability to partner effectively with both non-technical stakeholders and Data Engineering teams.

Key Responsibilities

1. Data Exploration, Querying & Metric Definition

Write and optimize complex SQL queries against existing data warehouses/marts to extract datasets for business analysis.

Define, document, and standardize business KPIs and metric logic in collaboration with business stakeholders.

Profile and validate analytical datasets to ensure metric accuracy and consistency across reports.

Partner with Data Engineering by defining business logic and requirements for new data marts, schema changes, or pipeline additions.

2. Visualization & Dashboard Development

Design, build, and maintain interactive enterprise dashboards.

Translate key business metrics (KPIs) into intuitive visual reports that drive operational decisions.

Implement performance optimizations, user access controls, and data refresh schedules for BI dashboards.

3. Business Analysis & Insights

Conduct exploratory data analysis (EDA) to uncover trends, anomalies, patterns, and growth opportunities.

Perform root-cause analysis on operational metrics and clearly communicate underlying drivers to business leaders.

Conduct ad-hoc quantitative analysis to answer time-sensitive strategic questions.

4. Stakeholder Collaboration & Documentation

Gather business requirements and translate ambiguous requests into technical analytical specifications.

Maintain metric catalogs and dashboard user documentation.

Present key findings and actionable recommendations to non-technical business partners using clear narrative storytelling.