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 

#LI-LM03
#LI-hybrid