Fund Services.Lead Data Analyst, Chief Administrative Office

Fa Euxc Saasfaprod1; Makati; On-site; PHP 1,200,000 - 2,000,000; Full time

Job summary

Fa Euxc Saasfaprod1 is seeking a Lead Data Analyst in CAO to design, build, and maintain enterprise-grade Power BI dashboards. You will translate business questions into robust analytical models and develop advanced DAX measures for complex insights.

You will collaborate with data engineering to connect BI solutions to Lakehouse layers, optimize performance, and drive data-driven decisions for executives and stakeholders.

Qualifications

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, or related discipline.
• 4+ years of hands-on experience in BI, analytics, or data visualization roles.
• Strong expertise in Power BI Desktop and Power BI Service, including Power Query (M).
• Advanced proficiency in DAX with complex analytical logic.
• Strong SQL skills with large, complex datasets.
• Working knowledge of Lakehouse or warehouse-based architectures.
• Solid understanding of data modeling, ETL/ELT concepts, and analytics best practices.

Responsibilities

• Lead the end-to-end design, development, and maintenance of enterprise-grade Power BI dashboards from concept through production deployment.
• Translate complex business questions into robust analytical models for self-service BI.
• Develop advanced DAX measures and calculated tables for YTD, comparisons, and cohort insights.
• Design and maintain optimized data models using dimensional modeling (star schemas).
• Optimize Power BI performance through query folding, model design, and visual optimization.
• Collaborate with data engineering to connect BI solutions to Lakehouse layers for reporting datasets.
• Support data transformation and validation using SQL, Python, or notebook-based workflows.

Skills

Power BI

DAX

SQL

Data Visualization

Analytics

Stakeholder Engagement

Education

Bachelor’s degree or higher

Tools

Power BI Desktop

Power BI Service

Databricks

Lakehouse

Job description

As a Lead Data Analyst in CAO, you will act as a senior Power BI and analytics specialist, bridging complex enterprise data platforms with executive-level insights. The role focuses on delivering scalable, high-performance Power BI solutions, leveraging modern data platforms (including Databricks-based Lakehouse architectures) to support strategic and operational decision-making.
You will own the full analytics solution lifecycle—from understanding business requirements and querying curated data layers, through to delivering intuitive, performant dashboards adopted by senior stakeholders.

• Lead the end-to-end design, development, and maintenance of enterprise-grade Power BI dashboards, from concept through production deployment.

• Translate complex business questions into robust analytical models, ensuring clarity, consistency, and scalability for self-service BI consumption.

• Develop advanced DAX measures and calculated tables to support complex analytical requirements such as year-to-date analysis, period-over-period comparisons, and cohort-based insights.

• Design and maintain optimized data models using best-practice dimensional modeling techniques (e.g., star schemas) to ensure performance and usability.

• Optimize Power BI performance through query folding, efficient model design, cardinality management, and visual optimization.

• Administer Power BI Service environments, including workspace management, row-level security (RLS), dataset refresh scheduling, and gateway configurations.

• Collaborate with data engineering teams to connect Power BI solutions to curated Lakehouse "Gold" layers, ensuring reliable and performant reporting datasets.

• Support data transformation and validation activities by working with SQL, Python, or notebook-based workflows to ensure data accuracy and completeness.

• Partner with IT and business stakeholders,acting as a trusted analytics partner to gather requirements, communicate progress, and deliver data-driven solutions aligned to business objectives - including executive dashboards, operational reporting, and analytics enablement..

• Proactively identify data quality, pipeline, or availability issues, working with upstream teams to resolve root causes rather than treating symptoms.

• Promote best practices in data visualization and storytelling, ensuring dashboards are intuitive, accessible, and aligned with executive decision-making needs.

• Monitor industry trends and emerging analytics capabilities, recommending enhancements to tools, standards, and ways of working.

• Demonstrate the ability to work on own initiative,proactively identifying opportunities to improve reporting solutions, analytical processes, and data quality without waiting for direction, taking ownership of tasks from identification through to resolution

• Bachelor’s degree or higher in Data Analytics, Computer Science, Information Systems, or related discipline.

• 4+ years of hands-on experience in business intelligence, analytics, or data visualization roles.

• Strong expertise in Power BI Desktop and Power BI Service, including Power Query (M) and semantic model design.

• Advanced proficiency in DAX, with demonstrated experience building complex analytical logic.

• Strong SQL skills, with the ability to work confidently against large, complex datasets.

• Working knowledge of modern data platforms, including Lakehouse or warehouse-based architectures.

• Solid understanding of data modeling, ETL/ELT concepts, and analytics best practices.