Learn Data Skills
Carlos Barrero

Carlos Barrero


Surrey County Council


My Portfolio Highlights

My New Course

Introduction to SQL

Quantitative architect, building solid foundations of insights with data.

My Work

Take a look at my latest work.


Introduction to SQL


Intermediate SQL


Joining Data in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Oxford City Council | Nov 2021 - Present

Corporate Data Analyst

-Provide support with various internal projects through the Businss Intelligence Unit (BIU). This includes the use of mapping and GIS software (ArcGIS), dashboards and visualisation using Tableau or MS Power BI, internal and public dataset analysis using methods such as SQL queries, MS Excel formulae. -Produce ad-hoc reports and analysis for various audiences based on internal and external request. E.g Census 2021, English Indices of Deprivation. These provide empirical evidence to support public policies, internal strategies and press releases. -Manage and update internal datasets, shapefiles and an online data warehouse (Local Insight). This includes allocating dataset to themes, uploading internal datasets, producing bespoke area reports and geographies, user management, and coordinating training for new users.
Show More

Oxford City Council | Sep 2019 - Nov 2021

District Data Analyst

Work closely with the district councils in Oxfordshire to deliver research-based analysis to support their local policies. Some of the core resposibilities of the this role are: -Assist the districts with data research on a variety of topics such as housing, attainment, transport and the environment. -Peoduce ‘charts of the month, bitesize reports in relevant areas of interest for the districts and the public. The reports are available at the District Data Service website. -Update the District Data website with the latest area profiles for every ward and parish in Oxfordshire. -Assist with ad hoc data queries from the public and district partners.

Oxfordshire County Council | Jul 2020 - Oct 2021

Insight Analyst

-Worked alongside the Research and Intelligence department in a variety of projects across Oxfordshire. Some of the key responsibilities of this role consisted on: -Supporting project leads with profiles for areas of interest in accordance with the nature of the projects. -Supplying evidence-based data for other areas across the Council to complement internal records and other documents. -Managing online data warehouse and kept it updated. -Giving professional training for fellow analysts on a number of analytic tools.

Oxford Brookes Business School | Aug 2018 - Jul 2019

Module Assistant

Assisted lecturers at the Oxford Brookes Business School in a series of administrative tasks to improve productivity and quality of lectures. Some of the key responsibilities of this role were: -Organising and collating teaching materials. -Arranging room bookings. -Helping teachers with attendance recording and filing. -Allocating large amounts of students into sets, times, and file changes in the Business Schools recording software (Moodle). -Recording academic feedback from students on the quality of the lectures and their overall experience.

My Education

Take a look at my formal education

MSc Environment and Sustainable Development, The Bartlett Development Planning Unit in Environmental PlanningUCL | 2021
BA International Business Management  in Business and TechnologyOxford Brookes University | 2019

About Me

Carlos Barrero

Data Analyst with over 4 years of experience in the public sector. Currently looking for the next challenge

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free