Business Intelligence Analyst

The Phoenix Group®; New York (NY); On-site; USD 85,000 - 140,000; Full time

Job summary

The Phoenix Group Advisors in New York, NY is seeking a Business Intelligence / Data Analyst to join its data and analytics team. The role focuses on building dashboards, analyzing financial and investment data, and delivering reporting and insights for business stakeholders.

You will work with Power BI and SQL to translate business requirements into actionable analytics, validating data and supporting monthly and quarterly reporting cycles.

Qualifications

• 1–4 years of professional data analytics, BI, or reporting experience.
• Experience within investment management, asset management, private equity, financial services, banking, or commercial real estate.
• Strong hands-on Power BI experience.
• Strong SQL skills.
• Experience creating dashboards, reports, visualizations, and KPIs for business users.
• Bachelor's degree in a relevant field or equivalent professional experience.

Responsibilities

• Build, maintain, and enhance Power BI dashboards and reports used by investment and business teams.
• Work with financial, fund, portfolio, investment, and operational data to support recurring reporting and analysis.
• Write and maintain SQL queries to extract, transform, validate, and analyze data.
• Translate business requirements into dashboards, reports, KPIs, and other analytics solutions.
• Work directly with business stakeholders to understand reporting needs and provide actionable insights.
• Validate and reconcile data to ensure reporting is accurate and reliable.
• Analyze information across multiple data sources and troubleshoot discrepancies.
• Partner with data and technology teams to understand data sources and improve reporting processes.
• Help automate and improve existing reporting processes.
• Support monthly and quarterly reporting cycles.
• Document reporting logic, metrics, and data definitions.

Skills

Power BI

SQL

Dashboards

Financial reporting

Data analytics

Education

Bachelor's degree in a relevant field

Tools

Power BI

SQL

Snowflake

Sigma Computing

dbt

Job description

Role Overview

We are seeking a Business Intelligence / Data Analyst to join the data and analytics team of a leading investment management firm.
The ideal candidate has 1–4 years of experience within investment management, asset management, private equity, financial services, or commercial real estate and is highly proficient with Power BI and SQL.
This role is focused on building dashboards, analyzing financial and investment data, and partnering with business stakeholders to deliver reporting and insights. We are looking for someone who understands how to work with data in a financial environment and can turn complex datasets into clear, useful reporting.

Key Responsibilities

• Build, maintain, and enhance Power BI dashboards and reports used by investment and business teams.
• Work with financial, fund, portfolio, investment, and operational data to support recurring reporting and analysis.
• Write and maintain SQL queries to extract, transform, validate, and analyze data.
• Translate business requirements into dashboards, reports, KPIs, and other analytics solutions.
• Work directly with business stakeholders to understand reporting needs and provide actionable insights.
• Validate and reconcile data to ensure reporting is accurate and reliable.
• Analyze information across multiple data sources and troubleshoot discrepancies.
• Partner with data and technology teams to understand data sources and improve reporting processes.
• Help automate and improve existing reporting processes.
• Support monthly and quarterly reporting cycles.
• Document reporting logic, metrics, and data definitions.

Core Qualifications

• 1–4 years of professional data analytics, BI, or reporting experience.
• Experience within investment management, asset management, private equity, financial services, banking, or commercial real estate.
• Strong hands-on Power BI experience — this is a key requirement.
• Strong SQL skills.
• Experience creating dashboards, reports, visualizations, and KPIs for business users.
• Comfortable working with financial, investment, portfolio, fund, transaction, or similar business data.
• Strong data validation and analytical skills.
• Ability to communicate with both technical teams and business stakeholders.
• Bachelor's degree in a relevant field or equivalent professional experience.

Huge Plus

• Experience with Snowflake.
• Exposure to Sigma Computing.
• Familiarity with dbt or modern data transformation tools.
• Experience with investment/fund reporting or portfolio analytics.
• Exposure to private equity or commercial real estate data.
• Basic understanding of data modeling and data pipelines.

Must Have

Power BI

• SQL
• Financial/Investment Industry Experience

The Phoenix Group Advisors is an equal opportunity employer. We are committed to creating a diverse and inclusive workplace and prohibit discrimination and harassment of any kind based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. We strive to attract talented individuals from all backgrounds and provide equal employment opportunities to all employees and applicants for employment.