Fund Services.Lead Data Analyst, Chief Administrative Office

Citco; Philippines; Presencial; PHP 1 200 000 - 1 800 000; Tempo integral

Resumo da oferta

Citco in the Philippines seeks a Lead Data Analyst to bridge enterprise data platforms with executive insight. You will own scalable Power BI solutions and Databricks-based Lakehouse architectures to support strategic decisions.

You will lead the analytics lifecycle from requirements to dashboard delivery, ensuring high performance, self-service adoption, and data quality across enterprise datasets for senior stakeholders.

Qualificações

• Bachelor's degree or higher in a related field.
• 4+ years in BI, analytics or data visualization.
• Expertise in Power BI Desktop and Service.
• Advanced proficiency in DAX.
• Strong SQL skills.
• Knowledge of Lakehouse or warehouse architectures.
• Understanding of data modeling and ETL/ELT concepts.

Responsabilidades

• Lead the end-to-end design, development, and maintenance of enterprise-grade Power BI dashboards.
• Translate complex business questions into robust analytical models for self-service BI.
• Develop advanced DAX measures and calculated tables for cohort insights and YoY analyses.
• Design and maintain star-schema data models for performance and usability.
• Optimize Power BI performance, including query folding and visual optimization.
• Administer Power BI Service environments, including workspace management and RLS.
• Collaborate with data engineering to connect dashboards to Lakehouse layers.
• Support data transformation using SQL, Python, or notebook workflows to ensure data accuracy.
• Partner with IT and stakeholders to deliver data-driven solutions aligned with business goals.
• Identify data quality or pipeline issues and drive root-cause resolution.

Conhecimentos

Power BI

DAX

SQL

Data Modeling

ETL/ELT

Lakehouse

Stakeholder Collaboration

Formação académica

Bachelor's degree or higher in a related field

Ferramentas

Power Query (M)

Databricks

Python

Descrição da oferta de emprego

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.