Business Intelligence (BI) Developer

Canal Insurance Company•Greenville, SC

2d•Onsite

About The Position

Canal Insurance Company is seeking a highly skilled Business Intelligence (BI) Developer to design, develop, and deliver enterprise-grade reporting, dashboards, and analytical solutions. This role leverages Power BI to provide actionable insights across Claims, Underwriting, Agency, Finance, and Operations. The ideal candidate brings strong expertise in Power BI, SQL development, and Azure-based analytics platforms, along with the ability to translate complex business requirements into scalable, governed data and visualization solutions. Insurance industry experience is preferred but not required for candidates with strong technical BI capabilities. This position follows an onsite work model and requires regular in-office collaboration with business and technology teams.

Requirements

5+ years of experience in BI / Data Analytics development
Strong hands-on Power BI Experience, including dashboard development, data modeling, DAX, and Power Query
Strong SQL skills (complex joins, window functions, performance tuning)
Experience with Azure data and analytics platforms, including Azure Data Lake, Azure SQL, and SQL Server
Strong stakeholder communication and collaboration skills
Ability to work effectively with both business and technical teams
Executive-ready storytelling through dashboards and insights ready storytelling through dashboards and insights
Detail-oriented with a strong analytical mindset
Demonstrated ownership of outcomes, not just report development

Nice To Haves

Experience with Guidewire DataHub / InfoCenter
Experience within the Property & Casualty (P&C) insurance industry
Experience working with large insurance datasets
Experience with ETL tools such as ADF, SSIS, Informatica, or similar
Experience supporting AMS or modernization programs
Familiarity with Data Governance and MDM concepts
Experience supporting Digital / Transformation initiatives

Responsibilities

Design and develop reporting solutions leveraging data from Policy, Claims, Billing, Agency Management systems, and third-party data sources
Build reusable semantic and data models to support enterprise analytics
Collaborate closely with business stakeholders and Data Engineering teams on ETL/ELT processes and curated data layer integration
Develop interactive dashboards and reports using Power BI
Build executive level dashboards (Senior Leadership Team ready views, SLT-ready views)
Develop operational dashboards across the enterprise
Implement row-level security (RLS) and role-based access controls
Translate business KPIs into structured, reusable data models
Partner with Claims, Underwriting, and Finance stakeholders to refine and standardize metrics
Design and deliver cloud-based BI solutions on Azure, leveraging Azure Data Lake, Azure SQL, and Power BI to enable scalable, secure analytics
Build and optimize semantic models and dashboards using Power BI, integrating data from Azure platforms with strong performance, governance, and cost efficiency
Develop complex Power BI dashboards and reports leveraging advanced DAX, Power Query, and enterprise data modeling techniques
Design and implement star schemas for reporting and analytics
Develop advanced DAX calculations and measures in Power BI
Optimize report performance through query tuning and aggregation strategies
Ensure data lineage, governance, and metric consistency
Support Medallion architecture (Raw → Silver → Gold)
Leverage Copilot and other LLM tools to enable self-service analytics and reporting
Develop and optimize complex SQL queries, stored procedures, views, and datasets to support reporting and analytics
Perform query tuning and optimization to improve reporting performance and scalability
Perform data validation and reconciliation against source systems
Implement and support data quality checks
Support audit and regulatory reporting requirements
Document data definitions, transformations, and business logic