Senior Power BI & Insurance Analytics Engineer

LE003 Coaction Specialty Management Company, Inc.

Morristown (NJ)

On-site

USD 146,000 - 200,000

Full time

4 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Benefits package

Paid time off

Job summary

Coaction Specialty Insurance Group seeks a Senior Business Intelligence Developer to join the Data Analytics Engineering team in Morristown, NJ. This hands-on role requires deep Power BI expertise, semantic and dimensional modeling, and strong business acumen to translate complex problems into scalable analytics solutions.

You will own delivery from requirements through production support, collaborating with underwriting, claims, finance, actuarial, and risk teams.

Qualifications

8+ years of experience in Business Intelligence, Analytics Engineering, Data and Analytics, or a closely related discipline.
5+ years of hands-on Power BI experience designing and delivering enterprise BI solutions.
Advanced Power BI expertise, including Power BI Desktop and Service, DAX, semantic modeling, visualization, performance optimization, row-level security, workspace and deployment concepts, and production troubleshooting.
Strong hands-on experience with dimensional and semantic modeling.
Strong SQL skills and the ability to investigate, reconcile, and validate data independently.
Experience delivering solutions across the full BI development lifecycle, from discovery and design through development, testing, UAT, deployment, and production support.
Demonstrated ability to convert business requirements into reusable, governed technical solutions.
Strong written and verbal communication skills and the ability to work directly with senior business and technology stakeholders.
Demonstrated problem-solving ability and a proactive, solution-oriented mindset.
Demonstrated experience independently delivering complex BI initiatives and contributing to solution design, testing, documentation, and production readiness.
Insurance industry experience, including familiarity with underwriting, claims, premium, policy, actuarial, exposure/risk, or finance.

Responsibilities

Design and develop enterprise-grade Power BI dashboards, reports, and analytical experiences for executive, operational, and self-service use cases.
Translate complex business questions into intuitive analytical solutions that clearly communicate performance, trends, drivers, and areas requiring action.
Apply advanced Power BI capabilities across visualization, filtering, drill-through, navigation, accessibility, security, performance optimization, and production support.
Design reports around clear business questions and stakeholder-friendly terminology, progressing from summary information into controlled analytical detail.
Build solutions that are scalable, maintainable, performant, and aligned with enterprise BI standards.
Design and enhance reusable enterprise semantic models supporting multiple reports, business domains, and analytical use cases.
Apply strong dimensional-modeling practices, including defined grain, fact and dimension tables, conformed dimensions, surrogate and composite keys, bridge tables, hierarchies, role-playing dimensions, and multiple-fact scenarios.
Design governed business measures, KPIs, ratios, time-intelligence calculations, and reusable analytical logic.
Understand how modeling decisions affect accuracy, usability, scalability, query performance, security, and self-service capabilities.
Promote reusable semantic solutions rather than isolated report-specific logic or duplicate metric definitions.
Serve as a Power BI subject-matter expert and technical resource for the broader analytics organization.
Troubleshoot complex report, semantic-model, data, security, gateway, performance, refresh, deployment, and production issues.
Apply sound practices for DAX, live connections, row-level security, workspace management, source control, release management, and production monitoring.
Validate analytical results against source data, approved SQL, and documented business definitions before release.
Partner with data engineering and architecture teams to ensure reusable transformations and dimensional structures are implemented at the appropriate layer.
Apply insurance domain knowledge to translate business concepts into meaningful analytics and reusable enterprise metrics.
Partner effectively with stakeholders across Underwriting, Claims, Finance, Actuarial, Exposure/Risk, Operations, and other insurance functions.
Lead requirements and discovery discussions and translate business language into actionable technical designs.
Explain complex data and BI concepts clearly to technical and non-technical audiences, including senior leaders.
Communicate status, risks, dependencies, design decisions, and tradeoffs clearly and proactively.
Take ownership of complex or ambiguous analytics problems and drive them through resolution.
Use a solution-oriented approach that considers root cause, downstream impacts, maintainability, and opportunities for reuse.
Produce well-designed, thoroughly tested, and documented BI solutions that meet business requirements and enterprise standards.
Apply reusable implementation patterns and follow team standards for quality, documentation, testing, and production readiness.
Drive complex initiatives independently while coordinating delivery across business and technology teams.
Demonstrate accountability, sound judgment, transparency, and consistent follow-through.
Demonstrated experience independently delivering complex BI initiatives and contributing to solution design, testing, documentation, and production readiness.