BI Developer

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

Job Description

A growing insurance organization is seeking a BI Developer to design, develop and deliver enterprise-grade reporting, dashboards and analytical solutions. This hybrid role will use Power BI and IBM Cognos Analytics to provide actionable insights across claims, underwriting, agency, finance and operations.

Responsibilities

• Design and develop reporting solutions using policy, claims, billing, agency management and third-party data sources.
• Build reusable semantic models, data models and executive-level dashboards.
• Develop interactive reports and operational dashboards using Power BI and IBM Cognos Analytics.
• Implement row-level security and role-based access controls.
• Design and deliver cloud-based BI solutions using Azure Data Lake, Azure SQL and Power BI.
• Develop advanced DAX calculations and measures while optimizing report performance.
• Perform data validation and reconciliation against source systems.
• Document data definitions, transformations and business logic.
• Partner with business stakeholders and data engineering teams to support governed analytics solutions.

Requirements

• 5+ years of experience in BI or data analytics development
• 3+ years working with insurance products
• Power BI expertise including DAX, Power Query and data modeling
• IBM Cognos Analytics experience
• Strong SQL skills including complex joins, window functions and performance tuning
• Understanding of P&C insurance operations
• Knowledge of claims lifecycle and reserving conceptsKnowledge of underwriting workflows, agency hierarchy and premium and billing structures
• Experience with large insurance datasets
• Strong stakeholder communication and collaboration skills

Pay Range

The anticipated pay range for this position is $95,000 to $120,000 with a 6.5% to 8% bonus. We understand salary is an important factor in a job search, and we encourage you to apply even if you feel that your desired compensation may fall outside of the listed range. The final pay for this position is determined based on several factors including but not limited to, relevant experience, skills and certifications, education and training, geographic location, market conditions, and internal equity. We are committed to finding the right candidate for this role and are open to discussing how your unique qualifications align with our needs.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• 401(k) retirement savings plan

Equal Opportunity Employer

The Jacobson Group is committed to fostering an inclusive and equitable workplace that reflects the diverse communities we serve. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other protected characteristic as defined by applicable law. We believe that diversity of thought, background and experience strengthens our team and drives innovation. All employment decisions are based on qualifications, merit and business needs. If you require a reasonable accommodation to complete the application process or participate in an interview, please contact us at [e-mail] or [phone] to make a request.

Contact

Troy Andrew
[e-mail]

Refer a Colleague

Do you know someone who would be interested in this project? Submit your referral directly by emailing the Jacobson contact listed above or submitting them through this form. If your referral is hired for a contract assignment and meets all other eligibility criteria, you will receive a referral bonus!