Avenue One
Aug 2021 - Jan 2025
Lead Analytics Engineer
Responsible for data analytics, data stack infrastructure, and data integration.
Data Stack
- File, REST, GraphQL, JSON data source pipelines
- Fivetran, Airbyte, and other ETL/ELT tools
- S3 Data Lake, Microsoft SQL Server, and Snowflake Data Warehouse
- Snowflake Document AI
- dbt (data build tool) and dbtCloud
- Github Actions, Airflow/Astronomer, and other orchestration/DataOps tools
- Monte Carlo Data (https://www.montecarlodata.com/)
- Atlan Data Catalog (https://atlan.com/)
- Tableau, Sigma Computing, Hex Tech Notebooks
Data Sources
- Financial sources (Bloomberg BLPAPI, Moody's Analytics, FRED, Netsuite, etc.)
- Real estate sources (MLS systems, HouseCanary, Cherre, Zillow, and more)
- Operations (Low-code tools like Retool/Unqork and other internal systems)
- Databases (Amazon RDS, MSSQL, MySQL, and more)