Delphi Analytics (SDSM Analytics Pvt. Ltd.)
|Data Analyst
Internship
Summary
I completed a 6-month Data Analyst internship at a startup company, where I worked with various data tools and technologies. My responsibilities included: ETL and workflow automation: Designed and monitored ETL processes using Apache Airflow, including scheduling and managing DAGs to automate and optimize data pipelines. Data visualization: Created insightful dashboards using Apache Superset and Grafana to support decision-making. Database interaction: Queried and analyzed data using PostgreSQL in DBeaver. Programming: Utilized Python for scripting and analysis. This internship enhanced my practical skills in data analysis, ETL workflows, and dashboard creation within a real-world business environment.
Highlights
Developed and optimized ETL pipelines using SQL and Python, significantly improving data processing efficiency.
Designed and implemented interactive dashboards in Apache Superset and Grafana, including setting up alerts in Grafana to monitor key metrics.
Automated data synchronization and orchestration using Apache Airflow and Python, streamlining data workflows.
Contributed to the dashboard and database migration process, including developing data validation scripts and testing migrated dashboards, ensuring data integrity and accuracy.