cv

About me

Full Name Jennifer (Jenna) Jordan
Job Title Data Engineer
Citizenship USA

Skills

  • Languages: python, SQL, git, bash, YAML/YAQL, regex, Xpath
  • Libraries/Packages: dbt, pandas, plotly, SQLAlchemy, Great Expectations
  • Other Tools: postgreSQL+postgis, GitHub, Civis Platform, Jira
  • data modeling & architecture/design - 3rd Normal Form, ER Diagrams, star schema, etc
  • creating and managing ETL/ELT pipelines; data orchestration
  • data wrangling, visualization, and exploratory data analysis
  • teaching workshops; writing documentation; presenting projects

Experience

  • Jan 2022 - present
    Data Engineer
    Analytics Team, Department of Innovation & Technology, City of Boston
    • Manage the data warehouse and ETL pipelines for the City of Boston's Analytics Team.
    • Write custom component scripts in python to ingest and export data.
    • Transform data using SQL and write data unit tests using Great Expectations.
    • Ensure the analysts have high quality, reliable data for analytics end products (e.g. dashboards) and the public has up to date access to open data published on Analyze Boston.
    • Initiated, planned, and managed the execution of an ETL workflow redesign that centered on implementing dbt within a new set of schemas.
  • Jan 2021 - Nov 2021
    Data Engineer, Computational Methods Instructor (Contractor)
    Network Contagion Research Institute (NCRI)
    • Built ingest pipelines (with Python) and designed relational databases for the data to add new social media communities (Telegram, 4-chan) to Pushshift in order to support NCRI's mission of identifying disinformation and extremism on social media.
    • Ran the Computational Methods group for interns at NCRI Labs (Summer and Fall 2021 semesters)
      • Designed a semester-long curriculum for computational skills.
      • Taught weekly workshops on Bash, Git, Python, SQL, and regex (using the Software Carpentries lesson plans).
      • Supervised independent projects.
  • Sep 2020 - Apr 2021
    Marketing Data Analyst (Contractor)
    Bright Wolf
    • Organized, managed, visualized, and analyzed marketing-related data; supported & audited email campaigns.
    • Built a data pipeline that integrated data from Salesforce, EverString (now ZoomInfo), and other sources into one cohesive relational database, and then used that database to power a dashboard that visualized the available data for potential corporate clients. Utilized the Streamlit, Plotly, and SQLAlchemy Python libraries.
  • Aug 2019 - May 2020
    Graduate Research Assistant
    Cline Center for Advanced Social Research, University of Illinois at Urbana-Champaign
    • Supported the Cline Center with data releases by preparing/cleaning data, updating documentation, and coordinating with the data repository.
    • Promoted the Global News Index by preparing and helping to present tutorials.
    • Developed a user feedback process for Cline Center software applications and data releases.
    • Other support tasks as needed.
  • May 2019 - Jul 2019
    Data Science Intern
    The Program on Governance and Local Development (GLD), University of Gothenburg
    • Assisted the Data Scientist on data monitoring tasks for an ongoing survey (LGPI 2019) being conducted in Zambia and Kenya - for example, one data monitoring task was to make sure that enumerators completed the requisite number of surveys in each designated hectare, according to the sampling plan.
    • Wrote Python scripts to organize and wrangle data downloaded from SurveyToGo, edited surveys in SurveyToGo, worked with geospatial data using Python and QGIS, and helped to develop the Local Governance Performance Index based on data collected from the survey.
    • Worked extensively with large XML documents, and wrote custom scripts to extract data from KML files and reformat into WKT files.
    • Attended the 2019 Annual GLD Conference, which focused on the theme "Routes to Accountability."
  • Jan 2019 - May 2019
    Graduate Research Assistant
    Cline Center for Advanced Social Research, University of Illinois at Urbana-Champaign
    • Created user-friendly documentation for the Cline Center’s Global News Index using Adobe InDesign.
    • Wrote an in-depth codebook on the GNI’s variables and corpora, a detailed user guide and a quick-start guide on Archer (the in-house software developed to query the GNI) and a guide on using Solr to query the GNI.
    • Helped to test, document bugs, and suggest features for Archer (software application recently developed by the Cline Center), and assisted users in querying the GNI.
  • Sep 2018 - Dec 2018
    Research Assistant (graduate hourly position)
    iSchool, University of Illinois at Urbana-Champaign
    • Investigated and compiled a corpus on Data Management Plans (DMPs) for Prof. Peter Darch.
    • Annotated datasets for use in human-in-the-loop machine learning analyses performed by Prof. Jana Diesner’s research group.
  • Jun 2016 - Aug 2017
    English Teacher
    Corem Language Institue, South Korea
    • Taught English as a Foreign Language to Kindergarten and Elementary students in Yangsan, South Korea, at a private academy (hagwon). I taught an average of 8 40-minute classes each day.
    • My kindergarten students were 5-6 years old. In addition to teaching basic reading, writing, and conversational skills I taught fun math, science, and arts & crafts lessons. I also wrote bimonthly progress reports for each student, administered occasional tests, and helped to conduct monthly “phone interviews” with the students in the upper-level classes.
    • My elementary students were 7-12 years old. In addition to teaching language lessons, I was in charge of making and grading their tests and writing bimonthly progress reports for each student.
  • Jan 2014 - Apr 2014
    Intern
    U.S. Mission to the UN at Washington, DC (USUNW), U.S. Department of State
    • Worked as part of a small team advising the U.S. Ambassador to the United Nations Samantha Power, serving as a bridge between the United Nations, the Executive Office, and the National Security Council.
    • Supported the Senior Policy Advisors, Speechwriter, and Executive Assistant with research, copywriting, and administrative tasks.
    • Wrote executive summaries and took notes on office, cross-bureau, and inter-departmental meetings for the USUNW team.

Education

  • 2020
    Master of Science, Library and Information Science
    University of Illinois at Urbana-Champaign
    • 3.97 GPA
  • 2015
    Bachelor of Arts, Journalism, Political Science
    University of North Carolina at Chapel Hill
    • Graduated with Honors
    • 3.61 GPA

Certificates

  • 2022
    Analytics Engineering with dbt
    CoRise
  • 2020
    Software Carpentries Certified Instructor
    The Carpentries
  • 2016
    CELTA, Teaching English as a Foreign Language
    International House Budapest