Job Title: Senior BI Engineer

Location: NYC, NY (Hybrid)

Contract

Job Description:

Interview: Video and final is in person

Experience in Capital Markets is a major plus

This position is for a Business Intelligence / Reporting Engineer with a robust background in SQL and data warehousing for enterprise-level systems. The ideal candidate must possess strong Power BI skills, particularly in developing dashboards and canned reports. The role involves designing and developing reports, dashboards, and ad-hoc queries. The candidate should be comfortable collaborating with business users and exhibit business analyst expertise.

Responsibilities:

Design and develop reports, dashboards, and ad-hoc queries.

Collaborate with business users to understand and meet their requirements.

Utilize data modeling techniques using Power Query/Power Pivot.

Develop and optimize DAX queries.

Use Power BI Report Builder and/or create Paginated Reports.

Manage and query SQL Server or any other relational databases.

Requirements:

Minimum of 7+ years of combined experience in data warehousing, business intelligence, analytics, and reporting systems.

At least 3+ years of experience in relational and multi-dimensional (OLAP) data modeling.

Proficiency in SQL, including relational and dimensional database structures and query optimization.

Strong knowledge of Fixed Income, Equity, and Derivative businesses.

Ability to analyze user requirements, make recommendations, and implement solutions.

Self-driven with the ability to troubleshoot and provide quick resolutions to issues.

Experience with full project management and development life cycle.

Strong oral and written communication skills.

Strong presentation and interpersonal skills.

Ability to prioritize and manage tasks in a high-pressure environment.

Preferred, but not required:

Data modeling using Power Query/Power Pivot.

Proficiency in DAX.

Experience with Power BI Report Builder and/or Paginated Reports.

Strong SQL skills, particularly with SQL Server or similar relational databases.

Working knowledge of Data Flows.

Experience with PBRS (Power BI Report Server).

Familiarity with Power On.

Experience with Snowflake data warehouse.