Aineias Vasileios Kotsas

Lead design and implementation of advanced data pipelines using Python, Talend, SSIS, and Qlik Sense, enabling standardized, scalable analytics across global business units. Apply predictive analytics and machine learning (regression, classification, time series forecasting) to develop data-driven insights supporting risk identification and operational decision-making. Develop and optimize enterprise data warehouse architecture, improving performance, data quality, and accessibility for analytical teams. Oversee daily ETL operations, SQL modeling, performance tuning, and automated quality controls to ensure reliability and compliance. Integrate SAP and non-SAP data sources into unified analytical platforms; contribute to the development of a company-wide data lake enabling cross-domain analytics. Create SQL-based data validation frameworks ensuring integrity and traceability across critical pipelines. Prototype and deploy Python-based analytical tools that automate repetitive analysis

Designed and delivered a modern analytics platform ingesting commercial, sales, and safety-related datasets (including IQVIA/Veeva). Built automated pipelines from S3 to AWS Redshift using Spark and Lambda, standardizing data transformations and reducing manual workloads. Developed data models, cubes, and dynamic SQL logic to enable descriptive statistics, trend analyses, exposure calculations, and KPI monitoring.

Led the migration of legacy analytical systems to a modern Big Data platform (Cloudera), improving retrieval performance and enabling large-scale data science workflows. Designed and implemented ETL processes using Python, PySpark, SSIS, and SQL for structured and unstructured data. Built BI dashboards (Power BI) and automated pipelines that generated summary metrics, correlations, and trend analyses. Implemented CI/CD pipelines (Azure DevOps), improving traceability, version control, and compliance. Led strategic initiatives to detect anomalous patterns and non-regulated activities through automated analytics – experience aligned with AI-enabled PV workflows.