Arch

  • Excel & VBA Developer

    Entity Arch Insurance Group Inc (U.S.)
    Job Locations US-NY-New York
    Job ID
    2019-2537
    Business Segment
    Insurance
    # of Openings
    1
    Category
    Actuarial
  • The Position

    Actuarial Business Intelligence & Data Management

     

    The Excel/VBA Analyst will support the business intelligence / reporting / analytics capabilities of the Actuarial department through developing and maintaining Excel/VBA-based solutions for both the Pricing and Reserving functions. The role will provide advanced technical skills in the design, building, and maintenance of solutions. The role will also provide efficiency improvements to routine data-centric workflows by introducing programmatic process automation.

    Job Responsibilities

    • Understand, evaluate, and document business requirements.
    • Translate business requirements into specific solutions.
    • Develop robust spreadsheet models with clearly defined inputs, calculations, and final output.
    • Provide documentation including data flow mapping for new and existing spreadsheet models.
    • Author SQL queries to extract data from corporate sources for actuarial analysis & reporting.
    • Develop automated and reusable routines for extracting information from various data sources.
    • Utilize VBA in new and existing Excel-based tools to automate recurring work processes.
    • Integrate capability in Excel-based tools to both pull and push data from/to SQL Server.
    • Create data visualizations that communicate information effectively.

    Desired Skills/Experience

    • Familiar with agile processes and methodologies.
    • Microsoft Excel – Expert Level
      • Complex formula authoring, array functions, dynamic named ranges, pivot tables, data validation, conditional formatting.
      • VBA: familiar with Excel object model, authoring of procedures, user defined functions, code refactoring, performance optimization.
      • Dynamic dashboard design, leverage Excel charting capabilities.
      • Knowledgeable in best practices of spreadsheet design.
    • SQL Server
      • Familiar with relational databases.
      • Comfortable writing SQL queries utilizing aggregation functions and GROUP BY
      • Understand the different JOIN types.
    • PowerBI / Power Pivot
    • Power Query (Excel Get & Transform)
    • Knowledge of data visualization best practices.
    • Strong project management skills, including ability to work to deadlines and give realistic estimates.
    • Strong problem solving & analytical skills.
    • Excellent written and oral communication skills, and interpersonal skills.
    • Ability to relay technical information to non-technical users.

    Education

    Required knowledge & skills would typically be acquired through a bachelor’s degree and 4-6 years of related experience.  Experience in the P&C Insurance industry is strongly preferred.

    Options

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