# Nicholas Pena > Software Engineer at Foursquare Location: Brooklyn, New York, United States Profile: https://flows.cv/nicholaspena ## Work Experience ### Software Engineer @ Foursquare Jan 2021 – Present | New York, New York, United States ### Data Engineer Fellow @ Insight Data Science Jan 2019 – Jan 2019 | Greater New York City Area - Developed a data pipeline to aggregate the number of occurrences of words from web pages so that advertisers can determine which topics trend over time - Designed a web interface using Flask to allow users to query the frequency of over 370,000 English dictionary words, and submit requests for non-dictionary word queries using Airflow - Utilized AWS and Spark to process about 1TB of web pages from the Common Crawl dataset - Partitioned data from 2018 through the use of PostgreSQL and TimescaleDB to optimize read/write functions ## Education ### Bachelor's degree in Computer Science New York University - Polytechnic School of Engineering ## Contact & Social - LinkedIn: https://linkedin.com/in/nicholaspena - GitHub: https://github.com/dragontail/InsightProject --- Source: https://flows.cv/nicholaspena JSON Resume: https://flows.cv/nicholaspena/resume.json Last updated: 2026-04-13