Qlik Sense Developer (Insurance Domain)

1. Qlik Sense Development • Design, develop, and maintain interactive Qlik Sense dashboards and analytical applications. • Develop complex Qlik Sense expressions using Set Analysis, AGGR, variables, and advanced calculations. • Build efficient data models using Qlik Sense scripting and ETL techniques. • Work with QVD files, incremental loads, optimized loads, mapping tables, and resident loads. • Develop KPIs, charts, pivot tables, and management dashboards. • Implement Section Access for data-level security. • Optimize dashboard performance, data models, and application reload times. • Troubleshoot data discrepancies and reporting issues. 2. Qlik NPrinting • Develop and maintain automated reports using Qlik NPrinting. • Create Excel, PDF, HTML, and email-based reports. • Configure NPrinting filters, conditions, tasks, and schedules. • Manage report distribution to business users and management. • Troubleshoot NPrinting failures, scheduling issues, and report-generation errors. • Ensure accurate and timely distribution of daily, monthly, and quarterly reports. 3. Insurance Domain Knowledge • Understand insurance business processes, including: • Policy Issuance, Endorsements, Renewals, and Cancellations. • Gross Written Premium (GWP) and Net Written Premium (NWP). • Claims Paid, Outstanding Claims, and Claims Reserves. • Premium Receivables, Debtors Ageing, and Collections. • Reinsurance Ceded Premium and Recoveries. • Underwriting Performance and Loss Ratio. • Insurance Financial and Regulatory Reporting. • Develop insurance dashboards for Underwriting, Claims, Finance, and Management. • Work with insurance business users to understand reporting requirements and translate them into BI solutions. • Perform data validation and reconciliation between Qlik Sense reports and core insurance systems. 4. SQL & Database Management • Write and optimize complex SQL queries involving joins, aggregations, subqueries, and analytical functions. • Extract and transform data from relational databases such as Oracle, SQL Server, or Snowflake. • Validate data accuracy across source systems and BI applications. • Investigate data discrepancies and resolve reporting inconsistencies. • Work with large datasets and optimize queries for better performance. 5. Support & Maintenance • Monitor Qlik Sense application reloads and NPrinting schedules. • Investigate and resolve production issues. • Maintain existing dashboards and implement enhancements. • Coordinate with business users, database teams, and application support teams. • Prepare technical documentation and support UAT activities. Required Technical Skills Skill Requirement Qlik Sense Advanced – Mandatory Qlik Sense Scripting & Data Modeling Advanced – Mandatory Set Analysis & Advanced Expressions Advanced – Mandatory Qlik NPrinting Strong hands-on experience – Mandatory SQL / PL/SQL Strong knowledge – Mandatory Insurance Domain Good understanding – Mandatory QVD & Incremental Loading Strong knowledge Dashboard Performance Optimization Strong knowledge Oracle / SQL Server Working experience Data Validation & Reconciliation Strong knowledge Qlik Sense Administration Basic to intermediate Required Qualifications • Bachelor’s degree in computer science, Information Technology, Engineering, or a related discipline. • 5–7 years of relevant experience in Business Intelligence and Qlik Sense development. • Strong hands-on experience with Qlik Sense and Qlik NPrinting. • Prior experience working in the General Insurance domain is strongly preferred. • Good SQL development and data troubleshooting skills. • Strong analytical, problem-solving, and communication skills. • Ability to work independently and coordinate directly with business stakeholders. Preferred Skills • Experience with insurance core systems such as Premia or similar policy administration systems. • Knowledge of insurance accounting and financial reconciliation. • Experience developing executive-level MIS and management dashboards. • Understanding of insurance KPIs such as GWP, NWP, Loss Ratio, Claims Outstanding, and Debtors Ageing. • Experience with Qlik Sense Enterprise administration, security, and task scheduling. • Exposure to Snowflake, Power BI, or other modern BI/data platforms. Expected Deliverables The selected candidate will be responsible for: • Developing and maintaining Qlik Sense dashboards for Insurance, Finance, Underwriting, and Claims departments. • Automating operational and management reports using Qlik NPrinting. • Ensuring accuracy and consistency of insurance KPIs across reporting systems. • Improving application performance and reducing manual reporting effort. • Providing timely production support and resolving reporting issues.