Business Data Analyst II at AmTrust Group in Dallas, Texas

Posted in Other 13 days ago.

Job Description:


The Business Data Analyst performs analysis, reporting, data modeling, cleaning, and validating of data for the various business and operations divisions of the organization with the purpose of understanding or making conclusions to facilitate effective business decisioning. Daily work includes partnering with various Account Management teams to define Reporting and Project requirements, data analytics and processes to support decision making, program performance and innovation. This work also includes creating the business reporting to illustrate the impact of a decision or its alternatives on organizational performance as measured by profitability and efficiency.

The Analyst is detail oriented and intellectually curious, with strong analytical and project management skills. The Analyst will have a core skill set in business intelligence and reporting (what do we need, where can we get it from, how can we verify data quality) and analysis (design and execution of Excel/ Power-pivot-based analyses that translate business insight needs into thoughtful analysis). Ability to create dashboards to report results and findings.


  • Serve as the subject matter expert on the Account Management team for the Major Account's data and data processes.

  • Interpret data, analyze results using statistical techniques and develop Product monthly Program KPI reports to support internal and external business needs.

  • Prepare periodic reports and dashboards to support account management.

  • Identify, analyze, and interpret trends or patterns in complex data sets, support all data processing requirements, including coordinating with internal/external stakeholders regarding the successful transportation, processing, assignment and reporting of all transactional data.

  • Apply robust analytics (intellectual and software-driven) to the data and program's performance to identify trends, challenges, opportunities and strategies to manage losses, improve administration/ reporting, and increase revenue generation for the client and AmTrust.

  • Champion and manage initiatives that will improve the quality of our data and/or data processes

  • Support new projects and development of pricing and service solutions for team, participate in all program rating initiatives, rate implementation and rate audit requirements and initiatives.

  • Heavy data mining using SQL, Excel, Access, PowerBI and SAS or other BI Reporting tools.

  • Perform analysis of complex data to support customer requests and management reporting.

  • Forensic Auditing

  • Develop recommendations regarding data quality, pricing, losses, and impact analysis.

  • Participates in production implementation, verification and accountable for validating particular enhancements.

  • Responsible for determining test requirements based on project specifications.

  • Plan, document, evaluate and track testing results to ensure proper operation and freedom from defects.

  • Do preliminary analysis to determine sources of discrepancies between actual and expected results.

  • Communicate and interact with appropriate areas on changes and enhancements that may impact data, workflow and functionality

  • Provide support in testing/validating new changes

  • Identify opportunities to improve data warehouse



  • Bachelor's degree in mathematics, engineering, statistics or related field required

  • 3 + years performing complex data analysis

  • Experience in Business Intelligence in the Insurance, Auditing, Underwriting beneficial

  • Moderate to strong SQL experience

  • Proficiency using Microsoft Office (specifically Excel, Access, PowerPoint, Power BI), SAS Reporting Tools

  • Experience with Microsoft SQL Server, preferred

  • Ability to solve complex problems

  • Excellent analytical, communication and organizational skills.

  • Must be able to communicate effectively and confidently with project team members and management.

  • Knowledge of Business Intelligence and Property & Casualty insurance preferred.

  • Bachelor's degree or equivalent business experience.

  • Flexible team player who can work in a fast paced environment where ambiguity exists and priorities are subject to change.

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.

More jobs in Dallas, Texas

about 2 hours ago

Southern Methodist University Inc
about 2 hours ago

Southern Methodist University Inc
about 2 hours ago

MV Transportation
More jobs in Other

2 minutes ago

Akima, LLC
3 minutes ago

Orkin LLC
12 minutes ago

Northwest Exterminating Co LLC