Benjamin P. Weckerle — Data Engineer

Technical Skills & Expertise

Programming & Tools SQL, Python (pandas, numpy, PySpark, scikit-learn), GCP (BigQuery), Apache Spark, Hadoop Ecosystem (Hive, Pig), NoSQL, Git/GitHub, Tableau, AWS

Data Engineering ETL Pipeline Development, Data Modeling, Workflow Orchestration, Data Integration, Data Quality & Validation, Data Infrastructure

Statistical Methods A/B Testing & Experimentation, Regression Analysis, Machine Learning, Causal Inference

Domain Expertise Retail Media, E-Commerce & Marketplace Data, AdTech Systems (DSP/SSP), Data Governance, Cross-Functional Collaboration

Experience

Walmart Connect San Bruno, CA

Manager, Advanced Analytics 2023–Present

Built multi-step data transformation workflows in Python and SQL on GCP BigQuery to process high-volume advertising event data, establishing source-of-truth datasets for cross-platform analytics and closed-loop measurement

Design & maintain scalable pipelines & ETL Extract, transform, integrate data Extensive DE experience: transformation, modeling, ETL Scalable pipelines in cloud & big data environments

Built source data pipelines and evaluation metrics dashboard for RAG-based chatbot prototype, collaborating with product and engineering teams across iterations

Collaborate cross-functionally on data requirements Analyze complex data flows & propose solutions Collaborate cross-functionally & communicate technical concepts

Enforced data governance policies including pre-earnings data embargo controls; managed DG approval workflows for new metrics and analyses, ensuring compliance with internal data privacy and security standards

Deploy code to support data governance standards Data governance, quality frameworks, regulatory requirements

Built data models and feature engineering pipelines for customer propensity scoring using market basket analysis and demographic data; delivered structured datasets for advertiser targeting

Translate requirements into data models & architectures Extract, transform, integrate — ensuring quality Design & implement scalable data models Support analytics via data sourcing, integration, validation

UMass Chan Medical School, ForHealth Consulting Boston, MA

Data Analyst 2020–2023

Automated data processing workflows using Python and Tableau Server Client library to orchestrate ETL flows, replacing manual copy-paste processes and enabling consistent daily delivery of analytical datasets

Design & maintain scalable pipelines & ETL Automate data processing Analyze complex data flows & propose improvements Extensive DE experience: transformation, modeling, ETL

Built data transformation and feature engineering pipelines for predictive models; applied NLP and text processing to transform unstructured data into structured analytical datasets

Extract, transform, integrate data Extensive DE experience: transformation, modeling, ETL Proficiency in SQL and Python

Sourced and integrated data across SQL databases, flat files, and APIs using Python and SQL to support program evaluation; built Tableau dashboards for ongoing operational reporting

Extract, transform, integrate from internal & external sources Support analytics via data sourcing, integration, validation Proficiency in SQL and Python

Cogito Corporation Boston, MA

Contract Data Analyst December 2019–March 2020

Built and maintained automated data pipelines feeding Tableau dashboards on Tableau Server for internal and external users; queried and processed large datasets using AWS and SQL in a product-led sprint cadence

Design & maintain scalable pipelines & ETL Implement solutions using cloud platforms Scalable pipelines in cloud & big data environments

Bionic Advertising Systems Hanover, NH

Data Analyst and Market Intelligence Specialist 2016–2018

Integrated and transformed marketing data from thousands of external sources into unified data products; analyzed customer data to drive onboarding process improvements

Extract, transform, integrate from internal & external sources Support analytics via data sourcing, integration, validation

Selected Projects

Built end-to-end data pipeline using Apache Airflow and GCP BigQuery to orchestrate daily ingestion and transformation of Google Analytics 4 e-commerce event data, with automated scheduling and data quality checks

Design & maintain scalable pipelines & ETL Automate data processing Scalable pipelines in cloud & big data environments Extensive DE experience: transformation, modeling, ETL

Built e-commerce conversion funnel dashboard on Tableau Public using GA4 data to visualize session-to-purchase drop-off and identify optimization opportunities

Support analytics via data sourcing, integration, validation Proficiency in SQL and Python

Education

University of New Hampshire — M.S. Analytics and Data Science May 2019 · GPA: 3.89

Statistical Methods, Predictive Analytics, Machine Learning, Design of Experiments

Florida International University — B.S. International Business May 2012 · GPA: 3.54