Curriculum vitae

Professional Experience

Gota Media, Karlskrona, Sweden

Data Journalism Editor, Aug ’21 – present

Sveriges Television, Stockholm, Sweden

Editor and Project Manager, Data Journalism, Jan ’18 – Jun ’21

Guardian News and Media, London, United Kingdom

Editor, Data Projects, Oct ’14 – Dec ’17

Sveriges Television, Stockholm, Luleå and Umeå, Sweden

Database Editor, SVT Pejl, Data Journalism and CAR team, Jan ’10 – Oct ’14
Database Editor, News and Investigative Programmes, Jan ’08 – Dec ‘09
CAR researcher, Rapport and Aktuellt (daily news program), May ’05 – Dec ‘05
Database Editor, News and Currents Affairs Dep, Jan ’04 – Jan ‘05
Editor (Umeå), Debatt (weekly debate program), Jun ’03 – Jul ‘03
Projects Editor (Luleå), Uppdrag granskning (investigative weekly) Aug ’02 – Dec ‘03
Assistant Editor/Head of research, Uppdrag granskning Jan ’01 – Jul ‘02
Assistant producer, Striptease (investigative weekly) Mar ’00 – Dec ‘00
Editor, Fittja Paradiso, (investigative talk show) Oct ’99 – Feb ‘00
Assistant producer, Striptease, Jan ’95 – Sep ‘99
Intern, Striptease, Aug ’94 – Dec ‘94

Working and creator of the first CAR-team in Sweden, supervise reporters and researchers on daily CAR and journalism projects. Work on investigative projects on everything from daily news to one-hour documentaries. Responsible for data and other content at svt.se/pejl, an online website presenting public data and CAR-stories. Introduced the concept of computer assisted reporting in Sweden, teaching reporters how to use databases to find stories. Became the first database editor ever in the country. Worked on numerous CAR-projects. Used the Swedish freedom of information act to obtain databases from governmental agencies, cleaning and analyzing them. Worked as an editor, supervised reporters and production teams and produced several live broadcasts.

The Center for Public Integrity, Washington DC

Database Editor, Jul ’06 – Nov ‘07
Assistant Database Editor, Jan ‘06 – Jul ‘06
CAR-Fellowship, Feb ‘05 – Apr ‘05

As the database editor I supervised a team of three highly skilled CAR specialists. I worked with reporters and project managers on stories for long-term investigative projects. Created, updated and maintained databases using Access, SQL Server and MySQL. Wrote scripts in Perl to parse and clean information for further analysis.

Sydöstra Sveriges Dagblad (daily), Karlskrona, Sweden

Page editor, summer temp ‘94 and ‘96

Lectures and work-shops

Give lectures and teach work-shops on investigative reporting and CAR for news organisations, universities and other journalism schools all over Scandinavia and Europe. Asked to consult outside my own organisation for several big CAR-stories, working with the best investigative reporters in Sweden. Trainer for the Swedish IRE in Excel and Access. Participated as a panellist and teacher at IRE and NICAR conferences since 2005.

Other Experience

Computer programmer and consultant

Time Air Information Systems AB, Helsingborg, Sweden, Aug ‘91 – Jan ‘93
Utvecklarna i Soft Center AB, Ronneby, Sweden, Jan ‘90 – Jul ’91
NovaCast AB, Ronneby, Sep ‘87 – Dec ‘89
Euroheat AB, Ronneby, March ‘87 – Aug ‘87

Programmed and consulted in areas including artificial intelligence, tax programs for house builders, and organizational tools for airline companies and travel agencies.

Computer Skills

MS Office, SQL Server, MySQL, PostgresSQL, Perl

Education

Göteborg University, Göteborg; Bachelor in Journalism, ’93 -‘94, ‘96, 2014
Elektronikcentrum, Svängsta; Computer programming and electronics, ’85 -‘87
Chapmanskolan, Karlskrona; High school, Science Major, ‘82- ‘85

Awards

Great Journalism Award, innovator of the year for Valpejl, www.valpejl.se, a website profiling all candidates for the Swedish Elections in 2010, and innovator of the year in 2016,  www.storajournalistpriset.se/english/
British Journalism Awards, Investigation of the year for Panama Papers, 2016, http://awards.pressgazette.co.uk/
Grävande Journalister (Swedish IRE), The main 25 investigative journalists in the last 25 years,  http://scoop.fgj.se/Inneh%C3%A5ll/Artiklar/tabid/256/Default.aspx?itemid=1612
Grävande Journalister (Swedish IRE), honourable mention for Valpejl, 2011, http://www.fgj.se/Guldspaden/Vinnarna/2010/tabid/330/Default.aspx
Society for Environmental Journalists, 1st place for Outstanding Online Reporting, Wasting Away: Superfund’s Toxic Legacy, 2008,http://www.publicintegrity.org/2007/04/26/5622/methodology
National Press Foundation, Excellence in Online Journalism (organization-wide), 2007
Society of Professional Journalists, National Awards for Non-Deadline Reporting and Public Service Journalism Online (Independent), 2007 for States of Disclosure, http://www.publicintegrity.org/accountability/waste-fraud-and-abuse/states-disclosure
CapitolBeat, Assocation of Capitol Reporters and Editors, Online In-depth Reporting, 2006 for Statehouse Revolvers, http://www.publicintegrity.org/2006/10/12/5900/statehouse-revolvers
Investigative Reporters and Editors, Online Finalist, 2006 for Power Trips, http://www.publicintegrity.org/2006/06/05/5928/methodology-team-power-trips