# Alison DeFede

Alison DeFede is a remote worker on Himalayas, Volunteer Data Consultant at Fresh Start Women's Foundation, based in United States.

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

```text
I build scalable cloud data platforms, pipelines, warehouses, and analytics solutions.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Data Engineer, Data Engineer, Senior Data Engineering, Business Intelligence Developer, Data Analyst, SQL Developer, Database Administrator, Data Consultant, Data Engineer Jobs, Data Engineering, Data Engineering Specialist, Data Engineering Jobs, Data Engineering Positions |
| Skills | Snowflake, PostgreSQL, MySQL, Amazon Redshift, SQL Server, AWS RDS, Azure SQL, Airflow, AWS MWAA, DBT, Fivetran, SSIS, Azure Data Factory, Snowflake Snowpark, SQL, Python, BASH, VBA, AWS Lambda, Amazon SQS, Amazon API Gateway, Power Automate, Power BI, Tableau, Sigma, Microsoft SSRS, GitHub, Azure DevOps, Jira, CI CD, REST APIs, GraphQL, Dimensional Models, Kimball Modelling Methodology, Data Warehouse Architecture, Data Governance, Docker, Apache NiFi, S3, Amazon RDS, DAX, .NET, Factory, Fresh |

## About

```text
At MyCommunityHomes, I build scalable Airflow and AWS MWAA pipelines, REST and GraphQL integrations, event-driven webhook ingestion, and Kimball-modeled leasing data solutions in Snowflake. I also administer Snowflake, implement dbt workflows, develop AI agents, and establish data governance standards.

I've modernized data platforms across eVisit, LeafTrade, and Make-A-Wish America, including a migration to Snowflake, an Azure SQL data warehouse migration, and automated reporting solutions using Airflow, Lambda, API Gateway, Redshift, Power BI, and SSRS.

My work combines data engineering with hands-on warehouse design, automation, reporting, and technical leadership. I've partnered with business and technical teams, mentored analysts, coordinated contractors and consultants, and translated reporting needs into durable data solutions.
```

## Experience

### Volunteer Data Consultant (current)

Fresh Start Women's Foundation. Jan 2025 - Present

```text
Established a Snowflake data environment and supported the organization's transition to a centralized cloud data platform. Designed data ingestion processes and provided guidance and training.
```

Skills: Snowflake, Data-Ingestion, HubSpot, APIs, Data-Governance, Training

### Senior Data Engineer (current)

MyCommunityHomes. Apr 2023 - Present

```text
Design, develop, and maintain scalable data pipelines and workflows using Apache Airflow and AWS MWAA. Build integrations with REST and GraphQL APIs, implement dimensional data models, and manage Snowflake environment.
```

Skills: Airflow, AWS-MWAA, REST-APIs, GraphQL, Fivetran, AWS-Lambda, Amazon-SQS, Power-Automate, DBT, Snowflake, Data-Governance

### Data Engineer

LeafTrade. Jun 2022 - Apr 2023

```text
Maintained and troubleshot Apache Airflow environments, designed and implemented Airflow DAGs, and served as database administrator for PostgreSQL data warehouses on AWS RDS.
```

Skills: Airflow, Docker, PostgreSQL, AWS-RDS, AWS-Lambda, Fivetran, DBT, GitHub, DevOps

### Data Engineer

eVisit. Jun 2021 - Jun 2022

```text
Developed and maintained Airflow workflows within AWS MWAA, designed data pipelines for API data ingestion, and automated SFTP reporting solutions. Modeled data for Amazon Redshift and managed migration to Snowflake.
```

Skills: Airflow, AWS-MWAA, AWS-Lambda, Amazon-Redshift, MySQL, Snowflake, Sisense, Tableau, GitHub

### Business Intelligence Developer

Make-A-Wish America. Dec 2018 - May 2021

```text
Designed, developed, and maintained an enterprise data warehouse using SQL Server. Developed BI solutions with Power BI and SSRS, and led migration to Azure SQL Server.
```

Skills: SQL-Server, Power-BI, DAX, Python, SSIS, Azure-SQL-Server, Azure-Data-Factory, DevOps, CI-CD

### Business Intelligence Developer II

Taylor Morrison. Apr 2018 - Dec 2018

```text
Developed and maintained SQL stored procedures supporting enterprise reporting, designed ETL processes, and created reports and dashboards using SSRS and Power BI.
```

Skills: SQL, Stored-Procedures, ETL, Power-BI, SSIS, Technical-Documentation

### SQL Developer/ Senior Analyst / Marketing Intelligence Developer

Merkle Inc.. Nov 2015 - Apr 2018

```text
Supported legacy data systems and contributed to the design of new data architecture. Developed Apache NiFi ETL processes and custom reporting solutions using SSRS, Tableau, and Datorama.
```

Skills: SQL-Server, Unix, Apache-NiFi, Python, MySQL, Tableau, Datorama, SSIS

### Institutional Research Data Analyst

Carlow University. May 2015 - Nov 2015

```text
Extracted and analyzed data from the university's student information system, performed ETL processes, and developed Tableau reports and visualizations.
```

Skills: Data-Analysis, ETL, Tableau, Databases, VBA, Automation

### ICOM3 Configuration Specialist

RedZone Robotics. May 2014 - May 2015

```text
Developed scripts for ETL of datasets, provided technical support for ICOM3, and customized databases and SSRS reports based on client requirements.
```

Skills: ETL, Technical-Support, Database-Administration, GIS, .NET

### Business Application Specialist

Howard Hanna Real Estate Services. May 2013 - May 2014

```text
Developed and maintained SQL stored procedures and SSRS reports, performed ad hoc data analysis, and supported accounting audits.
```

Skills: SQL, Data-Analysis

## Education

### Robert Morris University

Master of Science, Information Technology

```text
Master of Science in Information Technology with a focus on Project Management.
```

### Robert Morris University

Bachelor of Science, Information Science

```text
Bachelor of Science in Information Science.
```

## Tech stack

- Fivetran
- GitHub
- dbt
- MySQL
- PostgreSQL
- .NET
- Azure DevOps
- Jira
- GraphQL
- AWS Lambda
- Airflow
- SQL
- Bash
- Fresh
- Factory

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

## People also viewed

- [Steve Ali](https://himalayas.app/@steveali): Senior Data Engineer, 3Cloud
- [Andrii Taranov](https://himalayas.app/@andriitaranov): Principal Data Engineer, Providence Health and Services
- [Affi Ahmad](https://himalayas.app/@affiahmad): Senior Data Engineer, GlidePath Logistics, LLC
- [Ishtiaq Syed](https://himalayas.app/@ishtiaqsyed): Sr. Data Engineer/Architect, Norton Rose Fulbright
- [Samatha Amsala](https://himalayas.app/@samathaamsala): Data Engineer, American Express
- [Khateja Begum](https://himalayas.app/@khatejabegum): Sr. Data Engineer, AssistRx
- [Mark Fahad](https://himalayas.app/@markfahad): Staff Data Engineer, WestonChaseTechnologies
- [Kalpit Shrestha](https://himalayas.app/@kalpitshrestha): Sr. Data Analyst, Sutter Health
- [Daksha Mahida](https://himalayas.app/@dakshamahida): Data Architect / DW Technical Lead/Senior Data Engineer, Impinj
- [Eric lee](https://himalayas.app/@ericlee7): Data Engineering Manager, SmarterDx
