Arif Khan

Data Engineer with 3.5+ years of experience designing, building, and optimizing scalable ETL/ELT pipelines on Snowflake and AWS. Strong background in data warehousing, dimensional data modeling (Star & Snowflake Schema), SQL performance tuning, data governance, and BI enablement (Power BI, Tableau) across Healthcare/Pharma and Finance domains. Delivered measurable business impact, including a 40% reduction in query execution time and a 99.8% pipeline success rate.

Data Engineer (Contractual) - Livekeeping - Noida, India

(2026-01 - 2026-03)

• Optimized complex SQL queries and stored procedures, driving a 35% increase in financial data processing efficiency and improving reporting turnaround.
• Cleaned, transformed, and validated large-scale finance datasets using SQL and Power BI Power Query, ensuring high data accuracy and consistency.
• Built interactive Power BI dashboards with advanced DAX calculations, enabling stakeholders to derive actionable insights and monitor key financial KPIs.
• Implemented data quality checks and partnered with cross-functional stakeholders to streamline analytics workflows and improve reporting reliability.

Snowflake Data Engineer (Software Engineer) - LTIMindtree - Pune, India

(2021-12 - 2025-01)

• Designed and implemented scalable Snowflake data models and ELT pipelines, powering a high-performance, future-ready data architecture for multiple analytics teams.
• Reduced query execution time by 40% through clustering keys, partition pruning, and advanced query profiling and tuning.
• Improved pipeline performance by 35% via parallel execution and process optimization, achieving a 99.8% success rate across production workloads.
• Automated high-volume healthcare data ingestion using Snowpipe and COPY INTO, integrated with AWS S3 external stages.
• Implemented Streams, Tasks, and Materialized Views for incremental processing and workflow orchestration, cutting manual intervention.
• Established enterprise-grade data governance and role-based access control (RBAC), ensuring secure, auditable, compliant data access.
• Built reusable, standardized data models that improved interoperability and reduced redundancy across analytics use cases.
• Conducted source-to-target validation and load monitoring, strengthening data quality in compliance-critical healthcare/pharma datasets.
• Designed unified reporting layers and partnered with BI teams and business stakeholders to deliver analytics solutions aligned with domain requirements.

MBA - Information Technology - Amity University (2024-06 - 2026-06)

B.Tech - Information Technology - Rustamji Institute of Technology (2021-07 - 2021-07)