Business Intelligence Analyst

$70,000 - $80,000/Yr

Euclid Insurance Agency - Itasca, IL

posted 4 months ago

Full-time - Entry Level
Remote - Itasca, IL

About the position

Euclid Mortgage is a startup company specializing in providing turnkey access to highly profitable and diversifying mortgage credit risk and capital solutions for cedents of mortgage credit risk. It is led by a team with over 40 years of experience in the mortgage credit risk industry providing top-notch service. Euclid Mortgage is an affiliate of Euclid Insurance Services Inc. (EIS), an award-winning platform based out of Itasca, Illinois that delivers large company capabilities in a privately owned, responsive environment for our partners, employees, brokers, carrier partners, and policyholders. The Business Intelligence (BI) Analyst is responsible for creating next-generation analytics, dashboards, and reports that support the business in communicating housing economics and reinsurance partner financial positions. On a day-to-day basis, the BI Analyst will join disparate data sources, perform analysis, build and maintain dashboards that visualize complex data to deliver valuable insights that drive business decisions. The BI Analyst will also perform data review, report updates, basic quantitative analysis, quality assurance, and project document editing. This person will support and contribute to the reporting strategy and guide users through the visual transformation via interactive and intuitive visual designs. This work is crucial to the final work product we submit to our clients - we need your passion for user-centered design that makes data easier to understand. Much of the BI Analyst's work will be done in manipulating data sets in R and Excel, conducting exploratory analysis and modeling in Excel, and delivering results through user-friendly PowerBI dashboards. Prior mortgage (re)insurance experience is beneficial but not required: we will teach you the key concepts of analyzing and forecasting insurance premium and loss cashflows.

Responsibilities

  • Create next-generation analytics, dashboards, and reports to support business communication of housing economics and reinsurance partner financial positions.
  • Join disparate data sources and perform analysis to build and maintain dashboards that visualize complex data.
  • Conduct data review, report updates, basic quantitative analysis, quality assurance, and project document editing.
  • Support and contribute to the reporting strategy and guide users through visual transformations via interactive designs.
  • Manipulate data sets in R and Excel, conduct exploratory analysis and modeling, and deliver results through PowerBI dashboards.

Requirements

  • Bachelor's degree in a related field such as statistics, finance, economics, or business.
  • Demonstrable quantitative work experience including data visualization and analysis that supports business pro forma.
  • Working knowledge of how macro-economic indicators influence business decisions utilizing statistical techniques such as regression models.
  • Experience manipulating large data files in csv format, and analyzing them in SAS, R, or Python.
  • Familiarity with data structure, relational and non-relational databases, big data concepts, cloud computing, and data optimization techniques.
  • Substantial professional experience using MS Excel (filter, sort, summarize, pivot tables, financial functions, visualization methods).
  • Experience developing dashboards and reporting solutions such as PowerBI or Tableau.
  • Experience using MS PowerPoint, Outlook, Teams, and Word.

Nice-to-haves

  • Prior mortgage (re)insurance experience is beneficial but not required.
  • Strong communication skills - both in-person and written.
  • Ability to translate ideas and business requirements into business solutions.
  • Intellectual curiosity about insurance risk and the work of the company.

Benefits

  • 401(k)
  • 401(k) matching
  • AD&D insurance
  • Dental insurance
  • Disability insurance
  • Flexible spending account
  • Health insurance
  • Health savings account
  • Life insurance
  • Paid holidays
  • Vision insurance
  • Remote position with one day per week in office
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service