Data Analyst

We seek to fill a position on the MarketStance Data Team, transforming dozens of disparate data sources into a model of the U.S. economy and commercial insurance market. Your strong proficiency (2-3 years) programming in Microsoft SQL Server or similar relational database tool, interest in learning and applying knowledge about the U.S. commercial market, and great problem-solving skills in a scientific, mathematical, or analytical field outside of insurance will lead to success in this position.

• Operate and maintain data modeling and manipulation routines in a Microsoft SQL Server environment, predominantly consisting of Transact-SQL scripts and relational database objects
• Create data models, metadata, and conduct quality assurance for MarketStance products and consulting projects
• Leverage knowledge of U.S economy to inform exposure estimates
  • Employ dozens of government, industry regulator, and private firmographic datasets
  • Understand strengths, limitations, and scope of various data sources
• Develop advanced understanding of insurance industry coverages, rating components, buying propensity, loss modeling, and regulation
  • Conduct secondary research related to commercial insurance
  • Leverage the world’s largest repository of premium and loss data to assess market conditions and enhance MarketStance’s product suite
• Present research findings and data for internal and external clients
• Enjoy breadth of exposure and strategic influence over projects
• Spring 2026 graduates considered

Required:

• Undergraduate degree in a strong research and problem-solving field-economics, natural sciences, math/statistics, or computer science
• Experience writing queries with MS SQL Server or another relational database tool
• Excellence in technical/analytical writing
• Ability to work both collaboratively and independently, but without task-to-task oversight
• Ability to work tasks and projects with which you have little or no prior expertise or familiarity
• MS Excel
• MS PowerPoint

Preferred:

• Actuarial, underwriting, or research experience in insurance, particularly commercial lines

Other Desired Experience:

• MS SQL Server Integration Services
• R or SAS
• Python
• Experience with open-source GIS software and libraries