Analytics Engineer: BI Dashboards & Data Modeling

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

Job summary

The Phoenix Group in New York is seeking a data analytics engineer to design and optimize data models, datasets, and BI reports supporting monthly and quarterly fund performance and operational reporting.

You will transform raw data into structured datasets, build star schemas, develop SQL queries, and create dashboards with Power BI, Sigma Computing, and Snowflake. Collaboration with Data Engineers and stakeholders is essential to deliver accurate analytics.

Qualifications

• 1 to 3 years of data analytics, data engineering, or reporting roles within finance.
• Strong proficiency in SQL with joins, aggregations, subqueries, window functions, and CTEs.
• Solid understanding of dimensional data modeling concepts such as fact/dimension tables and star schemas.
• 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 with cloud data platforms such as Snowflake and AWS.
• Ability to collaborate with Data Engineers and translate business requirements to data models and KPIs.
• Bachelor’s degree or equivalent practical experience.

Responsibilities

• Design, develop, and optimize data models, datasets, dashboards, and reports for fund performance and operational reporting cycles.
• Transform raw source data into high-quality, reusable datasets for analytics and BI purposes.
• Utilize dimensional modeling to create and maintain fact and dimension tables, star schemas, and business metrics.
• Write, test, and maintain complex SQL queries and data transformations across multiple systems.
• Develop analytics solutions using BI platforms such as Power BI, Sigma Computing, and Snowflake, including dashboard creation.
• Collaborate with Data Engineers to understand source architecture and support end-to-end data workflows.
• Translate business requirements into data models, KPIs, and report deliverables with stakeholders.
• Validate data accuracy, reconcile discrepancies, and troubleshoot data issues across systems.
• Implement data quality tests and validation procedures to ensure analytics integrity.
• Document data lineage, logic, metrics definitions, and reporting processes.
• Support deployment, monitoring, and maintenance of analytics solutions.

Skills

SQL

Dimensional modeling

Data visualization

Data analytics

Data quality

Communication

Stakeholder collaboration

Problem solving

Education

Bachelor's degree in CS/Analytics/Finance

Tools

Power BI

Sigma Computing

Snowflake

dbt

Airflow

Job description

The Phoenix Group in New York is seeking a data analytics engineer to design and optimize data models, datasets, and BI reports supporting monthly and quarterly fund performance and operational reporting.

You will transform raw data into structured datasets, build star schemas, develop SQL queries, and create dashboards with Power BI, Sigma Computing, and Snowflake. Collaboration with Data Engineers and stakeholders is essential to deliver accurate analytics.