Senior BI Engineer

BlueSnap, Inc; New York (NY); Hybrid; USD 100,000 - 140,000; Full time

Job summary

A leading company in the financial sector is seeking a Senior BI Engineer to enhance their data reporting capabilities. This role involves designing dashboards and reports using Power BI, collaborating with business users, and requires extensive experience in SQL and data warehousing. The ideal candidate will thrive in a fast-paced environment and possess strong analytical skills.

Qualifications

• 7+ years in data warehousing and business intelligence.
• 3+ years in relational and multi-dimensional data modeling.
• Strong communication and interpersonal skills.

Responsibilities

• Design and develop reports, dashboards, and ad-hoc queries.
• Collaborate with business users to understand their requirements.
• Utilize data modeling techniques using Power Query/Power Pivot.

Skills

SQL

Data Warehousing

Power BI

DAX

Business Analysis

Communication

Tools

Power BI Report Builder

SQL Server

Snowflake

Job description

Sansar Tec is seeking a Senior BI Engineer to join our team in New York, NY (Onsite day 1, hybrid 3 days from office).

Job Description:

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

Responsibilities:

1. Design and develop reports, dashboards, and ad-hoc queries.
2. Collaborate with business users to understand and meet their requirements.
3. Utilize data modeling techniques using Power Query/Power Pivot.
4. Develop and optimize DAX queries.
5. Use Power BI Report Builder and/or create Paginated Reports.
6. Manage and query SQL Server or other relational databases.

Requirements:

1. Minimum of 7+ years of experience in data warehousing, business intelligence, analytics, and reporting systems.
2. At least 3+ years of experience in relational and multi-dimensional (OLAP) data modeling.
3. Proficiency in SQL, including relational and dimensional database structures and query optimization.
4. Strong knowledge of Fixed Income, Equity, and Derivative businesses.
5. Ability to analyze user requirements, make recommendations, and implement solutions.
6. Self-driven with troubleshooting skills and quick resolution capabilities.
7. Experience with full project management and development lifecycle.
8. Strong communication, presentation, and interpersonal skills.
9. Ability to prioritize and manage tasks in high-pressure environments.

Preferred, but not required:

1. Proficiency in DAX.
2. Experience with Power BI Report Builder and Paginated Reports.
3. Strong SQL skills, especially with SQL Server or similar relational databases.
4. Knowledge of Data Flows.
5. Experience with PBRS (Power BI Report Server).
6. Familiarity with Power On.
7. Experience with Snowflake data warehouse.