Data Analyst/Engineer

Cleveland, Ohio
Not Specified
Oct 02, 2016
Dec 01, 2016
Job Type
Not Specified
Career Level
Not Specified

Title_Data Analyst/Engineer_

About the OrganizationAmTrust Financial Services, Inc., (Nasdaq: AFSI) headquartered in New York City, is a multinational insurance holding company, which, through its insurance carriers, offers specialty property and casualty insurance products, including workers' compensation, commercial automobile and general liability; extended service and warranty coverage.

PositionData Analyst/Engineer

LocationOH, Cleveland

DescriptionThe data analyst is responsible for corporate wide reporting. This includes, but is not limited to reporting of premiums and losses at various levels of details. Position works with multiple departments through-out the company, such as finance, accounting, underwriting, and compliance, as well as with external partners, such as managing general agencies, statistical bureaus, and various state departments of insurance

Open Date6/30/2016

Position Requirements+ In depth knowledge and experience of SQL scripting language of at least version 2000 or better (2008 R2 or better preferred).Examples:
  • Know how and when to use all joins (inner, right/left/full outer, cross)
  • Know how and when to use cursors and loops
  • Know how and when to use various forms of sub-queries and temporary tables
  • Ability to new technology and business practices is a must
  • Ability to adapt to changes in business requirement and priorities a must
  • Should have enough exposure to be functional with:
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • SQL Server Analysis Services
  • Strong Ability to use Excel - Pivot Tables, PowerPivot
  • Knowledgeable of ETL Practices and Concepts
  • Knowledgeable of Transactional and Multi-Dimensional Databases, Data Warehousing, Star and Snowflake Schemas
  • Must be self-motivated and to be able take ownership of projects and processes
  • Knowledge of OLAP Cubes, Insurance Industry Practices or Financial Reporting a plus.
  • Must have a strong attention to detail.
  • Strong mathematical skills a plus.


    Req NumberINF-16-00021


    Number of Openings1

    Employee Referral Eligible

    Employee Referral PayoutThis position is currently accepting applications.