Skills and Experience

Education

Indiana University - Bloomington, IN
Master of Science, Data Science
May 2020 - August 2021 (anticipated)
Taking coursework in statistics, linear modeling, machine learning, probabilistic modeling, natural language processing, forecasting/time series modeling, linear programming, neural networks.

Webster University, St. Louis, MO
Bachelor of Science, Computer Science
Summa Cum Laude, 2017

Univerity of Missouri - Columbia, MO
Master of Arts, Journalism, 2012

Rockhurst University, Kansas City, MO
Bachelor of Arts, Psychology and Communication Theory
Magna Cum Laude, 2009

Skills

The vast majority of my work in recent years involves Python, R, SQL, Tableau, Power BI, QGIS and Excel. I’ve also used a variety of relational database managers, BI tools like SSIS, SSAS and DAX, and have used JavaScript for data visualization (particularly for making maps). And while I have not written a line of it in a few years, my undergraduate CS coursework was all in C++.

Experience

Senior Analyst, Bader Rutter

Milwaukee, WI. Aug. 2018 - May 2020

  • Developing measurement strategy and analyzing the performance of marketing campaigns across a variety of channels (display, paid search, email, etc.)
  • Writing Python and SQL scripts to automate the process of gathering, cleaning and standardizing datasets.
  • Building Tableau dashboards to visualize campaign results.
  • Performing ad-hoc analysis to evaluate campaigns and identify areas of improvement, typically using Python/Jupyter Notebooks or R for deeper analysis. (For example, building linear and logistic regression models, conducting time series analysis, using association rule learning for market basket analysis, or running statistical tests to evaluate results of A/B tests or sales promotions). Using QGIS or Tableau for mapping projects.
  • Collaborating with digital strategists, media planners and paid search specialists to use data-driven insights to guide strategy.
  • Presenting findings to internal teams as well as clients.

Business Intelligence Analyst, Johnson Controls

Milwaukee WI. Oct. 2017 - july 2018

  • Working with a variety of business units in the company to define business requirements, build data models and design interactive, analytic dashboards that allow managers to use data to improve decision-making.
  • Using Microsoft BI tools (SSMS, SSIS, SSAS, Power BI) to transform and analyze data and automate the process of regularly providing clear, actionable data to internal teams.
  • Writing Python scripts for various data cleaning and processing tasks.

Data Journalist, St. Louis Post-Dispatch

St. Louis, MO. May 2013 - Aug. 2017

  • Specialized in acquiring and analyzing datasets on a variety of subjects, a role that involved not just crunching numbers and producing charts and maps, but the researching, interviewing and writing that results in a final story.
  • Produced stories, maps, graphics and databases on issues including high-interest lending, real estate speculation, population trends, campaign finance, school performance and crime.
  • Regularly gathered datasets via public records requests and by using Python scripts to scrape websites.
  • Performed data cleaning and analysis using Python, R, Excel and SQL. Used Python to automate repetitive data processing tasks.
  • Built and published dozens of maps using QGIS and Leaflet, a JavaScript library.
  • Used Python to create automated alert systems that emailed reporters notifications about shootings, court filings, building permit filings, large commercial real estate transactions and political contributions.
  • Worked with newsroom developers (often serving as lead developer) to build web applications (mostly using Django), including a campaign finance app, school guide, public employee payroll site and a crime app.
  • Frequently collaborated with other reporters on stories and taught classes to train reporters to use Excel and other tools.
  • Designed and published interactive graphics using JavaScript, Tableau and DataWrapper.
  • Won numerous awards, including a company-wide award for digital innovation.

Business Reporter, The Tennessean

Nashville, TN. Sept 2012 - May 2013

  • Primarily covered technology, startups, venture capital and entrepreneurship at Nasvhille’s metro daily newspaper.
  • Frequently contributed to coverage of other issues on a small business team, including economic development, real estate and manufacturing.
  • Assisted other reporters with data analysis.