Software Developer - Actuarial

Entity Arch Insurance Group Inc (U.S.)
Job Locations US-NJ-Jersey City
Job ID
Business Segment
# of Openings

The Position

The BI Developer will support the business intelligence / reporting / analytics capabilities of the Actuarial department through developing and maintaining solutions in a variety of platforms primarily involving the modern MS BI stack (SSAS Tabular, Power BI, Excel-based Power Pivot). The role will provide advanced technical skills in the design, building, and maintenance of solutions.  

Job Responsibilities

  • Design, develop and maintain end-to-end Business Intelligence and reporting solutions for the Actuarial department.
  • Understand, evaluate, and document business requirements.
  • Translate business requirements into specific BI solutions.
  • Perform data modeling, database design and ETL development.
  • Author complex measure expressions to meet business needs.
  • Database maintenance: security roles, recovery models & backups, performance monitoring.
  • Develop automated and reusable routines for extracting information from various data sources.
  • Ensure integrity of data collection and utilization.
  • Perform quality assurance checks on new or enhanced reports.
  • Create data visualizations that communicate information effectively.
  • Continual development of technical knowledge by reading technical articles & attending webinars.

Required Skills/Experience

  • Experienced with agile processes and methodologies.
  • SQL Server RDBMS
    • Experience with relational database structures, including fully normalized operational databases, as well as dimensional databases, data warehouses/marts.
    • Designing and creating database objects: tables, views, stored procedures, functions.
    • Maintaining security roles, recovery models & backups, performance monitoring.
  • SSAS Tabular / Power BI / Power Pivot
    • Design tabular data model to maximize usability and performance.
    • Implement advanced measure calculations, relationships, hierarchies, perspectives
    • Create dashboards with visualizations that communicate information effectively.
  • Data acquisition and transformation (ETL): SSIS package authoring, Power Query, Data Flows
  • Microsoft Excel – Expert Level
    • Advanced formula authoring, array functions, dynamic named ranges, pivot tables, data validation, conditional formatting.
    • Integrate BI model with Excel via pivot table and CUBE functions.
  • Strong project management skills, including ability to work to deadlines and give realistic estimates.
  • Excellent written and oral communication skills, and interpersonal skills
  • Ability to relay technical information to non-technical users
  • Strong problem solving & analytical skills.

Desired Skills/Experience

  • 8+ years of related experience.  Experience in the P&C Insurance industry is strongly preferred


  • Required knowledge & skills would typically be acquired through a bachelor’s degree in computer science or a related field plus 

The Company

Arch Insurance is a global insurer offering our clients superior coverage and service. We embody the Arch guiding principle of focusing on retaining experienced and talented employees to differentiate us from the rest of the pack. Our group operates from offices in the US, Canada, Bermuda, UK, and Australia, providing specialty risk solutions to clients worldwide across a wide range of industries. With over ten years of operating history and strong financial ratings, our track record remains solid.


Arch Insurance employs a disciplined underwriting approach and prudent risk selection across all types of business. Our mission is to provide our insureds with superb coverage and claims handling through careful and diligent underwriting of risks and business-friendly solutions. Across our global operations, Arch Insurance employees are ready to meet your needs with professionalism and excellence.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed