Business Intelligence (BI) Developer

Canal Insurance Company; Greenville, Northern (SC, KY); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Basic & Voluntary Life Insurance Plans

Short Term & Long Term Disability

401(k) plan with company match up to 6

Flexible Spending Accounts

Employee Assistance Programs

Generous PTO Plan

Job summary

Canal Insurance Company, located in Greenville, SC, seeks a skilled BI Developer to design, develop, and deliver enterprise-grade reporting, dashboards, and analytics using Power BI across Claims, Underwriting, Agency, Finance, and Operations. The role requires translating business requirements into scalable data solutions and governance, with on-site collaboration across teams.

The ideal candidate has strong Power BI, SQL, and Azure analytics experience; insurance industry background is a plus

Qualifications

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

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 with business stakeholders and Data Engineering on ETL/ELT processes and curated data layer integration.
• Develop interactive dashboards and reports using Power BI.
• Build executive level dashboards (SLT-ready views) and operational dashboards across the enterprise.
• Implement row-level security (RLS) and role-based access controls.
• Design and deliver cloud-based BI solutions on Azure, leveraging Azure Data Lake, Azure SQL, and Power BI.
• Develop and optimize complex SQL queries, stored procedures, views, and datasets for reporting and analytics.

Skills

Power BI

SQL

Azure

ETL

Tools

Azure Data Lake

Azure SQL

SQL Server

GuidewireDataHub/InfoCenter

Job description

Canal Insurance Company specializes in insurance for commercial trucking and specialty transportation operations. Canal was founded in 1939 and is located in Greenville, South Carolina. At Canal, we recognize that our success would not be possible without the hard work and dedication of our employees. We know that happiness and productivity go hand in hand, and to that end, we consciously cultivate a culture that enables us to recruit and retain the very best talent in the business.

A Culture With YOU in Mind

• Located in beautiful downtown Greenville, SC
• Employee referral program
• Casual dress code
• Innovation-focused & customer-centric
• 80+ years of industry expertise
• Committed to giving back to our community
• Unquestioned integrity and commitment

Benefits at Canal

• Basic & Voluntary Life Insurance Plans
• Short Term & Long Term Disability
• 401(k) plan with company match up to 6%
• Flexible Spending Accounts
• Employee Assistance Programs
• Generous PTO Plan

Business Intelligence (BI) Developer

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.

Key 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 andoptimizesemantic models and dashboards using Power BI, integrating data from Azure platforms withstrong 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
• 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.

Governance & Quality

• 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

Required Qualifications:

Technical Skills:

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

Preferred Qualifications:

• Experience with GuidewireDataHub/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

Soft Skills:

• 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