BI Developer

BI DeveloperGreenville, SC, US Remote Insurance Vaco $USD 95000 - 120000 Direct HireVaco 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 IntegrationDesign and develop reporting solutions leveraging data from Policy, Claims, Billing, Agency Management systems, and third-party data sourcesBuild reusable semantic and data models to support enterprise analyticsCollaborate closely with business stakeholders and Data Engineering teams on ETL/ELT processes and curated data layer integrationBI & Visualization DevelopmentDevelop interactive dashboards and reports using:Power BIIBM Cognos AnalyticsBuild executive level dashboards (Senior Leadership Team ready views)Develop operational dashboards across the enterpriseImplement row level security and role based accessTranslate business KPIs into structured, reusable data modelsPartner with Claims, Underwriting, and Finance stakeholders to refine and standardize metricsDesign 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.Data Modeling & ArchitectureDesign and implement star schemas for reporting and analyticsDevelop advanced DAX calculations and measures in Power BIOptimize report performance through query tuning and aggregation strategiesEnsure data lineage, governance, and metric consistencySupport Medallion architecture (Raw ? Silver ? Gold)Leverage Copilot and other LLM tools to enable self-service analytics and reportingGovernance & QualityPerform data validation and reconciliation against source systemsImplement and support data quality checksSupport audit and regulatory reporting requirementsDocument data definitions, transformations, and business logicRequired Qualifications:Technical Skills:5 years of experience in BI / Data Analytics development3 years working with insurance productsStrong hands-on experience with:Power BI (DAX, Power Query, data modeling)IBM Cognos AnalyticsStrong SQL skills (complex joins, window functions, performance tuning)Experience with Azure, Data Lake, and SQL Server preferredExperience working with large insurance datasetsInsurance Domain Knowledge:Strong understanding of:P&C insurance operationsClaims lifecycle and reserving conceptsUnderwriting workflowsAgency hierarchyPremium and billing structuresAbility to interpret insurance KPIs and regulatory metricsPreferred Qualifications:Experience with Guidewire DataHub / InfoCenterExperience with ETL tools such as ADF, SSIS, Informatica, or similarExperience supporting AMS or modernization programsFamiliarity with Data Governance and MDM conceptsExperience supporting Digital / Transformation initiativesBy submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions.