Analytics Specialist - Database Design

Company: AmTrust Financial
Location: Cleveland
Posted on: May 31, 2025

Job Description:

Analytics Specialist - Database Design



Job Locations

US-OH-Cleveland






Requisition ID

JR1003250



Category

Analytics



Position Type

Regular Full-Time






































Overview









As a Data Engineer (Analytics Specialist), 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.













Responsibilities









Collaborates with stakeholders, data engineers, and data scientists to ensure analytics data needs align with organizational goals and priorities and elevate our business processes.

• Develops ETL processes to extract data from various sources, transform it into a format suitable for analysis across AmTrust.
• Create moderately complex data models that describe the relationship between different data entities. Develop database schemas that are optimized for querying and analysis.
• Design advanced validation and cleansing processing to identify and fix data quality issues for quality and accuracy of the data throughout
• Medium-to-Advanced level understanding of business processes of a variety of areas in the company including finance, operations, underwriting, sales, claims, and actuarial to develop a deep understanding of the workflow and the relevant data to produce insights for the larger organization.
• Work with IT resources to integrate data warehouse data, test and validate report building, process automation, and dashboard development.
  
  
  
  
  
  
  
  
  
  
  
  
  
  Qualifications
  
  
  
  
  
  
  
  
  
  

• 5-10 years minimum experience writing SQL, DAX, SSAS, and creating SSIS Packages
• Knowledge of Software Development Life Cycle, Git, Agile
• Undergraduate degree in Computer Science, Information Systems, Engineering, or equivalent years of work experience.#LI-NS1#LI-HYBRID#AmTrust
  
  
  
  
  
  
  
  
  
  
  
  
  
  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.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Connect With Us!
  
  
  
  
  Not ready to apply? Connect with us for general consideration.
  
  
  
  
  
  
  
  
  
  
  
  
  

Keywords: AmTrust Financial, Cleveland Heights , Analytics Specialist - Database Design, IT / Software / Systems , Cleveland, Ohio