Analytics Engineer — Power BI & Data Modeling

Prime Finance; Village of the Branch (NY); Hybrid; USD 64,000 - 96,000; Full time

Job summary

Prime Finance is seeking an Analytics Engineering Associate to design and maintain Power BI solutions, semantic models, and governed datasets. You will collaborate with stakeholders across Investments, Accounting, and Operations to deliver scalable analytics and data products on Microsoft Fabric.

You will contribute to data governance, reporting modernization, and ensure data accuracy, accessibility, and consistency across firm-wide reporting while growing your expertise in analytics engineering

Qualifications

• Bachelor's degree in a related field or equivalent work experience.
• 2–5 years of experience in analytics engineering, data analysis, or BI development.
• Proficiency in Power BI including Power Query and DAX.
• Experience with SQL and data modeling concepts (star/snowflake).
• Familiarity with Microsoft Fabric or similar analytics platform.
• Experience developing semantic models and calculated measures.
• Comfort using AI tools responsibly with strong validation.

Responsibilities

• Build and maintain semantic models and certified datasets on Microsoft Fabric.
• Develop Power BI reports and dashboards across Investments, Accounting, and Operations.
• Apply Power Query and DAX for transformations, measures, and row-level security.
• Support data transformation across medallion-layer patterns, including notebooks, stored procedures, scheduling, and version control.
• Assist in converting legacy Excel-based reporting to governed Power BI reports.

Skills

Power BI

Power Query

DAX

SQL

Data modeling

dbt

Microsoft Fabric

Semantic modeling

AI tooling validation

Education

Bachelor's degree

Tools

dbt

Microsoft Fabric

Job description

Prime Finance is seeking an Analytics Engineering Associate to design and maintain Power BI solutions, semantic models, and governed datasets. You will collaborate with stakeholders across Investments, Accounting, and Operations to deliver scalable analytics and data products on Microsoft Fabric.

You will contribute to data governance, reporting modernization, and ensure data accuracy, accessibility, and consistency across firm-wide reporting while growing your expertise in analytics engineering