Data Engineer

Data Engineer Insurance/Reinsurance

Location: Bangalore/Hybrid (3 days per week in office)

About MIC Global

MIC Global is a full-stack micro-insurance provider delivering embedded parametric insurance solutions to platform companies across 12+ countries. As a Lloyd's Coverholder with our in-house reinsurer MicRe, we operate our Global Operations Center in Bangalore, supporting leading clients including a global ride-hailing platform and international property rental marketplace.

About the Role

We're seeking a Data Engineer with insurance domain knowledge and strong DBA skills to build data pipelines, design reporting solutions for KPIs, ensure data quality, and enable data-driven decisions across our organization.

Key Responsibilities

Data Pipelines & Reporting

• Design and build ETL/ELT pipelines using Azure Data Factory and Python for policies, claims, bordereaux, and premiums
• Build KPI dashboards and reporting solutions for loss ratios, combined ratios, premium analysis, and claims performance
• Implement data normalization, quality checks, and validation rules with automated monitoring and alerting
• Design dimensional data models to support analytics and data-driven decision making
• Support Lloyd's market reporting and integrate external data sources (NATCAT, GIS) when needed

Database Administration & Optimization

• Support production database troubleshooting, performance tuning, and query optimization
• Design and optimize stored procedures, functions, and views for insurance calculations
• Support reporting team with complex SQL queries and database design

Collaboration

• Support analytics and reporting teams with data models, KPI calculations, and complex queries
• Enable data-driven decisions by providing reliable, accurate data and technical guidance

Essential Requirements

• 3+ years in insurance/reinsurance industry with strong understanding of insurance data, metrics (loss ratios, combined ratios), and reporting
• 5-8 years in data engineering and database administration
• Strong MS SQL Server expertise: complex queries, stored procedures, performance tuning
• Azure services experience: Azure SQL Database, Azure Data Factory, Azure Storage
• Python for ETL/ELT pipelines, data processing, and automation
• Data modeling, normalization, and dimensional design for analytics

Preferred Qualifications

• Lloyd's market experience or knowledge of insurance regulatory reporting (Solvency II, IFRS 17)
• Azure Databricks/Spark or catastrophe data integration (NATCAT, GIS)
• Power BI/Tableau or Azure certifications (Data Engineer, Database Administrator)
• Web scraping for market data collection

Benefits

• 33 days paid holiday, competitive compensation, hybrid work (3 days/week in office)
• High-growth insurtech environment with clear career development path

Check us out on - www.micglobal.com