An automated offset well analytics engine generates offset well rankings for a prospect well. The engine aggregates data for offset wells and the prospect wells is across multiple disparate data sources corresponding to a user-specified scope. The engine generates features comparing the offset wells to the prospect well are using a combination of machine-learning based models and risk analysis. Offset wells are ranked by feature and further ranked across features using a weighted feature ranking map. Feature weights are iteratively trained using a reinforcement learning model in a feedback loops with a well expert. A prospect well casing schema and bottom hole assembly is designed using automatically generated offset well rankings.