Josh Johnson
Consultant | Data & Solutions Architect
Chicago, IL •
jjohnso75@gmail.com •
linkedin.com/in/jjohnso75
Professional Summary
Freelance software developer and business advisor with 15+ years building the ETL pipelines, reporting, and cloud data warehouses that commercial teams run on. Previously at Beghou Consulting (2021 - Aug 2026), worked directly with emerging and established pharma clients — translating business needs into Databricks and Snowflake systems that power reporting, analytics, and warehouse modernization. Now building custom software and helping businesses adopt AI through practical advocacy and hands-on learning.
Core Expertise
- Commercial pharma analytics, HCP targeting, field force optimization, omnichannel measurement, and launch readiness
- Cloud data architecture across Databricks, Snowflake, Delta Lake, GCP, and dbt; expert at orchestrating and chaining AI tools — LLMs, agents, RAG pipelines, and automation APIs — into cohesive, production-ready solutions
- Executive stakeholder management, technical delivery leadership, data governance, automation, and team development
Technical Skills
AI Orchestration & Integration: LLMs (Claude, ChatGPT, Gemini), Agents (Codex, Claude Code, OpenCode, Pi, Hermes), MCP
Data Engineering & Cloud: Databricks, Snowflake, PySpark, Python, SQL, Delta Lake, GCP, dbt
Commercial Analytics: HCP targeting, field force analytics, omnichannel strategy, Reporting, Master Data Management
Development & DevOps: TypeScript, React.js, Node.js, Git, GitHub, Docker, VS Code, Databricks, Jira
Professional Experience
Freelance Software Developer & Business Advisor
St. Louis, MO • Sep 2026 - Present
- Build custom software for clients — full-stack development across TypeScript, React, Node.js, Python, and cloud data platforms.
- Advise businesses on software strategy and practical AI adoption — helping teams move from exploration to production with LLMs, agents, and automation.
- Push AI advocacy and learning in public — sharing hands-on patterns for building with AI tooling through real projects and writing.
Assc. Manager, Consulting
Evanston, IL • 2021 - Aug 2026
- Serve as a client-facing consultant and data architect for emerging and established pharma clients, translating commercial needs into ETL pipelines that ingest, consolidate, and modernize data on Databricks and Snowflake.
- Delivered ~12 client engagements spanning pre-revenue to $100B market-cap organizations — primarily data warehouse builds and maintenance, reporting support, MDM, migration efforts, and QC builds; on several, served as a forward-deployed engineer standing up pipelines that transitioned into a consultant-led onshore/offshore support model.
- Launch readiness is my specialty: across four product launches, stood up fully scheduled reporting environments delivering daily data and 96% job run success that field and commercial teams relied on from day one.
- Post-launch, advise client stakeholders on reporting services, documentation, and omnichannel data aggregation — demand, HCP CRM engagement, and marketing — into a single source commercial teams act on.
Manager, IT Applications
Northfield, IL • 2019 - 2021
- Managed 20-person engineering and PMO team supporting a $7B+ distribution business, achieving 98% project delivery on time and budget.
- Delivered 25+ lightweight enterprise applications using OutSystems, SQL, and .NET, generating $2M+ in aggregate annual cost savings.
Senior Buyer / Supervisor, Inventory
Northfield, IL • 2018 - 2019
- Automated procurement operations for a 15-person purchasing team managing $75M+ weekly spend through SQL reporting and VBA macros, enabling the same headcount to absorb significantly greater volume.
- Drove optimization of supply network planning, material requirements planning, and safety stock across high-velocity SKUs using SAP and SQL Server stored procedures, improving inventory positioning and reducing excess stock exposure.
Supply Chain Analyst to Senior Analyst, Inventory
Northfield, IL • 2015 - 2018
- Accumulated $50M+ in annual cost avoidance through root-cause analytics and SAP-driven supply chain optimization across a $7B+ distribution operation.
- Established SAP MRP/SNP master data governance, improving forecast accuracy by 25% and reducing stockouts by 40%.
Education & Certifications
Bachelor of Science in Management
Purdue University, Krannert School of Management • 2011
ASQ Certified Six Sigma Black Belt
Credential ID: 16256 • 2019