HCV Underwriting Managers
HCV Underwriting Managers
HCV Underwriting Managers provides insurance products for heavy commercial vehicles and the freight they carry. Its cover includes trucks, trailers, plant and goods in transit, with offerings such as Truck + Care, Load + Care and Owner Driver + Care. The company works with brokers as well as owner-drivers and fleets, and offers services including roadside assistance, windscreen cover and personal cover. HCV is an authorised financial services provider; its products are underwritten by a licensed non-life insurer.

Senior Finance Data Analyst

Analyze insurance policy and accounting data for Mission Underwriters’ underwriting platform. Build SQL validations, ETL controls, and finance reports.

Tavsif

  • Operate and troubleshoot the daily finance accounting ETL process.
  • Produce policy transaction data and amounts for premiums, taxes, and fees.
  • Reconcile financial data in the enterprise data warehouse (EDW) against finance ETL outputs.
  • Investigate discrepancies, tracing causes such as missing or duplicate transactions, timing, mappings, joins, effective dates, transformation logic, and source data defects.
  • Use SQL to query, validate, and transform policy, premium, commission, payment, tax, fee, and related financial data.
  • Maintain automated validation rules, reconciliation checks, reasonableness tests, and exception reports.
  • Provide Finance with recurring data, reports, reconciliations, and supporting schedules for accounting, reporting, close, and operations.
  • Work with Finance to define metrics, transaction treatments, data definitions, accounting assumptions, and acceptance criteria.
  • Collaborate with data engineers to trace source-to-target logic, recommend field-level changes, validate fixes, and support production processes.
  • Develop knowledge of the EDW data model, insurance policy lifecycle, transaction data, source systems, data layers, grains, and relationships.
  • Help define how paid data is sourced, ingested, modeled, validated, and made available in the EDW.
  • Support portfolio and program health reporting through data preparation, KPI reporting, and process improvements.
  • Conduct ad hoc Finance analyses, quantify business impacts, explain trends, and share findings.
  • Document process flows, SQL, data definitions, reconciliation procedures, and issues.

Talablar

  • At least four years of experience in finance data analysis, financial reporting, accounting analytics, business intelligence, or a related analytical role.
  • At least two years working with commercial or specialty insurance data, such as policy, premium, commission, paid, tax, fee, or other transaction records.
  • Working knowledge of insurance concepts, including premium and commission transactions, taxes, fees, and reconciliations.
  • Strong SQL skills, including complex joins and aggregations, financial reconciliations, data validation, and reusable queries or processes.
  • Experience comparing data across systems or ETL processes and diagnosing discrepancies.
  • Experience creating or maintaining recurring reports, validation checks, or financial data controls with SQL, Excel, BI, or similar tools.
  • Critical thinking, attention to detail, communication, and documentation skills.
  • Experience supporting financial processes, planning, management reporting, or process automation is preferred.
  • Experience with enterprise data warehouses, relational or dimensional data models, or data pipeline development is preferred.
  • Familiarity with Databricks, PySpark, Python, Azure, or similar data engineering and development tools is preferred.
  • Experience with Power BI or other BI tools, and with ERP, general ledger, premium accounting, policy administration, or billing systems is preferred.
  • A bachelor’s degree in finance, accounting, economics, data analytics, information systems, or a related field—or equivalent experience—is preferred.
  • Ability to travel up to 5% of the year.
  • Proficiency in Excel.
  • Must reside in the United States and be authorized to work there without employment sponsorship or a visa.

Imtiyozlar

  • Remote-first work environment for US-based employees
  • Medical, dental, and vision coverage
  • 401(k) plan
  • 401(k) matching
  • Life and disability benefits
  • Unaccrued paid time off
  • 11 paid holidays
  • Employee discounts
  • Employee assistance program
  • Educational assistance program
  • Employee referral program
  • Paid parental leave
  • Potential equity upside

O‘xshash ish o‘rinlari

Constant Contact

Manager, Product and Data Analytics

Constant Contact

Lead product analytics and a team of analysts at Constant Contact, shaping measurement and product decisions. The role supports a company that helps businesses, nonprofits, and individuals grow online.

Ochish
EXL

Business Intelligence and Analytics Manager

EXL

Lead BI strategy, executive reporting, and GenAI-enabled analytics at EXL. Manage analysts and BI developers while overseeing data quality and responsible AI practices.

Ochish
Xcel Energy

Senior Business Functional Consultant, Customer Data Analytics

Xcel Energy

Advise Xcel Energy teams on customer data and reporting across utility business processes. Validate metrics, reports, and data products to support governed, self-service analytics.

Ochish