Jerret H.

Experience

1. Lead Data Engineer

   Scandinavian Tobacco Group

   Apr 2022 — Present · US

   Owned the design and architecture of end-to-end data pipelines supporting multi-brand Salesforce Commerce Cloud migrations across customers, orders, products, pricing, subscriptions, and images in DEV, QA, and PROD environments.• Led migration strategy and execution, including data mapping, transformation logic, deduplication frameworks, SCD2 historical modeling, validation tooling, and production cutover support.• Established ETL and data modeling best practices used across workstreams, improving reliability, repeatability, and data quality throughout migration and integration efforts.• Coordinated cross-functional delivery across engineers, QA, and business stakeholders to ensure successful UAT sign-off and release readiness under tight project deadlines.• Designed and maintained scalable Python/SQL ELT frameworks ingesting data from APIs, SFTP, flat files, and relational databases into analytics and operational systems.• Built idempotent, backfillable pipelines using control-date logic, structured logging, and automated alerting (OpsGenie) to ensure high reliability and rapid failure recovery.• Implemented data quality gates and reconciliation processes to validate integrity between legacy platforms and SFCC targets.• Mentored engineers through code reviews, architectural decisions, and pipeline design patterns to improve system scalability and operational maturity.• Optimized third-party data integrations, reducing latency and improving performance of downstream workflows used by business and analytics teams.

Education

• Ohio University

  Bachelor of Business Administration - BBA, Management Information Systems

  2014 — 2016

Skills

• Visual Studio
• Microsoft Excel
• Social Networking
• Tableau
• Teamwork
• Sap Crystal Reports 2013
• Microsoft Sql Server
• Public Speaking
• Microsoft Project
• Visio
• Public Relations
• Engaging People
• Sap Businessobjects Dashboards