Fund Services.Lead Data Analyst, Chief Administrative Office

CITCO INTERNATIONAL SUPPORT SERVICES LIMITED-PHILIPPINE ROHQ; Philippines; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

CITCO INTERNATIONAL SUPPORT SERVICES LIMITED-PHILIPPINE ROHQ is seeking a Lead Data Analyst to architect enterprise Power BI dashboards and analytics. You will bridge data platforms with executive insights, delivering scalable solutions and self-service reporting for senior stakeholders.

Responsibilities include end-to-end dashboard design, data modeling, performance optimization, and collaboration with data engineering to connect Lakehouse layers.

Qualifications

• Bachelor's degree or higher in data analytics, CS, information systems, or related field.
• 4+ years of hands-on BI, analytics, or data visualization experience.
• Strong expertise in Power BI Desktop and Power BI Service, including Power Query (M).
• Advanced proficiency in DAX with complex analytical logic.
• Solid SQL skills for large, complex datasets.
• Working knowledge of Lakehouse or warehouse architectures.
• Strong 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 to production.
• Translate complex 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 star schemas for performance.
• Optimize Power BI performance through query folding, model design, and visual optimization.
• Administer Power BI Service environments, including workspace, RLS, and dataset refresh.
• Collaborate with data engineering to link BI solutions to Lakehouse layers.
• Support data transformation with SQL, Python, or notebooks to ensure accuracy.
• Partner with IT and stakeholders to deliver data-driven insights for exec dashboards and operational reports.
• Identify data quality, pipeline, or availability issues and resolve root causes.
• Promote best practices in data visualization and storytelling for executive decisions.
• Monitor industry trends and evolving analytics capabilities for tooling improvements.
• Take ownership of tasks, proposing improvements without waiting for direction.

Skills

Power BI Desktop

Power BI Service

DAX

SQL

Lakehouse platforms

Dimensional modeling

Performance optimization

Data visualization

Education

Bachelor's degree or higher in data analytics, CS, or related field

Tools

Power Query (M)

Databricks Lakehouse

Python

Job description

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.

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, 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

Qualifications

• 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.