Senior Consultant
CurrentTechnologies: Azure, AWS, Snowflake, DBT, Airflow, PowerBI, REST APILanguages: SQL, Python• Responsible for designing end-to-end solutions including ingestion, data pipelines, data modeling and BI development. Implemented data solutions across a variety of cloud technology stacks for a number of industries.• Managed all aspects of projects including junior employee workload, maintaining client relationships, delivering projects within scope, employee feedback reviews and organizing future projects and implementations.• Developed a low cost, fully deployable orchestration solution utilizing Python, AWS Lambda and AWS Step Functions to ingest data into Snowflake and manage ETL for data warehouse.• Built an Azure data solution to load on-prem data from a DB2 instance into Snowflake using Data Factory, Azure Functions and other Azure Services.• Designed data models for storing data and tracking change history, including a Data Vault and a Data Warehouse.• Wrote an agile deployment solution in Python and Azure DevOps for deploying Azure Services, SQL DDL and scripts to a Production environment.• Designed custom data solution for ingesting UPS data into Snowflake by REST API, modeling it into a Data Warehouse, and securing it by user with Row Level Security.• Created Interactive PowerBI dashboards to allow clients to view their data in real time.• Monitored Referential Integrity of an EDW using Airflow DAGS.