Senior Data Engineer, Business Intelligence

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…