Power BI Consultant – New York
Who we are:
Pharo Management is a leading global macro hedge fund with a focus on emerging markets. Founded in 2000, the firm has offices in London, New York and Hong Kong and currently manages $7 billion in assets across four funds. Pharo trades foreign exchange, sovereign and corporate credit, local market interest rates, commodities, and their derivatives. We trade in over 70 countries across Asia, Central and Eastern Europe, the Middle East and Africa, Latin America as well as developed markets. Our investment approach combines macroeconomic fundamental research and quantitative analysis.
Pharo employs a diverse, dynamic team of 130 professionals representing over 20 nationalities and 30 languages. We have a strong corporate culture anchored in core values such as collaborative spirit, creativity, and respect. We are passionate about what we do and are committed to attracting the best and brightest talent.
This is a great opportunity to join a market leader, and contribute to our continued success.
Job description:
We are seeking a senior Power BI consultant to work closely with our Portfolio Analytics team to review and enhance our existing reporting architecture and deliver high-performance, real-time dashboards. This role requires deep expertise in Power BI, advanced data modelling, and AI-driven analytics. The consultant will ensure our visualization layer is scalable, performant, and capable of integrating complex market and portfolio data for actionable insight.
Responsibilities:
- Architecture Review & Optimization: Assess and refine current Power BI models, data flows, and architecture for speed, scalability, and maintainability.
- Help Improve branding and delivery of current BI Reporting.
- Design and develop high-impact visualizations for portfolio performance, P&L, risk, and market analytics.
- Real-Time Data Integration: Recommend and implement architectures for real-time or low-latency reporting.
- AI-Enhanced Insights: Integrate predictive models, anomaly detection, and natural. language Q&A to deliver intelligent decision support for PMs and traders.
- Collaboration: Work closely with Analytics team, Portfolio managers and data engineers to align dashboards with trading and investment workflows.
- Best Practices & Training: Provide guidance to internal teams to maintain performance and adaptability.
Skills & Experience:
- Strong knowledge of BI architectures, cloud platforms (Azure preferred), and real-time data integration.
- Proven ability to design intuitive, user-friendly dashboards
- Experience with corporate branding (themes, templates, consistent look/feel).
- Skilled in advanced visualization techniques (drill-through, bookmarks, tooltips, KPI cards, small multiples).
- Proven expertise in Power BI: Advanced DAX, Power Query (M), and complex data modelling.
- Strong hands-on experience with SQL Server, Snowflake, and Azure cloud data warehouses.
- Experience embedding AI/ML models into BI environments for predictive analytics and signal detection.
- 5+ years in BI/Analytics roles, preferably in hedge funds, asset management, or trading environments.
- Exposure to other BI platforms such as Sigma are plus.
Similar Jobs
What We Do
Pharo is a global investment firm focused on macroeconomic trends with an expertise in developing countries. Founded in 2000 by Guillaume Fonkenell, Pharo manages approximately $10 billion across four funds from our offices in London, New York and Hong Kong. We seek to deliver attractive returns to our investors across a wide range of investment strategies.
Our team is led by investment professionals who share a deep understanding of both developed and emerging markets which we have gained across multiple market cycles. From the Tequila crisis of 1995 to the global financial crisis of 2008 and the emerging market crisis of 2013-15, our investment team has been recognised for its consistent ability to successfully navigate even the most challenging market conditions.
