Senior Analytics Engineer
Summary
Senior Analytics Engineer at OONA Insurance (formerly ABDA), a general insurer in Indonesia, acting as the bridge between business operations and data infrastructure. Day to day they design star/snowflake data models and build ETL pipelines with SSMS, SSIS, and T-SQL to translate insurance metrics like GWP, loss ratios, and claims reserves into reliable analytical data products.
We are seeking a business-minded Senior Analytics Engineer with deep expertise in the Non-Life and Health Insurance domains who will act as the vital bridge between our core business operations and our data infrastructure. Managing insurance data lifecycles will be your primary focus, ranging from policy underwriting, claims reserve changes, and earned vs. unearned premiums.
Key responsibilities
Design and optimize robust, business-centric data models (Star and Snowflake schemas) within SSMS that accurately map the complex data lifecycles of insurance policies and claims
Build, scale, and maintain stable ETL pipelines using SSIS and complex T-SQL stored procedures, ensuring clean and optimized structures for business analytics
Translate nuanced insurance metrics directly into the data layer, including Gross Written Premium (GWP), Net Earned Premium, Loss Ratios, Claims Reserves etc.
Solve complex insurance data problems, such as retroactively adjusted claims, policy endorsements, and historical point-in-time ('as-of') financial reporting using advanced T-SQL
Partner closely with Actuaries, Underwriters, Claims Managers, and Finance teams to turn messy production source data into reliable, intuitive analytical data products
Qualifications
Bachelor Degree in Computer Science, Data Analytics, Actuarial Science, Finance or related quantitative field
Minimum 6 to 8 years of Insurance data experience or related field
Strong understanding of core insurance financials, policy lifecycles, and claims states
Advance proficiency in SSMS, SSIS, TSQL, TSQLT. Cloud is a plus
Proven ability to prioritize business context and data quality over pure engineering output
Fluent in English, both written and spoken
PT Asuransi Bina Dana Arta Tbk was founded as PT Asuransi Bina Dharma Arta in Jakarta on 12 October 1982. On 1999, PT Asuransi Bina Dharma Arta became public company and rebranded to PT Asuransi Bina Dana Arta Tbk, or also known as ABDA. Since 9 February 2023, ABDA Insurance changed its brand to OONA Insurance.
OONA focuses on providing protection against any losses or damages, such as Fire, Vehicles, Engineering, Liability, Transportation, Heavy Equipment & Machinery, Health Protection and many more.
With the support of branches spreading all over Indonesia and along with over 400 employees, we are steadily growing and becoming a strong general insurance company and a force to be reckoned with among Insurance providers in Indonesia.
PT Asuransi Bina Dana Arta Tbk was founded as PT Asuransi Bina Dharma Arta in Jakarta on 12 October 1982. On 1999, PT Asuransi Bina Dharma Arta became public company and rebranded to PT Asuransi Bina Dana Arta Tbk, or also known as ABDA. Since 9 February 2023, ABDA Insurance changed its brand to OONA Insurance.
OONA focuses on providing protection against any losses or damages, such as Fire, Vehicles, Engineering, Liability, Transportation, Heavy Equipment & Machinery, Health Protection and many more.
With the support of branches spreading all over Indonesia and along with over 400 employees, we are steadily growing and becoming a strong general insurance company and a force to be reckoned with among Insurance providers in Indonesia.