Job Title: Business Data Analyst – Insurance Domain
Job Overview
We are looking for an experienced Business Data Analyst with strong Insurance domain knowledge, hands-on SQL expertise, and Data Warehouse experience. The ideal candidate should have a solid understanding of Commercial Lines Insurance, particularly Policy Administration, Underwriting, Billing, and Claims.
Key Responsibilities
Lead requirement-gathering workshops and walkthroughs, ensuring alignment between technical and non-technical stakeholders.
Demonstrate strong knowledge of Commercial Lines Insurance, including policy administration, underwriting, billing, and claims workflows.
Write complex SQL queries to validate data, investigate production issues, and perform data reconciliation.
Perform data profiling, source-to-target mapping, and data validation for migration and reporting initiatives.
Develop ad-hoc SQL queries and reports to provide business teams with insights into policy and claims metrics.
Collaborate with business and technical teams throughout the project delivery lifecycle.
Leverage AI coding assistants such as GitHub Copilot and Claude for SQL development, documentation, and defect analysis.
Support development activities, particularly those involving SQL, data processing, and data-related enhancements.
Required Skills
Strong hands-on experience with SQL and complex query writing.
Good understanding of Data Warehousing concepts and data modelling.
Experience in data profiling, data mapping, migration, and reconciliation.
Strong understanding of Insurance domain processes.
Experience with Policy Administration, Underwriting, Billing, and Claims.
Excellent communication, analytical, and stakeholder management skills.
Preferred Skills
Experience in Middle Market and Large Commercial Business Insurance.
Experience with Insurance platforms such as Guidewire or Duck Creek.
Knowledge of ETL/ELT processes and reporting tools.
Experience using GitHub Copilot, Claude, or other AI coding assistants.
Ideal Candidate Background
Candidates with experience as a Business Data Analyst, Insurance Business Analyst, Technical Business Analyst, Insurance Data Analyst, Data Engineer, ETL Developer, or Data Warehouse Developer with relevant Insurance domain experience are encouraged to apply.
Note: Insurance domain experience and hands-on SQL skills are essential.