Business Intelligence Analyst

The Phoenix Group

New York (NY)

On-site

USD 85,000 - 125,000

Full time

Just now
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The Phoenix Group is seeking a Business Intelligence Analyst to own the development and maintenance of data models, dashboards, and self-service analytics across financial and operational workflows in New York. You will translate business requirements into scalable data products using Snowflake and Sigma Computing, partnering with Data Engineers and Business Analysts.

Ideal candidates have 1–3 years of analytics or BI experience, strong SQL skills, and a solid understanding of dimensional

Qualifications

  • 1–3 years of analytics engineering, business intelligence, or data analytics experience.
  • Hands-on experience building data models, dashboards, or analytical apps with Sigma Computing or similar BI platform.
  • Experience with Snowflake or another cloud data warehouse.
  • Strong SQL skills (joins, aggregations, subqueries, CTEs, window functions).
  • Understanding of dimensional data modeling, including fact/dimension tables and star schemas.
  • Foundational knowledge of data architecture and data governance concepts.
  • Ability to translate business requirements into defined metrics, data models, and visualizations.
  • Excellent attention to detail and data accuracy.

Responsibilities

  • Design, develop, and maintain scalable data models, curated datasets, dashboards, reports, and analytical apps.
  • Build interactive Sigma Computing workbooks for KPI monitoring and self-service analysis.
  • Develop reusable data models in Snowflake and Sigma using dimensional modeling.
  • Define data grain, relationships, hierarchies, and reporting logic.
  • Translate requirements into logical/physical data models, datasets, and visualizations.
  • Write, optimize, and maintain SQL queries with complex constructs.
  • Collaborate with Data Engineers and Data Architects to understand source systems and pipelines.
  • Develop data-quality checks, validation processes, and reporting controls.
  • Support deployment, documentation, access management, and production enhancements.
  • Monitor performance and identify optimization opportunities for scalability and usability.

Skills

SQL proficiency
Analytical thinking
Cross-functional collaboration
Communication skills

Education

Bachelor's degree in Computer Science / Information Systems / Data Analytics / Finance

Tools

Sigma Computing
Snowflake

Job description

The Business Intelligence Analyst will own the development and maintenance of curated datasets, dimensional data models, dashboards, reports, and self-service analytics solutions across financial and operational workflows. This role partners with business stakeholders, Data Engineers, Data Architects, and Business Analysts to translate requirements into reliable, accurate, and scalable data products using Snowflake, Sigma Computing, and SQL.

Key Responsibilities
  • Design, develop, and maintain scalable data models, curated datasets, dashboards, reports, and analytical applications.
  • Build interactive Sigma Computing workbooks that support KPI monitoring, variance analysis, ad hoc reporting, and self-service data exploration.
  • Develop reusable reporting components and analytical data models in Snowflake and Sigma using dimensional modeling practices.
  • Design and maintain fact tables, dimension tables, views, semantic models, and curated analytical data layers.
  • Define data grain, table relationships, hierarchies, calculated fields, standardized metrics, and reporting logic.
  • Translate business requirements into logical and physical data models, datasets, visualizations, dashboards, and analytical solutions.
  • Develop and maintain Sigma formulas, calculations, parameters, controls, and data transformations.
  • Write, optimize, and maintain SQL queries using joins, aggregations, subqueries, common table expressions (CTEs), and window functions.
  • Partner with Data Engineering and Data Architecture teams to understand source systems, data pipelines, transformation logic, warehouse structures, and downstream dependencies.
  • Contribute to data architecture patterns connecting source applications, Snowflake, and business intelligence platforms.
  • Perform data validation, reconciliation, variance analysis, and troubleshooting across source systems, warehouse models, and reporting applications.
  • Develop data-quality checks, reporting controls, testing procedures, and validation processes to improve data accuracy and reliability.
  • Support analytics solution deployment, documentation, access management, maintenance, and ongoing production enhancements.
  • Monitor data model, SQL query, dashboard, and workbook performance; identify opportunities to improve scalability, efficiency, and usability.
  • Support data governance initiatives involving access controls, certified datasets, documentation, data lineage, and standardized metric definitions.
  • Participate in technical reviews, solution design sessions, architecture discussions, and cross-functional planning.
  • Establish and maintain development standards for naming conventions, reusable logic, documentation, testing, and quality assurance.
  • Support reporting and analytics related to financing activity, debt structures, credit facilities, capital allocation, liquidity, portfolio exposure, financial performance, and management reporting.
Core Qualifications & Requirements
  • 1–3 years of professional experience in analytics engineering, business intelligence, data analytics, or a related discipline.
  • Hands-on experience developing data models, dashboards, reports, or analytical applications using Sigma Computing or a comparable modern BI platform.
  • Experience with Snowflake or another cloud-based data warehouse.
  • Strong SQL skills, including joins, aggregations, subqueries, common table expressions (CTEs), and window functions.
  • Understanding of dimensional data modeling, including fact tables, dimension tables, data grain, star schemas, relationships, and reporting layers.
  • Foundational knowledge of data architecture, including source systems, transformation layers, curated datasets, semantic models, and downstream reporting.
  • Ability to convert business requirements into clearly defined metrics, data models, visualizations, dashboards, and analytical products.
  • Experience partnering with Data Engineering or Data Architecture teams to understand source data, resolve data-quality issues, and support end-to-end data solutions.
  • Strong analytical, critical-thinking, troubleshooting, and problem-solving skills, particularly when investigating data discrepancies and reporting inconsistencies.
  • Exceptional attention to detail and commitment to data accuracy, consistency, and reliability.
  • Strong written and verbal communication skills, with the ability to explain technical concepts to technical and non-technical audiences.
  • Ability to manage competing priorities and collaborate effectively in a cross-functional environment.
  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or a related discipline, or equivalent practical experience.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst – Enterprise Data & Analytics
Senior Data Analyst – Enterprise Data & Analytics

ASB Resources • New York (NY)

On-site
USD 110,000 - 150,000
Data Analytics & BI Analyst
Data Analytics & BI Analyst

Signature IT World • Hanover Township (NJ)

On-site
USD 80,000 - 120,000
Senior Data Analyst-Snowflake (Direct Hire/ No Sponsorship)-( Local Chicago candidates only)
Senior Data Analyst-Snowflake (Direct Hire/ No Sponsorship)-( Local Chicago candidates only)

e.biT Consulting • Schaumburg (IL)

On-site
USD 110,000 - 140,000
Power BI / Business Intelligence Analyst
Power BI / Business Intelligence Analyst

Qtsolv • Snowflake (AZ)

On-site
USD 95,000 - 135,000
Data Analytics Engineer
Data Analytics Engineer

Compunnel Inc. • Spring (TX)

On-site
USD 110,000 - 140,000
Data Analyst
Data Analyst

Optimize Search Group • Irving (TX)

On-site
USD 85,000 - 110,000
Senior Business Intelligence Analyst, Database Engineer
Senior Business Intelligence Analyst, Database Engineer

Coral Connect LLC • Utah

On-site
USD 100,000 - 150,000
Senior Business Intelligence Analyst, Database Engineer
Senior Business Intelligence Analyst, Database Engineer

Coral Connect LLC • Bountiful (UT)

On-site
USD 90,000 - 135,000
Business Intelligence Developer
Business Intelligence Developer

Communication Service for the Deaf (CSD) • Austin (TX)

On-site
USD 90,000 - 130,000
Data Engineer
Data Engineer

Venteon • United States

On-site
USD 100,000 - 130,000