About Canal Insurance
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
- Career growth & advancement opportunities
- Comprehensive benefits package
- 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
- Medical, Dental, & Vision
- 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 and IBM Cognos Analytics to provide actionable insights across Claims, Underwriting, Agency, Finance, and Operations.
The ideal candidate brings a strong combination of insurance domain expertise, technical BI proficiency, and the ability to translate complex business requirements into scalable, governed data and visualization solutions.
Key Responsibilities:
Data & Guidewire Integration
- Design and develop reporting solutions leveraging data from Policy, Claims, Billing, Agency Management systems, and third-party data sourcesparty 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
BI & Visualization Development
- Develop interactive dashboards and reports using:
- Power BI
- IBM Cognos Analytics
- Build executive level dashboards (Senior Leadership Team ready views, SLTready views)
- Develop operational dashboards across the enterprise
- Implement row level security (RLS) and role based accesslevel security (RLS) and rolebased access
- Translate business KPIs into structured, reusable data models
- Partner with Claims, Underwriting, and Finance stakeholders to refine and standardize metrics
- Design and deliver cloudbased 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.
Data Modeling & Architecture
- 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 reportingservice analytics and reporting
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
- 3+ years working with insurance products
- Strong hands on experience with: on experience with:
- Power BI (DAX, Power Query, data modeling)
- IBM Cognos Analytics
- Strong SQL skills (complex joins, window functions, performance tuning)
- Experience with Azure, Data Lake, and SQL Server preferred
- Experience working with large insurance datasets
Insurance Domain Knowledge:
- Strong understanding of:
- P&C insurance operations
- Claims lifecycle and reserving concepts
- Underwriting workflows
- Agency hierarchy
- Premium and billing structures
- Ability to interpret insurance KPIs and regulatory metrics
Preferred Qualifications:
- Experience with Guidewire DataHub / InfoCenter
- 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 insightsready storytelling through dashboards and insights
- Detail oriented with a strong analytical mindsetoriented with a strong analytical mindset
- Demonstrated ownership of outcomes, not just report development
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Skills Required
- 5+ years of experience in BI / Data Analytics development
- 3+ years working with insurance products
- Strong hands-on experience with Power BI
- Strong SQL skills
- Experience with Azure, Data Lake, and SQL Server
What We Do
Canal Insurance Company specializes in insurance for commercial trucking and specialty transportation operations since 1939. It distributes its products nationwide through select professional general agents. Canal provides comprehensive insurance products and services including auto liability, motor truck cargo, physical damage, trucker’s general liability coverages and risk management services. Canal Insurance Company is located in Greenville, SC, and continues to grow through the knowledge and commitment of its employees.
