Senior BI Developer: Insurance Analytics (Power BI, Cognos)

The Jacobson Group; United States; Hybrid; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) retirement savings plan

Job summary

The Jacobson Group is seeking a BI Developer to design, develop and deliver enterprise-grade reporting, dashboards and analytics. This hybrid role uses Power BI and IBM Cognos Analytics to provide insights across claims, underwriting, agency, finance and operations.

Responsibilities include designing data models, building executive dashboards, implementing security and delivering Azure-based BI solutions. The ideal candidate has 5+ years in BI and solid SQL skills within the insurance industry.

Qualifications

• 5+ years of BI or data analytics development experience.
• 3+ years working with insurance products.
• Strong SQL skills with advanced joins and window functions.
• Power BI expertise including DAX, Power Query and data modeling.
• IBM Cognos Analytics experience.

Responsibilities

• Design and develop reporting solutions from policy, claims and billing data.
• Build reusable data models and executive dashboards.
• Create interactive reports using Power BI and Cognos Analytics.
• Implement row-level security and RBAC.
• Deliver cloud BI using Azure Data Lake, Azure SQL and Power BI.
• Develop advanced DAX calculations and optimize performance.
• Validate data against source systems and document data logic.

Skills

BI experience

Insurance products

Power BI DAX

SQL advanced

Stakeholder communication

Tools

IBM Cognos Analytics

Power BI

Power Query

Job description

The Jacobson Group is seeking a BI Developer to design, develop and deliver enterprise-grade reporting, dashboards and analytics. This hybrid role uses Power BI and IBM Cognos Analytics to provide insights across claims, underwriting, agency, finance and operations.

Responsibilities include designing data models, building executive dashboards, implementing security and delivering Azure-based BI solutions. The ideal candidate has 5+ years in BI and solid SQL skills within the insurance industry.