Diego Rivero – Data Scientist and Geospatial Engineer

About me

I'm Diego, a data scientist and geospatial engineer working in the Telecom and BPO sectors. With 8 years of experience in databases, SQL, and geospatial data management, I lead ELT implementation, data warehousing, and data modeling. Skilled in SQL reporting with SSRS/ Power BI. Native Spanish speaker and C2 certified in English. Passionate about all things data, especially geospatial data analysis. Open to new opportunities and collaborations.

Things I know

• Data pipeline development (dbt)
• ELT (Extract, Load, Transform)
• Data modeling and database design
• SQL and NoSQL databases (Postgres, SQL Server, SQLite, Redis)
• GIS – Geographic Information Systems (PostGIS, QGIS, ArcGIS)
• Public clouds (AWS, Azure, DigitalOcean)
• Cloud data management platforms (Databricks, Deepnote)
• Programming languages (Python, SQL, C#)
• Docker and containerization
• Data visualization (Tableau, Power BI)
• Data quality and testing
• Lots of Excel (xlookup/vlookup, tables and pivot tables, embedded SQL queries, VBA)

Things I've done

• A fork of a bot to repost memes to Twitter called Tootbot.
• A page that makes anything you write into a cube in markdown code block format called Cubeposter.
• A bot that takes text and reads it out loud on Discord using Azure called TTS for Discord.
• A page to know how close to the 1% top earners would you be in my country called salary-o-meter (which currently is only in Spanish and uses Colombian pesos).
• A compilation of useful Microsoft SQL Server scripts.
• An implementation of a Mandelbrot set renderer in F# (my favorite side language) that is available on my GitHub.
• This website, which was built in Astro, and you can find the source code for it here.
• Check out my GitHub to see what other (open source) things I've done!
• I've also done a lot of closed source work on the technical side of management consulting for the telecom & tech industry, plus a lot of data pipelines and data management (and people management, too) for the BPO industry.
• If you like what I do enough to want me to do something for you, great! I also do all sorts of technical consulting work with my firm Pidgin and I'm pretty sure I can help you out. See my contact details below.

Things I'm learning (or know but haven't used at work)

• F Sharp
• Lisp
• Prefect
• R
• PRQL
• Kubernetes
• Helm
• Rust

Things I like (enough to do them in my free time)

• Functional programming
• Reading – a lot of reading
• World History & Geopolitics
• Art, especially painting and classical music
• Music, especially indie and alternative rock
• Traveling
• Landscape photography (I love sunsets)
• Cooking (I especially love mediterranean cuisine, from Spain to Turkey)
• Star Wars (I like the sequels more than the prequels)
• This image of C-3PO as Ironman

Contact

• Email: [email protected]
• Work email: [email protected]
• LinkedIn: linkedin.com/in/diego-rivero-dataeng