Business Intelligence (BI) Developer

Canal Insurance Company•Greenville, SC

1d•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. The role uses Power BI to provide actionable insights across Claims, Underwriting, Agency, Finance, and Operations. The successful candidate will bring strong Power BI, SQL development, and Azure analytics expertise, and translate complex business requirements into scalable, governed data and visualization solutions. Insurance industry experience is preferred but is 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. The developer will work with data from insurance systems and third-party sources, develop enterprise dashboards and reusable data models, support data governance and quality, and deliver secure, scalable cloud-based BI solutions on Azure.

Requirements

At least 5 years of experience in BI or data analytics development.
Strong hands-on Power BI experience, including dashboard development, data modeling, DAX, and Power Query.
Strong SQL skills, including complex joins, window functions, and 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 business and technical teams.
Ability to communicate insights through executive-ready dashboards and storytelling.
Detail-oriented with a strong analytical mindset.
Demonstrated ownership of outcomes, not just report development.

Nice To Haves

Experience with Guidewire DataHub or InfoCenter.
Experience in the Property & Casualty 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 or Transformation initiatives.
Insurance industry experience is preferred, but not required for candidates with strong technical BI capabilities.

Responsibilities

Design and develop reporting solutions using data from Policy, Claims, Billing, Agency Management systems, and third-party sources.
Build reusable semantic and data models for enterprise analytics.
Collaborate with business stakeholders and Data Engineering teams on ETL/ELT processes and curated data layer integration.
Develop interactive Power BI dashboards and reports, including executive-level and enterprise operational dashboards.
Implement row-level security and role-based access controls.
Translate business KPIs into structured, reusable data models and partner with Claims, Underwriting, and Finance stakeholders to refine and standardize metrics.
Design and deliver cloud-based BI solutions using Azure Data Lake, Azure SQL, and Power BI.
Build and optimize semantic models and dashboards, integrating Azure data with attention to performance, governance, and cost efficiency.
Develop complex Power BI reports using advanced DAX, Power Query, and enterprise data modeling techniques.
Design and implement star schemas for reporting and analytics.
Optimize report performance through query tuning and aggregation strategies.
Ensure data lineage, governance, and metric consistency, and 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 for reporting and analytics.
Perform query tuning and optimization to improve reporting performance and scalability.
Validate and reconcile data against source systems and implement and support data quality checks.
Support audit and regulatory reporting requirements.
Document data definitions, transformations, and business logic.