Hertz Analytics Consultants helped in data acquisition and transformation by developing custom scrapers and parsers to collect data from different sources. Additionally, setting up efficient data pipelines using Databricks to process and store it in the data warehouse.