Arif Khan
Data Engineer | Snowflake | AWS | SQL | ETL/ELT | Power BI | Tableau
Hire this person
Send a job offer directly to this candidate
About
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.
Experience
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.
Education
MBA - Information Technology - Amity University (2024-06 - 2026-06)
B.Tech - Information Technology - Rustamji Institute of Technology (2021-07 - 2021-07)
