Fund Services, Lead Data Analyst, Chief Administrative Office

As a Lead Data Analyst in CAO you will act as a senior Power BI and analytics specialist bridging complex enterprise data platforms with executivelevel insights. The role focuses on delivering scalable highperformance Power BI solutions leveraging modern data platforms (including Databricksbased Lakehouse architectures) to support strategic and operational decisionmaking.
You will own the full analytics solution lifecyclefrom understanding business requirements and querying curated data layers through to delivering intuitive performant dashboards adopted by senior stakeholders.

• Lead the endtoend design development and maintenance of enterprisegrade Power BI dashboards from concept through production deployment.

• Translate complex business questions into robust analytical models ensuring clarity consistency and scalability for selfservice BI consumption.

• Develop advanced DAX measures and calculated tables to support complex analytical requirements such as yeartodate analysis periodoverperiod comparisons and cohortbased insights.

• Design and maintain optimized data models using bestpractice 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 rowlevel 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 notebookbased workflows to ensure data accuracy and completeness.

• Partner with IT and business stakeholdersacting as a trusted analytics partner to gather requirements communicate progress and deliver datadriven 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 decisionmaking needs.

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

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

• Bachelors degree or higher in Data Analytics Computer Science Information Systems or related discipline.

• 4 years of handson 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 warehousebased architectures.

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