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

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 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 one or more domains such as underwriting, claims, premium, policy, actuarial, exposure/risk, or finance.

Preferred 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, CI/CD, 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.

Salary range specific to for this role: $155,000-$200,000 + discretionary incentive bonus + benefits depends on various factors including, without limitation, individual and organizational performance. The offered rate of compensation will be based on individual education, experience, and qualifications.  In addition, employees are eligible for standard benefits package including paid time off, medical, dental and retirement.

Equal Opportunity Employer

Coaction is an Equal Employment Opportunity employer. Coaction’s policy is not to discriminate against any applicant or employee based on race, color, religion, national origin, gender, age, sexual orientation, gender identity or expression, marital status, mental or physical disability, and genetic information, or any other basis protected by applicable law. Coaction also prohibits harassment of applicants or employees based on any of these protected categories.