Erich Schwartz

B

Sr. Data Analyst & ETL Developer

BlueChip-Pros

Jul 2024 - Dec 2024 (6 months)

• Collaborated cross-functionally with finance and ops to identify business needs and translate them into scalable data models and dashboards. • Automated multi-source data ingestion using Azure Logic Apps, REST APIs, SQL, and Python, enabling faster decision-making and reducing manual entry. • Designed and maintained ETL pipelines to centralize key performance and financial data, enhancing visibility for strategic planning. • Conducted regression and anomaly testing to validate data pipeline integrity; reduced post-migration data loss to under 0.05%. • Built executive-level KPI dashboards in Power BI, driving adoption of data-driven metrics at the leadership level. • Used cloud tools and CI/CD workflows to ensure high availability an

Data Analyst

Siemens

Apr 2022 - May 2024 (2 years 2 months)

• Led the design and implementation of propensity models using logistic regression and decision trees to predict sales conversion and churn risk. • Conducted advanced A/B tests and experimental designs to optimize marketing channels, landing pages, and media spend. • Delivered data-driven budget reallocations that optimized $3M in marketing spend based on campaign performance insights. • Developed predictive models using Salesforce, Python, and SQL, flagging high-risk customers and improving retention strategy. • Built prototype LLM chatbot to support internal marketing teams with real-time product knowledge access. • Created dashboards and campaign reports for marketing stakeholders using Tableau and Power BI, increasing visibility i

Data Analyst

Panorama Education

Aug 2021 - Mar 2022 (8 months)

• Integrated attendance, behavior, SEL, and academic data from over 10 student information systems into a unified analytics layer. • Conducted exploratory data analysis (EDA) using Python (Pandas, Numpy, Seaborn) to uncover trends in absenteeism and performance. • Cut ETL turnaround time from 48 hours to under 6 by automating workflows. • Developed custom interactive dashboards in Power BI and Tableau that gave school administrators real-time visibility into student progress.

A

Data Scientist - Consultant

ASR Analytics, LLC

Apr 2019 - May 2021 (2 years 2 months)

• Supported the IRS as a data scientist optimizing the Automated Collection System (ACS) for Research, Applied Analytics, and Statistitics (RAAS). • Developed and deployed machine learning fraud detection models for the IRS using end-to-end anomaly detection algorithms for tax-fraud detection and provided solutions to identify fraud with a 0.9 precision score (Python, Pandas, NumPy, SciPy, Scikit-Learn). • Engineered modular, scalable dbt models and SQL-based pipelines to transform raw IRS tax collection data into clean, analysis-ready layers (staging, intermediate, mart) enabling automated fraud detection and compliance reporting. • Prevented the issuance of more than $5M in fraudulent tax refunds by building and deploying supervised l

M

Senior Data and Business Intelligence Analytics Consultant

MULTIPLE CLIENTS

Jul 2016 - Current (9 years 11 months)

• Developed financial models in Excel and visualizations in Python (Matplotlib, Seaborn) to support strategic reports and presentations for executive clients for Housing Finance Strategies, LLC. • Analyzed federal housing guidelines and market indicators to assess risk exposure and regulatory impacts, informing long-term planning for Housing Finance Strategies, LLC. • Web Development for Housing Finance Strategies, LLC. • Worked with the National Fair Housing Alliance (NFHA) in collaboration with the Consumer Financial Protection Bureau (CFPB) to determine whether barriers exist in auto lending that would have deleterious effects on consumers, primarily between white and non-white customers. • Authored investigative report detailing th

About

Detail

Timeline

Résumé