# Afshan Ali

Afshan Ali is a remote worker on Himalayas, Lead Data Engineer at Freddie Mac, based in United States.

Source: https://himalayas.app/@afshanali1

```text
Lead Data Engineer at Freddie Mac building mortgage data pipelines that serve 30+ analytics and reporting consumers.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 120k+ USD |
| Job categories | Data Engineer |
| Skills | Data Engineering, ETL ELT, Data Architecture, Data Pipelines, Cloud Data Platforms, Data Warehouse, Lakehouse Architecture, Data Modeling, Real time Data Processing, Data Migration, Data Quality, Data Governance, Data Lineage, HIPAA, GDPR |
| LinkedIn | https://linkedin.com/in/afshan-ali-butt-81946928b |

## About

```text
At Freddie Mac, I architect Bronze, Silver, and Gold data pipelines on Snowflake and Databricks, delivering mortgage and financial data to 30+ analytics and reporting consumers. I engineer Python and PySpark pipelines that process billions of mortgage records daily.

I also automate Snowflake provisioning with Terraform and enforce data quality with Great Expectations and dbt tests. These efforts reduced environment-drift incidents by 65% and production incidents by 55%.

Previously, at UHY LLP, I designed data pipelines for financial, healthcare, and audit reporting, and migrated SSIS and Informatica workloads to Azure Data Factory and AWS Glue. At CNR Technologies, I developed SQL ETL processes and dimensional warehouses for finance, sales, and operations reporting.
```

## Experience

### Lead Data Engineer (current)

[Freddie Mac](https://himalayas.app/companies/freddie-mac). Feb 2022 - Present

```text
Architect enterprise-scale Bronze, Silver, and Gold pipelines on Snowflake and Databricks, delivering production-grade mortgage and financial data to 30+ analytics and reporting consumers. Engineer high-throughput ETL/ELT pipelines in Python and PySpark using Azure Data Factory and dbt, processing billions of mortgage records daily with sub-hour latency.
```

Skills: Snowflake, Databricks, Python, PySpark, Azure-Data-Factory, DBT, Terraform, Prefect, Dagster, Redis, Great-Expectations, Unity-Catalog, Datadog, Palantir-Foundry, Microsoft-Purview, HIPAA, IAM, RBAC

### Senior Data Engineer

[UHY LLP](https://himalayas.app/companies/uhy). Nov 2019 - Jan 2022

```text
Designed Python, SQL, and dbt pipelines on Snowflake for financial, healthcare, and audit reporting across 15+ concurrent client engagements. Migrated SSIS and Informatica workloads to Azure Data Factory and AWS Glue, reducing infrastructure overhead by 40% and improving reliability.
```

Skills: Python, SQL, DBT, Snowflake, Azure-Data-Factory, AWS-Glue, Airflow, Great-Expectations, Power-BI, Tableau, Microsoft-Purview, HIPAA

### Data Engineer

CNR Technologies. Aug 2014 - Oct 2019

```text
Developed SQL ETL processes and automated workflows that consolidated 12+ source systems into centralized, analysis-ready repositories. Optimized SQL Server and PostgreSQL stored procedures, indexes, and database objects, improving query performance by up to 40% for workloads serving 500+ daily users.
```

Skills: SQL, ETL, SQL-Server, PostgreSQL, Azure-Data-Factory, SSIS, Power-BI, SSRS, Star-Schemas, DataVault-2.0

## Education

### Bachelor of Science in Computer Science

Bachelor of Science, Computer Science

```text
Bachelor of Science in Computer Science.
```

## Tech stack

- Amazon Redshift
- Snowflake
- Splunk
- Apache Spark
- AWS Glue
- Talend
- Tableau
- AWS IAM
- Microsoft Azure
- Google Cloud Platform
- Amazon CloudWatch
- Amazon S3
- AWS Step Functions
- GitHub
- GitLab
- Kubernetes
- Jenkins
- PySpark
- dbt
- MySQL
- PostgreSQL
- MongoDB
- Oracle
- Hadoop
- Databricks
- Redis
- Terraform
- Azure DevOps
- Jira
- Python
- Java
- JSON
- PowerShell
- Scala
- XML
- TensorFlow
- scikit-learn
- Apache NiFi
- Grafana
- Azure Monitor
- Datadog
- AWS Lambda
- Azure Functions
- Microsoft Excel
- Azure SQL Database
- Git
- Docker
- Amazon EMR
- Amazon Athena
- SQL
- Prefect
- Dagster
- Soda
- Delta Lake
- Great Expectations
- Bash
- Microsoft Fabric
- Palantir Foundry
- Unity Catalog
- Microsoft Purview
- Power BI
- Apache Kafka

To contact Afshan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Ronnnie K](https://himalayas.app/@ronnniek): Data Architect, Cigna
- [Affi Ahmad](https://himalayas.app/@affiahmad): Senior Data Engineer, GlidePath Logistics, LLC
- [Ashish Shrestha](https://himalayas.app/@ashishshrestha2): Data Engineer, Spring Health
- [Afshan Ali](https://himalayas.app/@afshanali): Lead Data Engineer, Freddie Mac
- [nirjal kharel](https://himalayas.app/@nirjalkharel): Senior Data Engineer, Pfizer
- [Adarsha Khadka](https://himalayas.app/@adarshakhadka): Senior Data Engineer, Allstate
- [Akriti Luitel](https://himalayas.app/@akritiluitel): Senior Data Engineer, Merck
- [Pratiksha KC](https://himalayas.app/@pratikshakc): Senior Data Engineer, Cigna
- [Data Dev](https://himalayas.app/@datadev): Lead Data Engineer, Freddie Mac
- [sreya p](https://himalayas.app/@sreyap): Senior Data Engineer, Tenet Healthcare
