Senior Insurance Analytics Engineer

Hammerjack Pty Ltd; Muntinlupa; On-site; PHP 1,200,000 - 1,600,000; Full time

Job summary

Hammerjack Pty Ltd is seeking a Senior Analytics Engineer with a business mindset and deep insurance data domain expertise. You will bridge our core operations and data infrastructure, managing policy lifecycles, claims reserves, and earned vs. unearned premiums.

You will design robust data models (Star and Snowflake schemas) in SSMS, build ETL pipelines with SSIS and complex T-SQL, and collaborate with actuaries, underwriters, and finance to deliver reliable analytics products.

Qualifications

• BS in Computer Science, Data Analytics, Actuarial Science, Finance or related quantitative field.
• 6–8 years of Insurance data experience or equivalent.
• Strong understanding of insurance financials, policy lifecycles and claim states.
• Proficient in SSMS, SSIS and T-SQL; T-SQLT is a plus.
• Ability to translate business context into data solutions.

Responsibilities

• Design and optimize data models (Star and Snowflake) for insurance data in SSMS.
• Build and maintain ETL pipelines with SSIS and complex T-SQL procedures.
• Implement business logic for metrics like GWP, Net Earned Premium, loss ratios.
• Support historical reporting and time-based financial reporting with as-of data.
• Collaborate with actuaries, underwriters, claims managers, and finance.

Skills

Insurance data experience

SSMS/SSIS/T-SQL

Analytical mindset

Stakeholder collaboration

Education

BS in Computer Science/Data Analytics/Actuarial Science/Finance

Tools

SSMS

SSIS

T-SQL

T-SQLT

Job description

Hammerjack Pty Ltd is seeking a Senior Analytics Engineer with a business mindset and deep insurance data domain expertise. You will bridge our core operations and data infrastructure, managing policy lifecycles, claims reserves, and earned vs. unearned premiums.

You will design robust data models (Star and Snowflake schemas) in SSMS, build ETL pipelines with SSIS and complex T-SQL, and collaborate with actuaries, underwriters, and finance to deliver reliable analytics products.