Data Analyst

Marketstance Data Team PositionWe 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 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.ResponsibilitiesOperate and maintain data modeling and manipulation routines in a Microsoft SQL Server environment, predominantly consisting of Transact-SQL scripts and relational database objectsCreate data models, metadata, and conduct quality assurance for Marketstance products and consulting projectsLeverage knowledge of U.S economy to inform exposure estimatesEmploy dozens of government, industry regulator, and private firmographic datasetsUnderstand strengths, limitations, and scope of various data sourcesDevelop advanced understanding of insurance industry coverages, rating components, buying propensity, loss modeling, and regulationConduct secondary research related to commercial insuranceLeverage the world's largest repository of premium and loss data to assess market conditions and enhance Marketstance's product suitePresent research findings and data for internal and external clientsEnjoy breadth of exposure and strategic influence over projectsSpring 2026 graduates consideredQualificationsRequired:Undergraduate degree in a strong research and problem-solving field—economics, natural sciences, math/statistics, or computer scienceExperience writing queries with MS SQL Server or another relational database toolExcellence in technical/analytical writingAbility to work both collaboratively and independently, but without task-to-task oversightAbility to work tasks and projects with which you have little or no prior expertise or familiarityMS ExcelMS PowerPointPreferred:Actuarial, underwriting, or research experience in insurance, particularly commercial linesOther Desired Experience:MS SQL Server Integration ServicesR or SASPythonExperience with open-source GIS software and libraries