Professionally, I'm a graphic designer, web designer, and data visualizatiom engineer that works primarily with pharmaceutical companies, medical device manufacturers, and healthcare non-profits. Previously, I spent over a decade living and breathing PR, social media marketing, and digital marketing strategy—serving technology companies of all sizes across the cybersecurity, space, blockchain, artificial intelligence, fintech, and cloud computing verticals.

With the majority of my professional experience spent in fast-paced agency settings—and the occasional freelance/side-project—the skills I've acquired are almost entirely self-taught. I also have a strong desire to understand and learn complex systems, processes, and technologies, which I partially attribute to my neurodivergent brain.

• ☁️ Cloud-native Data Engineering: Architecting a data lakehouse on Google Cloud Platform using Medallion Architecture — designing schema strategy, partitioning, and tiered storage layers (bronze/silver/gold) in GCS with analytical serving in BigQuery. Building and maintaining ETL pipelines that ingest from upstream source systems and transform data for downstream analytics and reporting.
• 🤖 AI and Automation: Designing RAG pipelines for context-aware retrieval over internal datasets, building workflow automation in n8n and Python, and integrating LLMs (via API and local inference) for data enrichment, generative.
• ☕️ Java to learn how to make custom Minecraft mods.
• 🧊️ 3D modeling tools like Blender & BlockBench.

• 🧑🏻‍💻 Graphic Design: Social & digital marketing materials (static & animations), websites, infographics, decks & presentations, print & signage. View Portfolio
• 📸 Photography & Videography: Real estate, portraits, weddings & events, drone operator. View Portfolio
• 🕵🏻‍♂️ Social Listening & Research: Research & developing complex boolean queries, data mining, data wrangling & preparation, data analysis, visual reporting.
• ✍️ PR & Copywriting: Media outreach, social media content, thought leadership content, blogs. View Portfolio

• 🎨 Static Design: Figma, Sketch, Photoshop, Lightroom, Illustrator, Adobe Creative Suite.
• 📹 Video & Motion: After Effects, Premiere Pro, Final Cut Pro, Davinci Resolve, Apple Motion. Audio production and editing tools including Adobe Audition and Riverside.
• 📊 Data & BI: Postgres, BigQuery, MySQL, OpenRefine, Orange, Looker Studio, Netbase/Quid, Linkfluence, BrandWatch, Excel, Google Sheets, Tableau. no-code solutions including SeaTable, Nocodb, mathesar. Working with all sorts of APIs. Python data and analytics libraries like Pandas, mathplotlib.
• ✍️ Writing & Editing: Word, Google Docs, Obsidian (I love writing in Markdown).
• 🖥 Presentations & Decks: PowerPoint, Keynote, Google Slides.
• 🎯 Social & Web: Google Ads, LinkedIn Ads, SEO tools (SEMRush/Ahrefs), Buffer, HootSuite, Sprout Social, Google Analytics, Matomo/Piwik, Google Tag Manager, Meta Ads, X/Twitter ads, Hotjar.
• 👨🏻‍💻 Dev: Python, Docker, HTML, CSS, JS, PHP, reverse proxy solutions (Nginx/Apache/Traefik), VSCode as my IDE, fish/zsh/bash shells, linux-based server administration (I run my own homelab/server in my spare time), WordPress.
• 📋 Getting things done: Notion, Trello, Slack, Asana, Monday, Todoist, Airtable, and every PM/collaboration/communication/task management tool imaginable.
• 🦾 Other stuff: 3d printing, woodworking, Fusion360, building custom drones, soldering and basic electrical circuitry and power management.

📫 Contact me: zach@azntaiji.com