Akhil Thota

Experience

1. Data Business Analyst

   Wind River

   Jan 2025 — Present · CA, US

   One of my most transformative achievements has been the development of automated ETL pipelines using SQL, Python, and Airflow/dbt to unify multiple data sources into a single, coherent data warehouse. When I first joined the organization, teams were working with fragmented datasets stored across disparate systems—ranging from application telemetry logs and customer usage data to CRM exports and financial reports. This fragmentation made it difficult to gain a consistent view of the business, often leading to delays in decision-making and data discrepancies across departments.I took the initiative to design and implement an end-to-end data ingestion and transformation framework, beginning with a deep assessment of the existing data landscape. Leveraging Airflow’s orchestration capabilities and dbt’s modular transformation framework, I engineered automated workflows that extracted raw data, standardized schemas, and built transformation layers aligned with business logic. Through careful optimization—such as incremental loads, parallel processing, and dependency management—I reduced daily data refresh times by over 40%.As a result, the unified data warehouse became a single source of truth for analytics, supporting consistent reporting across sales, marketing, engineering, and operations. This foundation enabled downstream teams to explore data independently through self-serve dashboards, freeing the analytics team from repetitive reporting tasks and driving a cultural shift toward data-driven decision-making.Data reliability was another critical challenge that had been holding back strategic initiatives. Before automation, data refresh failures and schema mismatches were frequent, leading to mistrust in dashboards and reports. By embedding automated data quality checks and implementing version control for SQL transformations, I ensured consistency and accuracy across the pipeline.These enhancements collectively improved data reliability by 35%, as validated.

Education

• Sacred Heart University

  Masters of Science, Business Analytics