Power BI Architect/Developer

Technology · Iselin, New Jersey
Department Technology
Employment Type Contractor
Minimum Experience Senior Manager/Supervisor
Compensation DOE

SoHo Dragon represents an investment bank with offices in Manhattan and Metro Park NJ. Our client needs to hire an experienced Power BI Platform Subject Matter Expert to support and maintain the Power BI platform and connect it to Snowflake Database for a data source. This is a Hands-on role for a technical Architect/Developer.

This new role will act as a centralized Power BI Architect and subject matter expert that can lead conversion from an on-prem implementation of Cognos that uses SQL Data warehouse as a data source, to Power BI that will rely on Snowflake as a data source. Power BI Architect will be required to implement Power BI with Snowflake. Additionally, the Power BI Architect will conduct Impact Analysis on current Cognos reports and determine which reports migrating to Power BI. This enterprise-wide migration is estimated to take approximately 1 or 2 years.

  • The interview will be Phone Screen followed by Face-to-Face
  • Corp-to-Corp, 1099 and W2 are all accepted
  • New Hire is required to work onsite. The primary location will be Metro Park, NJ office

Job Requirements:


Capital Markets experience is strongly preferred.

Advanced Experience with Power BI

5+ years Power BI experience in MS Power BI connection types including Snowflake

Current experience in administering Power BI permissions, roles, security, and securing data layers based on specific identifiers such as role and/or agency.

Responsible for administering, supporting, monitoring, and tuning the Power BI reporting environment; This involves the management and administration of all components of the Power BI domain, including Power BI on-premise data gateway servers.

Strong SQL skills are required

Financial Services experience is required. Trade Position Data and Risk Data experience are important. 

Need previous experience with Risk Data and Trade Position Data

Expertise with Dimensional Modeling, Normalized Data, and De-Normalized Data is all required

Develops and oversees monitoring systems to measure usage and ensure operational stability.

Experience in creating SSAS tabular models.

Experience to connect to and transform data in Power BI.

Experience producing Power BI data models and recommending best practices for the creation of reports and graphics/visualizations.

Understanding of Power BI Online Services and best governance practices.

Understanding of Row Level Security in Power BI.

Experience with enterprise BI solution development

Solution Architect expertise to define Power BI as a global reporting tool with the required strategy needed for the same.

Familiarity using Snowflake data sources is required.

Capability to define innovation in the Power BI space.

Need to leverage and propose more benefits of Power BI to business in terms of performance reporting and mobility.

Works closely with Power BI report users to tune and optimize Power BI reports and dashboards.

Serves as Best Practices resource for Power BI initiatives in the organization.

Hands-on experience with enterprise business intelligence solution data modeling, data mart, and data warehouse architecture.

Power BI certification is added advantage.

Business Analysis skills are required

The position calls for a seasoned IT professional with leadership qualities and background of 10+ years of experience in IT.

Thank You

Your application was submitted successfully.

  • Location
    Iselin, New Jersey
  • Department
  • Employment Type
  • Minimum Experience
    Senior Manager/Supervisor
  • Compensation