Senior Data Engineer, Business Intelligence

Coaction Specialty Management Company; Morristown (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

Coaction seeks a Senior Business Intelligence Developer to join the Data Analytics Engineering team in Morristown, NJ. The role is a hands-on senior technical position focused on Power BI, semantic and dimensional modeling, and enterprise analytics for insurance clients.

The successful candidate will lead complex BI initiatives, partner with stakeholders across underwriting, claims, finance, and actuarial, and deliver scalable analytics from requirements through deployment and production

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.

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.

Skills

Power BI

BI/Analytics

Data modeling

Tools

DAX

SQL

Job description

At Coaction, we're a unique mix of leaders, achievers, thinkers, and team players with a high-performance mindset and a diverse skillset. We bring our industry expertise together to continually push the boundaries of what insurance can be for our clients.

Position Summary

We are seeking a Senior Business Intelligence Developer to join the Data Analytics Engineering team and help build the next generation of enterprise analytics solutions. This is a hands‑on senior technical role for an individual who combines deep Power BI expertise, semantic and dimensional modeling experience, strong business acumen, insurance industry knowledge, and excellent communication skills.

The successful candidate will partner with stakeholders to understand complex business problems, translate them into scalable analytics solutions, and own delivery from requirements and data analysis through semantic modeling, visualization, validation, deployment, and production support. The role will operate as a senior individual contributor, independently driving complex BI initiatives, applying strong technical judgment, and delivering high‑quality solutions across multiple business functions.

Key Responsibilities

Business Intelligence and Power BI Development

• 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.

Semantic and Dimensional Modeling

• 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.

Analytics Engineering and Platform Delivery

• 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.

Insurance Analytics and Stakeholder Partnership

• 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.

Solution Ownership and Delivery

• Take ownership of complex or ambiguous analytics problems and drive them through resolution.
• Use a solution‑oriented approach that considers root cause, downstream impacts, 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.

Required 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 expe