Max Hoffman Email & Phone Number

- Build data ingestion pipelines using Google Cloud Composer (Airflow, Python) and Dataproc (PySpark) for processing terabytes of search rank data for clients across the US and Canada, supporting Looker Studio.- Manage hybrid infrastructure migration from AWS (S3 > Lambda > Redshift) to GCP (GCS > Cloud Run > BigQuery).- Oversee data lake and warehouse storage, retention, and table design, developing SQL scripts for routine and ad-hoc maintenance (AWS Redshift, GCP… Show more - Build data ingestion pipelines using Google Cloud Composer (Airflow, Python) and Dataproc (PySpark) for processing terabytes of search rank data for clients across the US and Canada, supporting Looker Studio.- Manage hybrid infrastructure migration from AWS (S3 > Lambda > Redshift) to GCP (GCS > Cloud Run > BigQuery).- Oversee data lake and warehouse storage, retention, and table design, developing SQL scripts for routine and ad-hoc maintenance (AWS Redshift, GCP BigQuery).- Create and maintain CI/CD pipelines using GitHub Actions, Terraform, and Docker; build and manage IaC templates with Terraform and CloudFormation.- Design and implement cloud and data architecture for new products in Google Cloud.- Transition ownership of legacy codebases and CI/CD pipelines (AWS, GitHub).- Develop AWS Lambda data ingestion pipelines in Python and Rest APIs in AWS/GCP (Node.js, Python).- Optimize PySpark queries for legacy data pipelines to improve performance and run novel analysis.- Automate server administration for Windows and Linux using Powershell, Bash, and Python.- Build custom web scraping and data ingestion pipelines with Playwright, Apify, and Crawlee.- Create custom reporting pipelines, including data ingestion, storage, and visualization (GCP, Looker Studio).- Advise on application maintenance, unit testing, and CI/CD implementation (GitHub Actions, Bitbucket, Docker).- VoIP to web-app integrations using NICE Incontact API and JavaScript.- Develop 3D apartment staging software using Unity, C#, Blender, to export panorama images from project template using pre-built furniture assets.- SQL scripting and database administration (Postgres, Redshift, MySQL). Show less

- ETL engineering and data pipelines using Python, SQL, PostGres.- Assess client needs, technical project scope, plan and execute data migrations and system integrations; provide detailed technical specifications for client understanding and to aid technical implementation.- Develop custom system integrations using Python, Flask, Heroku.

- Collaborate with operations and engineering to improve processes, response time, and resolution of tickets.- Automate deployment, patch management, and incident response using Powershell.- Oversee data protection for hundreds of terabytes of client data in both onsite and cloud solutions.

- Install and troubleshoot router, firewall, VPN connections, specializing in Unifi network gear.- Support Linux servers hosting web and telephony applications.