Jacob Hampton Email & Phone Number

Springfield, Ma, Us

Hartford County, Connecticut, United States

Agawam, Massachusetts, United States

Automated data ingestion, validation, and metadata collection using Python and SQL. Translated complex business requirements from stakeholders into technical specifications and developed automated solutions.- Oversaw the initial development and maintenance of dozens of different Python-based data pipelines. Ingested millions of rows of data from cloud-based, relational database, and JSON sources into on-prem SQL databases to support downstream analytics processing.- Reverse engineered complex legacy reporting applications by refactoring SQL from temp tables and CTEs to simplified queries optimized for real-time analytics. - Played a pivotal role in ingesting a wide array of data from across the organization and refactoring it into Kimball-style models.- Ensured data pipeline scalability by writing modular and well-documented Python, designing metadata management schemas such as write and error logs, and catching edge cases with error-handling.

Windsor, Massachusetts, United States

Advised the Windsor Conservation Commission on state regulations and proposed solutions to mitigate/replicate wetland and resource area impact.

West Springfield, Massachusetts, United States

Maintained, expanded, and leveraged public works datasets using SQL and Python to provide insight and actionable recommendations to stakeholders.- Developed 32 different Python scripts to automate data management, validation, and analysis workflows saving hundreds of hours of manual work.- Leveraged Python and SQL to create custom asset management systems that performed calculations on asset condition and provided replacement candidates in support of a $50 million paving budget.- Assisted with managing data replication from to and from on-prem databases and AWS RDS to ensure data security.- Oversaw the initial version control rollout to hundreds of scripts and queries by creating the Department’s first git repositories.- Performed exploratory analysis and QA/QC on all new datasets from external sources related to town assets prior to import.

Westfield, Massachusetts, United States

• Tutored students in Intro to GIS, Advanced GIS, and Physical Geography

Livingston, Mt

• Worked independently in remote locations with ranchers across Montana to acquire soil samples • Reviewed sample quality to ensure accurate testing results and analyzed soil samples in lab• Helped to develop standardized sampling procedure• Assisted instruction in soil workshops to provide civil engineers with state soils certification• Utilized GIS software to map sampling locations and transfer data to handheld GPS

Westfield, Ma

• Promoted to supervise front-end, count cash drawers, and wire money internationally• Prepared managerial reports and coordinated messages between departments and other stores

Bachelor Of Science - Bs, Geography (Cum Laude)

Concentrated coursework in statistical analysis of geospatial data.

Certificate, Geographic Information Systems

Concentrated coursework in data analysis and spatial data.

Associate Of Arts - Aa, Liberal Arts And Sciences (Cum Laude)