C

Coaction Specialty Insurance

Underwrites tailored specialty insurance solutions

Senior Data Engineer - Business Intelligence

Business IntelligenceConfirmed live in the last 24 hours
Full-timeMorristown, NJ, USAIn-person

About the Job

Requirements

  • At least 8 years of experience in Business Intelligence, Analytics Engineering, Data and Analytics, or a closely related discipline.
  • At least 5 years of hands-on Power BI experience designing and delivering enterprise BI solutions.
  • Advanced expertise in 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, user acceptance testing, deployment, and production support.
  • 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.
  • Problem-solving ability and a proactive, solution-oriented mindset.
  • Experience independently delivering complex BI initiatives and contributing to solution design, testing, documentation, and production readiness.
  • Insurance industry experience, including familiarity with one or more domains such as 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 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 scalable, maintainable, performant solutions aligned with enterprise BI standards.
  • Design and enhance reusable enterprise semantic models supporting multiple reports, business domains, and analytical use cases.
  • Apply 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, key performance indicators, ratios, time-intelligence calculations, and reusable analytical logic.
  • Assess 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 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.

Desired Qualifications

  • Experience with AtScale or another enterprise semantic or metrics layer.
  • Experience with Amazon Redshift or a comparable cloud data warehouse.
  • Experience with Microsoft Fabric and enterprise Power BI administration concepts.
  • Experience migrating analytics from Tableau or another legacy BI platform to Power BI.
  • Experience building governed self-service analytics solutions and certified KPI frameworks.
  • Experience with Azure DevOps, Git-based source control, continuous integration and continuous delivery, and structured deployment practices.
  • Experience supporting enterprise security, gateways, workspaces, deployment pipelines, and production operations.
  • Experience participating in large-scale analytics modernization or BI transformation programs.

About the Company

Coaction Specialty Insurance

Underwrites tailored specialty insurance solutions

Coaction Specialty Insurance provides tailored coverage for specialty businesses in casualty, entertainment, excess casualty, executive liability, and multiline property. Policies are crafted from underwriting expertise and focused distribution partnerships, with services that address each client’s unique risks. Modern technology speeds quoting, binding, and policy management, while claims handling and customer support ensure ongoing service. The goal is to help niche clients grow by delivering customized coverage and reliable, long-term relationships.

Company size
501-1,000
Company stage
IPO
Headquarters
Morris Twp, NJ
Founded
2009

Recently Posted Jobs

Explore more opportunities at Coaction Specialty Insurance

See more jobs