Adam Koplik

Who I Am

My name is Adam Koplik. I’m a 23-year-old Hamilton College from New Paltz, New York, currently residing in Manhattan. I am a research and data analyst with experience spanning infrastructure-focused geospatial analytics projects, real estate economics, environmental research, financial modeling, and marketing analytics. Experienced in transforming complex spatial and public datasets into actionable intelligence using Python, R, SQL, Tableau, Excel, and AI-assisted workflows. Built convolutional neural networks (CNNs) for satellite imagery analysis, supported infrastructure development through geospatial analytics and data integration, and led QA/QC and process improvement initiatives to enhance data quality and operational efficiency. Strong researcher and technical communicator with a passion for uncovering complex information, improving research methodologies, and translating data into strategic insights.

My résumé is below along with a contact form. For info on all of my projects and my social feeds, go to the menu above. Thank you for taking the time to learn about me!

My Résumé

Work Experience

TerraPact

Senior Analyst, Data Intelligence September 2025 — Present

Manage strategic infrastructure investment projects using advanced data analytics and geospatial methodologies, overseeing remote vendor teams and leading quality assurance and quality control (QA/QC) efforts.
Developed a convolutional neural network (CNN) using satellite imagery to identify potential infrastructure targets significantly faster than previous methods, while implementing AI-driven workflows that automated external processes and accelerated data cleaning.
Led the integration of Salesforce and OneDrive data into a centralized remote SQL Server database, directing data migration, cleaning, and analysis to improve data accessibility and operational efficiency.

Murray’s Chicken / MB Food Processing Inc.

Marketing & Operations Analyst May 2025 — September 2025

Developed SEO and marketing strategies, testing copy and site structure changes to improve search visibility and customer engagement.
Built internal dashboards in Excel and R to forecast sales and track performance against operational targets.
Analyzed customer and web traffic data to inform targeted outreach and marketing content.

View Project →

Quantitative Financial Analyst May 2024 — Aug 2024

Created a financial simulation model in R to forecast how changes in feed prices would impact gross profit margins.
Built interactive dashboards in R Shiny to visualize scenarios for hedging and pricing decisions, used by executives and an external hedging partner.
Modeled commodity price trends using time-series forecasts to guide procurement timing and maintain cost stability.

View Project →

Hamilton College

Environmental Data Science Research Assistant June 2023 — May 2024

Co-authored a peer-reviewed publication on Arctic land cover change using satellite data and deep learning.
Built and trained convolutional neural networks (CNNs) for geospatial classification tasks in R and Python.
Conducted statistical modeling and image analysis to evaluate environmental risk over time.

View Project →

Ulster County Government

Climate Data Analyst Jun 2023 — Aug 2023

Co-led a team of 18 interns, overseeing eight environmental projects from concept to presentation for the county’s state senator.
Designed ArcGIS dashboards to consolidate data on recycling, renewable energy, and public transportation initiatives.
Incorporated demographic and health metrics to highlight community benefits and inform policy recommendations.

View Project →

Diamond Digest

Staff Writer, Analyst Oct 2018 — Present

Produce analytically driven baseball content, including advanced metrics analysis for MLB teams.
Co-manage social media account with 6,000+ followers; contribute to podcasts and live broadcasts.