Andrew Williams

Data & Visual Journalist A Get to Know Me

Hello, My Name is Andrew!

I'm a Data Journalist and Graphics Reporter at NBC and a graduate of the M.S. in Data Journalism program at Columbia University's Graduate School of Journalism. I graduated summa cum laude (highest distinction) from Indiana University with a major in Informatics, a cognate in Journalism, and two minors in Human-Centered Computing (HCI) and Interactive & Digital Media.

I strive to produce journalism stories with a focus on data-driven, interactive, and visual storytelling, and I aim to create digital content that simplifies complex information to promote intuitive user experiences.

In the past, I've been employed by The Wall Street Journal as a Graphics Intern, NBC News as a Data Journalism Intern, and Indiana University's Arbutus Yearbook and Indiana Daily Student as Editor-in-Chief and a photojournalist/videographer. I've also worked as a web developer and UX designer for IU Strategic Communications where I redesigned websites for the university like the Office of First Year Experience Programs, Hoosier Link and the "We Are IU" blog which details the IU experience for incoming freshmen through the eyes of students at Indiana University.

My Work

I'm looking to expand my portfolio while I'm on top and while I'm young.

What I Do

I love what I do. I take great pride in what I do. And I can't do something halfway, three-quarters, nine-tenths. If I'm going to do something, I go all the way.

UX Design

I've conducted user testing on a variety of topics with the use of Sketch, XD and InVision. My UX background assists with the creation of interactive graphics and stories.

Virtual Reality

With the use of Unity and Blender, I make virtual reality scenes and create 3D models. I believe that VR is an emerging trend that will soon be commonplace in news reporting.

Graphics & Data Viz

Tools like D3, Illustrator, Mapbox and InDesign help me to create award-winning page designs and graphics.

Reporting

I've done data reporting and analysis at the Wall Street Journal and NBC News. I've worked as a print and digital reporter for the Arbutus Yearbook and the Indiana Daily Student.

Web Development

My main job for Indiana University was the development and user testing of new websites for the university’s orientation and transfer programs.

Photo & Video

My photo and video production experience spans over a decade. I've managed a staff of photographers and was the editor of an ACP, CSPA and ICPA award-winning yearbook.

Research

Failure will never overtake me if my determination to succeed is strong enough.



Computer Ethics Thesis

For my undergraduate thesis at Indiana University, I tackled the ethical implications of consumer genetic testing from companies like 23andMe and AncestryDNA.

The popularity of these tests could leave eager consumers open to future genetic discrimination in education and insurance.

Law enforcement is now also taking advantage of these databases. In early 2019, FamilyTreeDNA gave the FBI full access to its database. 60 percent of Americans of European descent can be identified through their database.

View Project

Resume

If you call failures experiments, you can put them in your resume and claim them as achievements.

Education 2011 - 2020
2019 - 2020

I completed an M.S. in Data Journalism at Columbia University's Graduate School of Journalism. I produced stories with a focus on data-driven, interactive and visual storytelling, and created digital content that simplifies complex information to promote intuitive user experiences.


My master's project was an interactive and data driven story about data breaches and the harm they inflict on victims.

2015 - 2019

Graduated Summa Cum Laude (Highest Distinction)

Major: Informatics – Journalism (Cognate)
Minors: Human Centered Computing, Interactive & Digital Media

Indiana University Student Association (IUSA) – Congressman • Cox Scholar • Hudson & Holland Scholar • Dean's List • Phi Eta Sigma Collegiate National Honor Society – Social Committee • NAACP – Chair of Criminal Justice • All Campus Concert Band / Jazz Ensemble • Eigenmann Community Outreach Council • IU Student Media • National Association for Black Journalists (NABJ) • National Society of Black Engineers (NSBE) • IU Animal Club • Center of Excellence for Women in Technology (CEWiT)

2011 - 2015

Marching Band – Brass Section Leader • Drama Club – Stage Manager • Yearbook & Newspaper – Editor-in-Chief • National Honor Society • Outstanding Citizenship Award • Presidential Academic Excellence Award • Top Student in AP English Department • Art Club • Concert Band • Jazz Band

Work Experience 2010 - Now
2021 - Now

Responsibilities:
• Produce graphics and internal tools for 20+ local NBC, Telemundo and NBC Sports newsrooms nationwide using tools like D3, ai2html, React and Blender
• Gather, clean and analyze data using web scraping, APIs, Python and Google Sheets
• Independently report investigative data/viz stories concentrated on major cities that our newsrooms cover
• Create and edit wireframes and mockups in Illustrator for interactive data projects
• Handle multiple visual, tracker and data requests using Slack, GitHub and Teams for quick-turn events and breaking news stories like Uvalde, Olympics and Roe v. Wade

2020 - 2021

Responsibilities:
• Produced data and investigative stories for Dateline, Nightly News, Today and Digital. Filed a series of FOIAs to obtain data from police departments nationwide.
• Shot remote interviews and gather footage from archives for broadcast pieces. Generated stories for broadcast and digital using MediaCentral, iNews, Avid, NewsConnect and Latakoo.
• Researched mail voting and voting machines for Cynthia McFadden on NBC's Vote Watch and fact-checked the 2020 Presidential Election. Later gathered legal documents for NBC to cover Trump's post-Election Day litigation.

2020

Responsibilities:
• Created print and digital graphics in Illustrator, D3, three.js and internal data visualization tools
• Stationed on enterprise desk covering investigations, page one, arts and sports
• Performed data analysis and web scraping with Python, Selenium and Pandas
• Worked with product team on user testing and UX/UI design for WSJ products
• Co-wrote and developed a visual COVID-19 piece that became our top story for several days

2019

Responsibilities:
• Produced daily graphics for news stories using D3, ai2html and QGIS on deadline
• Pitched and reported stories by performing data analysis in Excel and Pandas
• Created breaking news and deadline graphics during presidential debates
• Built graphics for national stories on politics and natural disasters

2015 - 2019

Previous Positions: Managing Editor (2017 – 2018), Photo Editor (2015 – 2017)

Responsibilities:
• Managed a staff of 70+ writers, photographers and designers
• Designed spreads, graphics and developed layouts with InDesign and Illustrator
• Covered arts, politics and technology for campus and regional stories
• Captured and edited photos for news stories using Photoshop and Lightroom

2018 - 2019

Responsibilities:
• Conducted user testing to improve usability of websites for IU departments
• Updated, wireframed and redesigned websites for IU departments
• Coded university-wide HTML newsletters using Visual Studio Code
• Distributed communications on behalf of IU using Slate and Salesforce

2018

Responsibilities:
• Developed websites for government agencies using Drupal 8, Sass and Git
• Clients included the U.S. Fish & Wildlife Services and the U.S. Geological Survey
• Migrated backend database of clients' previous websites to Drupal 8
• Designed graphics and animations for client marketing and web content

2016 - 2018

Responsibilities:
• Managed, updated and redesigned website to fit university standards using Cascade CMS, HTML, CSS, JavaScript, jQuery and Bootstrap
• Updated website based on user testing from students, faculty and staff
• Designed print and digital content with Adobe CC (Photoshop, Illustrator, and InDesign) for university-wide advertising and web use
• Photographed campus and regional events for state-wide advertising campaigns and social media
• Produced exclusive content and managed IU FYE Twitter and Instagram accounts

2017

Responsibilities:
• Imaged and set up new computers, laptops, and printers for TCU employees and executives
• Performed security, software, and driver updates for TCU employees
• Managed and fulfilled IT service desk requests from staff to troubleshoot technical issues
• Conducted on-site installations of new computers, printers, and other office equipment at various TCU branches
• Completed IT audits on TCU branches throughout Indiana to track technical inventory
• Photographed new products for TCU intranet and front-end web use

2010 - 2015

Responsibilities:
• Assisted patrons daily with various library technologies
• Familiarized staff and patrons with library systems
• Organized and shelved books to maintain the library atmosphere

References

Testimonials are enough to convince people for now.

Indiana University: FYE

"Andrew has been a huge help in redesigning two of our websites. Without much instruction, he took to it and made the project his own."

Brittany Krieble Communications & Marketing Manager
IU Student Media

"Andrew is the one who trained me for photo desk when I first joined the Indiana Daily Student two years ago. Even now as Photo Editor, his dedication to perfection even under deadlines still amazes me."

Victor Gan Indiana Daily Student & Arbutus
Indiana University: OEM

"We’ve done multiple stories together since Andrew joined student media in 2015 and each one has been even better than the last."

Kayleigh Dance Digital Communications Coordinator

Technical Skills

A winner is someone who recognizes his God-given talents, works his tail off to develop them into skills, and uses these skills to accomplish his goals.

Art + Design Skills

Human behavior flows from three main sources: desire, emotion, and knowledge.

Awards

The accolades, just like the scrapes and bruises, fade in the end, and all you're left with is your ambition.

Columbia Scholastic Press Association (CSPA) Silver Crown, Best Design Portfolio Arbutus Yearbook 2018 & 2019
Indiana Collegiate Press Association (ICPA): 15+ Awards, including Best Yearbook, Best Design and Best Cover Arbutus Yearbook 2016, 2017, 2018 & 2019
Associated Collegiate Press (ACP): Pacemaker, Pacemaker Finalist, Best of Show Arbutus Yearbook 2016, 2017, 2018 & 2019
Scholar of Highest Distinction Indiana University (2015 - 2019)
Cox Scholarship Indiana University (2015 - 2019)