CV
Jenna Jordan
Data & Analytics Engineer working in civic tech. Bringing Library & Information Science practices to the modern data world. Improving data processes in the public sector through dbt and data engineering best practices, while always putting people before process & technology.
Experience
remote
Building dbt projects for public health initiatives and Health & Human Services organizations
- Monitoring data quality for the NYHER program at New York State Department of Health
remote
Mentoring and providing support to student teams at BU Spark! working on public interest projects. I also teach a git/Github workshop each semester as the students kick off their projects.
remote
Built and supported data mesh implementations with dbt; advised on dbt Mesh best practices, strategic processes to support data governance and its implementation within dbt, and provided training for key skills in implementing dbt Mesh.
remote
Worked with a mission-driven healthcare organization as they migrated their legacy monolith dbt project to a dbt mesh architecture of multiple domain-driven projects
Boston, MA
- Initiated & led the engineering team’s migration of ~200 legacy ETL pipelines to dbt, with redesigned orchestration workflows & data warehouse schemas. This resulted in the team’s first data catalog, jumpstarted data governance efforts, provided oversight over and analysis of both pipelines and data, and improved the use of both computational resources and engineers’ development time. I then presented and advocated for this work to the team, the CIO, the department, and at a conference
- Built out custom ETL pipelines to integrate data trapped across many different sources, enabling key metrics to be tracked (e.g. time for affordable housing projects to be approved) and complicated manual processes to be automated (e.g. joining together permitting, housing, and development data)
- Advised on structural & process changes to involved source systems across different departments
- Wrote custom component scripts in python to ingest and export data
- Ensured the analysts had high quality, reliable data for analytics end products (e.g. dashboards) and the public had up-to-date access to open data published on Analyze Boston.
remote
- 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); and supervised independent projects
remote
- Built a streamlit web app to visually analyze Bright Wolf’s marketing data from Salesforce, email campaigns, and company data enrichment, enabling the sales team to see overarching trends
- Built the ETL pipelines to ingest data from these sources via APIs into a local database
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.
Gothenburg, Sweden
- 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."
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.
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.
Yangsan, 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.
Washington, DC
- 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
Champaign, IL, USA
Information Management
Chapel Hill, NC, USA
Majors: Journalism, Political Science
Graduated with Honors