Looking for a job

Afshan Ali

@afshanali1

Message

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

United States

Message

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

Work history, roles, and key accomplishments

Current

Lead Data Engineer

Current

Freddie Mac

Feb 2022 - Present (4 years 8 months)

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.

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

Nov 2019 - Jan 2022 (2 years 2 months)

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.

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 (5 years 2 months)

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.