AmTrust Financial Services, Inc.

Business Intelligence Data Modeler

Job Locations US-OH-Cleveland
Requisition ID
Information Technology
Position Type
Regular Full-Time


As a BI Data Modeler, you will build robust data warehouse/marts/sets which will enable business users to make informed decisions. You will use advanced SQL tools to move large amounts of data and build complex algorithms.


  • Extract, Transform, & Load SQL data according to business requirements creating algorithms of varying levels of complexity
  • Build, maintain, support, & automate tables, views, stored procedures, SSIS packages, & SSAS cubes
  • Agile development with Git source control in Azure DevOps for builds, releases, project tracking, and documentation
  • Collaborate closely with team of developers and analysts, building sophisticated data analysis tools for executives and all areas of the business


  • 5 years minimum experience writing SQL and DAX, building SSAS cubes, and SSIS Packages
  • Knowledge of Software Development Life Cycle, Git, Agile
  • Exceptional technical writing skills
  • Ability to communicate complex data in a simple, actionable way
  • Excellent attention to detail
  • Ability to work independently and with team members from different backgrounds
  • Analytical and problem-solving skills
  • Bachelor's Degree in Computer Science, Information Systems, Statistics, Mathematics, or related fields


  • Knowledge of Power BI, Excel PowerPivot & PowerQuery, MDX, Collibra, Redgate tools
  • Familiar with acquiring data from various data sources (MSSql Server, REST APIs, Oracle DB)
  • Exposure to mathematics & actuarial analysis, statistical analysis & data science, accounting & financial reporting, and insurance industry practices.

What We Offer

What We Offer

AmTrust Financial Services offers a competitive compensation package and excellent career advancement opportunities. Our benefits include: Medical & Dental Plans, Life Insurance, including eligible spouses & children, Health Care Flexible Spending, Dependent Care, 401k Savings Plans, Paid Time Off.


AmTrust strives to create a diverse and inclusive culture where thoughts and ideas of all employees are appreciated and respected. This concept encompasses but is not limited to human differences with regard to race, ethnicity, gender, sexual orientation, culture, religion or disabilities.


AmTrust values excellence and recognizes that by embracing the diverse backgrounds, skills, and perspectives of its workforce, it will sustain a competitive advantage and remain an employer of choice. Diversity is a business imperative, enabling us to attract, retain and develop the best talent available. We see diversity as more than just policies and practices. It is an integral part of who we are as a company, how we operate and how we see our future.


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

Connect With Us!

Not ready to apply? Connect with us for general consideration.