Managed data pipelines for multiple product offerings using Snowflake, Hightouch, Fivetran, and Kafka Connect.
Developed data models using dbt for consumption in Tableau and Metabase, defined and modeled product KPIs, as well as created custom materializations, macros, tests, and run hooks to facilitate scheduled runs in dbt Cloud.
Led the design, implementation, and successful launch of the first on-demand pay (ODP) backed security in the history of the securitization industry within a year of tenure.
Created a data pipeline for the layering and management of a $213,000,000 ODP-backed security and $766,000,000 asset-backed loan in accordance with investor requests and regulatory standards.
Managed extraction, load, and transformation of client data from multiple products in Amazon Redshift, including the creation and maintenance of custom EL applications.
Developed data models using dbt for consumption in Looker, generation of product KPIs, and pseudonymization, as well as created custom materializations, macros, and run hooks to facilitate scheduled dbt runs.
Worked directly with clients and internal stakeholders to design data visualization dashboards using Looker.
Created a performant attribute encryption Lambda in AWS for structured objects in S3, capable of encrypting over 16,000,000 records per minute.
Incorporated technologies such as Airbyte and Redshift Federated Query into data pipeline.
Created purging and maintenance projects to ensure optimal database performance and adherence to company data security and retention policies.
Led sprint planning, retrospectives, backlog refinement, and other Agile ceremonies for the data engineering team as Scrum master.
Generated material and labor estimates for residential and commercial construction jobs using Xactimate.
Engaged with material vendors and subcontractors to ensure adherence to job scheduling.
Performed bookkeeping and finance management tasks, including billing, invoicing, and payroll using QuickBooks.
Deployed and maintained businesswide technologies, such as email servers, web servers, workstations, and remote filehosting.
Managed and maintained library of Middlesex County Correctional patient records.
Oversaw digitization and archival of all physical records using TechCare.
Coordinated with hospitals, law enforcement, legal personnel, pharmacies, and civilians to facilitate access to patient medical data in accordance to HIPAA guidelines and facility policy.