Adam Lee Email & Phone Number

Longmont, CO, US

As a Senior Data Engineer, I oversee the development and maintenance of over 1000 data models, ensuring they align with business goals. I manage the entire ELT process, integrating data into our warehouse, transforming it, and serving it through BI tools. My role includes owning and maintaining data synchronization between systems like Snowflake, Zuora.

I performed back end programming for a data-driven website where I managed the ingestion, cleaning and processing of hundreds of datasets. I have designed and developed several processes to programmatically ingest data from publicly available sources, clean the data, perform calculations, and output the data to a SQL database. Using programming tools such.

I was a core member of the Coronavirus Resource Center (CRC) team working on various data analysis, data management and data visualization projects. Using ArcGIS products and Python I managed the US Map COVID dashboard's maintenance and updates for both web and mobile. I maintained and developed the code of many of the CRC's visualizations ensuring data.

Boston, MA

• Utilize ArcGIS Online to create interactive maps that visualize state and federal advisory levels for specific drinking water contaminants to aid in a lawsuit regarding Per- and polyfluoroalkyl substances (PFAS).
• Collect publicly available data such as the National Hydrography Dataset, TIGER, and several others.
• Geocode relevant data using Esri’s World Geocoding Service.
• Create animated maps using ArcGIS Pro to effectively display spatial-temporal datasets.
• Develop tools with python to automate data management and tabular data analysis.
• Manage a team of consultants by coordinating schedules and responsibilities, delegating and supervising tasks, offering mentorship and providing support when needed.

Worcester, MA

• Digitized small-scale projects using digitizing techniques.
• Contributed various visualizations to emergency action displaying optimal egress paths for events such as fire drills and graduation ceremonies.
• Created maps displaying how contamination would spread over time in the event of a containment failure during secure removal of a radioactive source.
• Maintained biological and chemical safety in research laboratories by conducting inspections, responding to safety emergencies, and providing relevant trainings.
• Coordinated with the FBI to conduct security risk assessments for individuals seeking access to high containment level laboratories
• Ensured compliance with safety and security standards set by agencies such as CDC, NIH, and OSHA

Washington, District Of Columbia, United States

• Responsible for the collection of soils data from 59 different locations throughout the National Capital Region Network
• Analyzed data and determined relationships between different soil properties
• Completed field work, lab work and data entry at the Center for Urban Ecology
• Developed and revised soil monitoring protocols for future soil monitoring interns
• Completed various safety training sessions and trained in operational leadership
• Studied local vegetation and their relationship to soils

Master Of Geographic Information Systems, Geographic Information Systems

Bachelor Of Science - Bs, Environmental Science And Technology

Concentration in Ecological Technology Design