> Markdown version of [/jobs/ext/1895589-business-intelligence-bi-developer](https://www.wearedevelopers.com/jobs/ext/1895589-business-intelligence-bi-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Business Intelligence (BI) Developer

- **Company:** Canal Insurance
- **Location:** Greenville, SC, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Business Analytics Applications, Data Analysis, Business Logic, Microsoft Azure, Cloud Computing, Databases, Data Validation, Information Engineering, Data Files, Data Governance, Data Integration, Extract Transform Load (ETL), Data Visualization, Database Development, Database Queries, Document-Oriented Databases, Microsoft SQL Server, SQL Azure, Performance Tuning, Query Optimization, Power BI, Azure Data Lake, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Data Processing, Freeform SQL, Azure Data Factory, Informatica Powercenter, Large Language Models, Powerquery, Data Layers, Data Lakes, Data Lineage, Data Analytics, Star Schema, Data Management, Guidewire
- **Published:** August 2, 2026
- **Apply:** https://www.careerbuilder.com/job-details/business-intelligence-bi-developer-greenville-sc--4ace6a13-ce99-48e3-8cd3-876314442145

## About the Role

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

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
 * Demonstrated ownership of outcomes, not just report development

Skills:
Analysis Skills, Billing, Business Intelligence, Business Skills, Cloud Computing, Communication Skills, Data Analysis, Data Lake, Data Modeling, Data Processing, Data Quality, Data Sets, Data Visualization, Database Extract Transform and Load (ETL), Detail Oriented, Employee Assistance Plan, Finance, Financial Operations, Flexible Spending Accounts, Guidewire, Informatica, Insurance, Leadership, Life Insurance, Master Data Management (MDM), Metrics, Microsoft SQL Server, Microsoft Windows Azure, Operations Planning, Performance Analysis, Performance Management, Performance Metrics, Performance Tuning/Optimization, Power BI, Query Optimization, Reconciliation, Regulatory Reports, Regulatory Requirements, Reporting Dashboards, Reporting Skills, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Star Schema, Stored Procedures, Storytelling, Structured Data, Team Player, Underwriting

## Description

Data & Guidewire Integration

 * 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

BI & Visualization Development

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

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


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [AI PowerPlay: Building High-Impact Teams & Transformative Solutions](https://www.wearedevelopers.com/videos/1005-ai-powerplay-building-high-impact-teams-transformative-solutions)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)