Power BI Lead

Overview

Hybrid
$150,000 - $175,000
Full Time
No Travel Required

Skills

Insurance
Data Lake
Data Modeling
Analytics
Cloud Computing
Collaboration
DAX
Dashboard
Data Analysis
Data Security
Databricks
Macros
Management
Microsoft
Microsoft Azure
Microsoft Excel
Microsoft Power BI
Policy Administration
Query Optimization
Regulatory Compliance
Reinsurance
Reporting
SAP BASIS
Scripting
Storage
Underwriting
Usability
VBA
Visualization

Job Details

We are currently seeking a Power BI Reporting Lead within a Re/Insurance Data and Analytics team. The Power BI lead will collaborate with cross-functional teams to architect scalable, secure, and high-performance Power BI environments. This is a hybrid role based in NYC, Princeton, NJ or Norwalk, CT.

PLEASE READ - This role is Full time/Direct meaning we cannot work with c2c or visa candidates at this time.

REQUIRED:

  • Experience in the insurance industry, particularly with policy management and underwriting systems
  • Certifications in Microsoft Power Apps or other low code / automation tools
  • Advanced skills in Excel, including formulas, macros, and VBA scripting for implementing complex logic
  • Experience with tools like Microsoft Power Platform, AppSheet, or similar low-code/no-code platforms
  • Familiarity with IMS policy administration systems
  • Experience with APIs for implementing, webhooks, and integration tools such as Zapier or Power Automate

Role: Power BI / Reporting Lead

Location: Hybrid = 3 Days onsite in NYC / Princeton, NJ / Norwalk, CT

Type: W2 / Full Time / Permanent

Technical Skills / Experience

  • Lead the design and implementation of enterprise Power BI architecture, including data models, dashboards, reports, and data gateways, ensuring optimal performance, usability, and security.
  • Collaborate with data engineers, analysts, and stakeholders to translate business requirements into scalable Power BI solutions, including data modeling, DAX calculations, and visualization best practices.
  • Develop and enforce Power BI development standards, governance policies, and best practices to ensure consistency, security, and maintainability across all reports and dashboards.
  • Architect and oversee the integration of Power BI with various data sources, including Azure Data Lake Storage, Databricks, and other cloud or on-premise data platforms.
  • Optimize Power BI performance by implementing best practices in data modeling, query optimization, and report design.
  • Support the deployment of Power BI in enterprise environments, including managing data refresh schedules, security roles, and workspace governance.
  • Provide subject matter expertise on Power BI architecture, including data security, row-level security, and compliance standards.

REQUIRED / DESIRED SKILLS

  • 10+ years of experience in data analytics, with a focus on Power BI architecture, development, and deployment.
  • Proven expertise in designing and implementing enterprise Power BI solutions, including data modeling, DAX, Power Query, and visualization best practices.
  • Strong knowledge of cloud data platforms such as Azure Data Lake, Azure Synapse Analytics, Databricks, DBT and integration with Power BI.

Vertex Solutions Inc is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, national origin, ancestry, religion, age, citizenship, sex, marital or veteran status, disability or handicap, genetics, sexual orientation or any other basis prohibited by applicable law.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.