Sr Power BI Developer and Lead for New York City

Centillion Infotech LLC; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Centillion Infotech LLC is seeking a Sr. Power BI Developer/Lead for New York City, NY. The role focuses on designing and delivering enterprise-scale Power BI reports and dashboards, with strong SQL and data warehousing background. Banking domain experience is highly valued for this client.

The candidate will collaborate with business users, build robust data models, and optimize DAX queries while leveraging Power BI Report Builder and Paginated Reports for strategic insights.

Qualifications

• 7+ years in data warehousing, BI, analytics and reporting systems.
• 3+ years in relational and OLAP data modeling.
• SQL proficiency including query optimization.
• Strong knowledge of Fixed Income, Equity, and Derivative businesses.
• Analytical and able to translate user requirements into solutions.

Responsibilities

• Design and develop reports, dashboards, and ad-hoc queries.
• Collaborate with business users to gather requirements.
• Utilize data modeling using Power Query/Power Pivot.
• Develop and optimize DAX queries.
• Use Power BI Report Builder or Paginated Reports.
• Query and manage SQL Server or equivalent databases.

Skills

Data modeling using Power Query/Power 

DAX proficiency

Power BI Report Builder / Paginated

SQL skills (SQL Server)

Banking domain experience

Tools

Snowflake

Job description

Sr. Power BI Developer / Lead for New York City, NY

Need local resumes with strong Banking Domain experience.

Job Description

• This position is for a Power BI Developer 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.

Must-Have Skills

• 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.

Nice-to-Have Skills

• Working knowledge of Data Flows.
• Experience with PBRS (Power BI Report Server).
• Familiarity with Power On.
• Experience with Snowflake data warehouse.

Qualifications

• 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.