Business Intelligence Developer

Business Intelligence (BI) Developer Skills (BI Developer – Insurance): • Power BI (DAX, Power Query, Semantic Data Modeling) • IBM Cognos Analytics • SQL (Complex Queries, Performance Tuning) • Star Schema & Dimensional Data Modeling • Azure Data Platform (Azure Data Lake, Azure SQL) • Guidewire DataHub / InfoCenter • Insurance Analytics (P&C Claims, Underwriting, Billing Data) 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