• Optimize queries and warehouse usage in Snowflake resulting in a 75% decrease inyearly credit cost while improving pipeline performance• Develop in-house text-to-sql application to translate stakeholders’ questions into Snowflakequeries using ChatGPT, supplying context from data dictionary• Oversee the migration of existing ERP data to new platform• Integrate applications with organization wide single sign-on authentication (Okta, OAuth2)• Build and maintain scalable ETL pipelines via Apache Airflow across a menagerie ofdifferent data sources across dozens of APIs from various social media services, CRMs,ERPs, etc.• Create and maintain Domo dashboards across a broad range of lines of business including but not limited to sales, accounting, HR, marketing, social media, etc.• Design SQL queries and data models from the ground up to facilitate analytical reporting• Continually assess the accuracy, availability, and integrity of massive data sets of varyingsensitivity• Collaborate with DevOps to provision and manage resources, and maintain, optimizeand deploy build environment using Terraform, CircleCI and Docker• Synchronize data from various CRMs, ERPs, and CMS systems to create a single sourceof truth• Thoroughly document and demystify schemata, data flows, and ETL processes for internal teams in DataHub

•Collaborate with employees of national and state governments throughout the world to assess integrity, quality, and utility of complex data sets for use by web-based point of sale application•As project lead, collaborate with customer service team to assess data requirements for current functionality/implement back-end solutions for new client-specific functionality•Streamline ETL process for new client implementations•Optimize and automate pre-existing functions and processes•Clean and normalize large data sets provided by clientele to interface with pre-existing database schema•Perform root cause analysis on any issues pertaining to data integrity•Maintain massive data sets in live production environments•Provide ad hoc data reports based on client demands•Create and modify business intelligence reports and data sources in Tableau to meet client specification•Develop tools and scripts to streamline repetitive tasks•Act as a point of escalation of any issues to development team•Create and maintain a knowledge base for pre-existing and new issues, possible workarounds, and potential resolutions•Regression testing to ensure stability of newly released patches

•Completed L1 through L3 support tickets and escalated issues when necessary•Created and maintained a knowledge base for completed tasks to facilitate flow of information among support team•Installed and configured new instances of proprietary software for clientele•Configured functionality and design of proprietary point of sale application to best fit the needs of clientele•Completed regression testing to ensure stability of newly released patches