Topics

Writing the code itself: Python and pandas, JavaScript, web frameworks, testing, Git and AI coding tools.

• De-identifying FHIR data: HIPAA Safe Harbor, limited data sets and leaks
• Synthea vs SynPUF: picking synthetic healthcare data for pipeline tests
• HL7 v2 ADT feeds: from pipe-delimited events to an encounters table

Moving data in production: AWS Glue, Lambda and Step Functions, Azure Data Factory, Airflow, batch jobs, scheduling and data quality checks — what broke and how it got fixed.

• HL7 v2 ADT feeds: from pipe-delimited events to an encounters table
• Migrating from SFTP to a roster API: dual-run and reconciliation
• Why flat-file rosters break: CSV over SFTP in healthcare data pipelines

The ground everything runs on: AWS accounts and IAM, networking and SSH, Linux and the shell, Docker, Terraform, CI/CD.

• Pulling Brevo email logs into your backoffice without sharing credentials
• De-identifying FHIR data: HIPAA Safe Harbor, limited data sets and leaks
• From SSH keys to SMART Backend Services: auth for system-to-system FHIR

Computer science foundations, software architecture and the career side of the job.

• Greenfield vs Brownfield Projects: What Actually Changes in Engineering
• Why Terraform Does Not Deploy Your Lambda Container Image
• Daily Failure Reporting in DynamoDB Using Lambda, EventBridge Scheduler, and SES

SQL from the engine's point of view, PostgreSQL internals, dbt and Snowflake, dimensional modeling, OLTP vs OLAP.

• Building a member-month churn panel in dbt without leaking the future
• Modeling a patient roster as a FHIR Group (Da Vinci ATR)
• Snowflake SSO from the terminal: CLI, dbt Core and DBeaver

Design and theory behind data systems: GFS, MapReduce, Dynamo, Spark, HDFS internals, CAP, sharding, replication.

• Partitioning Strategy in Data Lakes: When It Hurts Performance
• Delta Lake Schema Evolution Explained with Real Examples
• Small Files Problem in Delta Lake: Detection and Compaction Strategy

Columnar engines and the BI layer on top: ClickHouse, DuckDB, PostHog, Power BI, Streamlit, Looker.

• Why my average position improved while my traffic collapsed
• Building a member-month churn panel in dbt without leaking the future
• Synthea vs SynPUF: picking synthetic healthcare data for pipeline tests

File and table formats, and how a data lake is laid out: Parquet, Iceberg, Delta, Hive, Trino, Databricks, partitioning, small files.

• Partitioning Strategy in Data Lakes: When It Hurts Performance
• Delta Lake Schema Evolution Explained with Real Examples
• Small Files Problem in Delta Lake: Detection and Compaction Strategy

Pulling data from third parties: OAuth and tokens, rate limits, retries, webhooks, scraping, Postman, SaaS connectors.

• Pulling Brevo email logs into your backoffice without sharing credentials
• Roster change notifications with FHIR Subscriptions (R4 backport)
• From SSH keys to SMART Backend Services: auth for system-to-system FHIR

Claims and value-based care data with Tuva and dbt: CMS, CCLF, HCC, risk adjustment and risk contracts.

• Building a member-month churn panel in dbt without leaking the future
• De-identifying FHIR data: HIPAA Safe Harbor, limited data sets and leaks
• Synthea vs SynPUF: picking synthetic healthcare data for pipeline tests

Markets from the data side: market data APIs, futures and options, crypto and DeFi, systematic trading.

• Liquidity pools vs lending protocols: what you're actually selling
• Automating Data Extraction with Airflow, BeautifulSoup, and MinIO
• Import Live Crypto Prices into Google Sheets

Field and crop data: agronomic analytics, sensors and imagery.

• Agro Analytics Datasets