Daniel Spitzer Email & Phone Number

Los Angeles, Ca, Us

Santa Monica, California, Us

Santa Monica, California, Us

-Develop and maintain ETL and ELT pipelines in aws environment-Design modern system for ingestion of external data using OOP practices to ensure data quality and standards are maintained-Remove source data from storage in redshift to only s3 in more efficient formats (parquet) to ensure reduced costs and quicker processing abilities for dimensional data warehousing needs-Implement new systems utilizing AWS cloud technologies to efficiently and quickly process large quantities (>100tb) of user and event data from web platforms and other external sources-Apply new architecture patterns to remove technical debt and ensure high availability and fault tolerance in data pipelines-Remove processing jobs from airflow and move to external sources in order to ensure airflow is maintained as orchestration tool only and data is able to be processed more efficiently-Introduce the use of spark (pyspark) managed through AWS Glue to process large volumes of user and event data-Implement AWS Lambda triggers to move towards event driven architecture where appropriate-Implement incremental loading techniques to remove requirements for full dump and reload of large data tables-Assist product team in transforming and returning data to various platforms to assist in services such as user personalization and recommendation engines-Implement local environment setup through docker to run and test cloud processes locally without incurring additional costs-Assist with infrastructure as code configurations alongside DevOps engineering team to ensure Data team is in line with the greater engineering team as a whole-Gather requirements from stakeholders to bring new data sources into our data lake following architecture patterns implemented by me-Implement monitoring tools to ensure high availability of all data products and data SLA's

Beverly Hills, California, Us

-Convert and analyze data from multiple sources (csv, sql, azure data warehouse) using power bi and associated tools-Creation of an enterprise Data Warehouse to house an report on external data -Creating of ETL and ELT workflows to move data from external business systems to data warehouse-Connecting data to PowerBI platform to generate business critical reports for department leaders and stakeholders-Create business critical applications with fast turnaround utilizing Microsoft Power Platform tools-Development of SQL solutions for DW and other reporting needs-Python scripting for web scraping and collection of Data from various API's -Developing API to allow access to DW resources and Data

Beverly Hills, California, Us

- Develop company intranet utilizing Sharepoint -Develop replenishment reporting utilizing cyberquery and Microsoft SQL Report servers - Migrate company wiki to sharepoint and reorganize/restructure - Develop custom add ins as needed for company use - Developoment of custom application for check in/out of trucks into warehouse- Office 365 admin maintaining permissions/security of sharepoint sites- Admin of all other collaboration platform technologies (Teams, Skype, Asana, etc.)- Develop training materials for company use-Convert and analyze data from multiple sources (csv, sql, azure data warehouse) using power bi and associated tools

El Segundo, Ca, Us

Lead implementation of new VoIP phone system (RingCentral)Office 365 AdminSharepoint Admin Network AdminTroubleshoot/provide support to office employees (desktop systems, printers, VOIP, etc.) Troubleshoot/Maintain networkSalesforce administratorDevelopment of dynamic, data driven, visualforce pages for client and agent use. Management/Development of CORE company websites (wordpress)