Junior Analytics Engineer

The Phoenix Group; New York (NY); On-site; USD 100,000 - 120,000; Full time

Job summary

The Phoenix Group Advisors seeks aJunior Analytics Engineer to support private real estate fund operations and deliver scalable analytics in a fast-paced environment. You will build data models, pipelines, and BI reports while collaborating with finance, data engineering, and analytics teams.

You will work on dimensional modeling, SQL development, and BI dashboards (Power BI, Sigma Computing, Snowflake) to enable accurate fund performance insights and operational efficiency for cross-functional

Qualifications

• 1–3 years in data analytics, data engineering, or reporting in finance or asset management.
• Strong SQL skills: joins, aggregations, window functions, and CTEs.
• Experience with Power BI, Sigma Computing, Snowflake, or similar BI tools; dbt knowledge.
• Bachelor’s degree in a related field or equivalent practical experience.

Responsibilities

• Design, develop, and optimize data models, datasets, dashboards, and reports supporting fund performance and reporting cycles.
• Transform raw source data into high-quality, reusable, and structured datasets for analytics and business intelligence purposes.
• Utilize dimensional modeling principles to create and maintain fact and dimension tables, star schemas, and business metrics aligned with fund valuation and reporting needs.
• Write, test, and maintain complex SQL queries, stored procedures, and data transformations across multiple systems.
• Develop analytics solutions using BI platforms such as Power BI, Sigma Computing, and Snowflake, including dashboard and report creation.
• Collaborate with Data Engineers to understand source system architecture, establish reliable data pipelines, resolve data-quality issues, and support end-to-end data workflows.

Skills

SQL proficiency

Dimensional modeling

BI development

Collaborative teamwork

Communication skills

Education

Bachelor's degree in a related field

Tools

Power BI

Sigma Computing

Snowflake

AWS

dbt

Job description

Seeking a highly motivated data professional to join a leading investment management firm in a dynamic Junior Analytics Engineer role, focused on supporting private real estate fund operations and delivering scalable analytics solutions within a fast-paced environment. This position offers an excellent opportunity to develop expertise in data modeling, business intelligence, and fund management processes while collaborating with cross-functional teams across finance, data engineering, and analytics.

Role Overview

This Junior Analytics Engineer will be integral to the Data Analytics and Insights team, responsible for developing and maintaining robust data models and reporting solutions that inform decision-making across private real estate investment funds. The role emphasizes building data pipelines, translating complex business requirements into technical solutions, and ensuring accurate, timely insights that enhance operational efficiency.

Key Responsibilities

• Design, develop, and optimize data models, datasets, dashboards, and reports supporting monthly and quarterly fund performance and operational reporting cycles.
• Transform raw source data into high-quality, reusable, and structured datasets for analytics and business intelligence purposes.
• Utilize dimensional modeling principles to create and maintain fact and dimension tables, star schemas, and business metrics aligned with fund valuation and reporting needs.
• Write, test, and maintain complex SQL queries, stored procedures, and data transformations involving joins, aggregations, window functions, and subqueries across multiple systems.
• Develop analytics solutions using BI platforms such as Power BI, Sigma Computing, and Snowflake, including dashboard and report creation.
• Collaborate with Data Engineers to understand source system architecture, establish reliable data pipelines, resolve data-quality issues, and support end-to-end data workflows.
• Partner with Business Analysts and stakeholders, including fund managers and portfolio leads, to translate business requirements into effective data models, KPIs, and report deliverables.
• Validate data accuracy, reconcile discrepancies, and troubleshoot data issues across multiple systems and models.
• Implement and execute data quality tests, unit tests, and validation procedures to ensure the integrity of analytics outputs.
• Document data lineage, business logic, metrics definitions, and reporting processes thoroughly.
• Support deployment, monitoring, and maintenance of analytics solutions, ensuring continued performance and accuracy.
• Participate in code reviews, contribute to best practices, and help develop standards for analytics engineering within the organization.

Core Qualifications & Requirements

• 1 to 3 years of relevant experience in data analytics, data engineering, or reporting roles within finance, asset management, or private equity.
• Strong proficiency in SQL, including joins, aggregations, subqueries, window functions, and CTEs.
• Solid understanding of dimensional data modeling concepts such as fact/dimension tables, star schemas, and data relationships.
• Hands-on experience developing dashboards and reports using Power BI, Sigma Computing, Snowflake, or similar BI tools.
• Familiarity with data transformation frameworks like dbt or equivalent.
• Knowledge of source system integration, data pipeline development, and data quality assurance practices.
• Experience working with cloud data platforms such as Snowflake and AWS.
• Ability to collaborate effectively with Data Engineers on data pipelines and source system issues.
• Strong attention to detail, data validation, and troubleshooting skills.
• Excellent written and verbal communication, capable of translating technical concepts for stakeholders.
• Bachelor’s degree in Computer Science, Data Analytics, Finance, or related field, or equivalent practical experience.

Nice-to-Have Qualifications

• Exposure to Sigma Computing, Power BI, and Snowflake.
• Experience with data orchestration tools like Airflow or DataHub.
• Familiarity with data quality automation and lineage documentation.
• Knowledge of finance, private equity, or real estate operational processes.
• Understanding of software development best practices such as modular design, version control, and deployment workflows.
• Comfortable working within Agile project methodologies.

Core Technical Skills

• SQL (joins, filters, aggregations, CTEs, window functions)
• Business Intelligence tools (Power BI, Sigma Computing)
• Cloud data platforms (Snowflake, AWS)
• Data testing and validation practices
• Version control (Git)

Compensation and Benefits

Salary range: $100,000 – $120,000 base plus bonus.

On-site work: 5 days per week in New York City.

Additional benefits available; details provided upon application.

This role offers an accelerated pathway into fund operations analytics, empowering candidates to build critical skills in data modeling, BI development, and stakeholder collaboration within a growing investment management environment.

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.