Sarah Zeng Email & Phone Number

Greenwood Village, Colorado, Us

• Built and maintained ELT data pipelines (built in Python, orchestrated with Airflow) that ingest monolith, microservice, and third party data sources through Kafka, AWS S3, and AWS Redshift• Identified, corrected, and educated around code quality and data quality issues• Designed and created dimensional data models for our federated data mart architecture to empower data-driven decisions across the company• Collaborated with software engineers, data analysts, and business leaders to gather requirements, develop solutions, and balance competing priorities• Conducted 30+ interviews for roles ranging from entry-level data engineer to data engineering manager. Refined interview questions, developed coding exercises, and documented acceptance criteria

Downers Grove, Il, Us

• Designed and built 40+ production-level Redshift tables and views to ingest and restructure raw data from multiple sources into validated, readily-consumable assets for data science modelling and analytics reporting.• Rebuilt data pipeline behind company's most comprehensive Tableau dashboard to combine 13+ company-wide data sources, improve data extract efficiency by 70-80%, and add comprehensive validation methods for future error-tracking• Won 2 awards at the 2022 International Customer Experience Awards as part of 12-person team: Silver for Best CX Measurements, Gold for Best Use of Insights & Feedback• Championed data cataloging efforts to monitor data quality, troubleshoot data-related issues, and make complex data more accessible• Designed and built new data pipelines to automate series of marketing reports, reducing potential for human error and saving about 40 work hours per month• Migrated and refactored data pipeline behind business-critical financial report, updating inputs and outputs, identifying and correcting existing calculation errors, and improving code readability and updateability• Designed and built the data science documentation site in Confluence, SQL, and wiki markup, with features such as page creation templates, automated data transfer across pages, self-updating charts and tables, and 3-click navigation• Designed and built the Advanced Analytics team Jira project (with team-wide feedback) to facilitate workload planning and stakeholder expectation management for variety of workflows (analytics/business intelligence, data science, data engineering, and data warehousing)• Launched 7+ Tableau dashboards with row-level security, intuitive and accessible visualizations, sophisticated data analysis, instructional hover tooltips, and global maps• Won the IT Department's 2022 Q2 Most Valuable Player (MVP) Award for empowering leadership to improve the customer experience and more efficiently distribute employee workloads

Cambridge, Massachusetts, Us

La Jolla, Ca, Us

• Built causal inference and time-series econometric models such as ordinary least squares (OLS) linear regression, geographically weighted regression (GWR), Heckman correction, difference-in-differences (DD), augmented inverse propensity score weighting (AIPW), probit/logit regression, and structural vector autoregression (SVAR)• Wrote scripts in Python, ArcGIS, and Stata to extract, clean, transform, visualize, and model over 6 million observations from 20+ structured and unstructured data sources (e.g. tabular, geospatial, pdf, and image formats)• Initiated, developed, and wrote 10+ research proposals and papers related to vehicle choice, automobile fleet composition, road quality, natural aggregates, taxation (motor fuel and corporate income), and voting behavior

La Jolla, Ca, Us

Won the Teaching Assistant Excellence Award ($500) twice for "glowing teaching evaluations from the undergraduates, graduates, and faculty supervisor'' (2018, 2020)ECON 4/MGT 4 Financial Accounting (Spring 2017-Jun 2020)GPIM 457 Cost Benefit Analysis (Fall 2018) -- Master'sECON 176 Marketing (Fall 2018)ECON 144 Economics of Conservation (Summer 2018)ECON 100A Intermediate Microeconomics (Winter 2017)ECON 109 Game Theory (Fall 2016)Reader (grader) for:ECON 145 Economics of Ocean Resources (Spring 2018)ECON 100C Microeconomics C (Spring 2017)ECON 164 The Indian Economy (Winter 2017)ECON 1 Principles of Microeconomics (Fall 2015-Spring 2016)

• Developed debate and persuasion skills via discussion seminars and academic conferences on topics such as social and cultural constraints on liberty, Lewis & Clark, David Hume, Thomas Piketty, Socrates, Constitutional liberty, and the political economy of statelessness (anarchy)• Read 300+ articles and 3,000+ pages featuring authors such as Frédéric Bastiat, Caroline Hoxby, Paul Krugman, James Buchanan, Greg Mankiw, Thomas Piketty, and James Tooley• Followed content from The Economist, Econlog, EconTalk, Wall Street Journal, NPR, TEDTalks, Bloomberg Businessweek, FEE, Harvard Business Review, the New York Times, and more• Monitored, posted, and tweeted for the Econlib Facebook and Twitter social media accounts

Bloomington, In, Us

• Proofread academic papers on online markets, checking for clarity of writing style and accuracy of citations, footnotes, and facts• Created digital graphs and images using Geometer’s Sketchpad, Maple, and Mathematica for research on Euclidean geometryWorked with Prof. Eric Rasmusen and Prof. Michael Baye

Washington, Dc, Us

• Began from zero knowledge of Mandarin Chinese to cultivate superior, professional-level language proficiency through accelerated language learning, advanced culture courses, extracurricular engagement, and overseas study• Wrote, directed, and produced a 45-minute musical entirely in Chinese with a team of ten actors and one choreographer after only one year of language instruction (2012)• Obtained advanced speaking, listening, reading, and writing abilities in Mandarin Chinese through eight weeks of intensive language instruction at the National Taiwan University (2013)

Taught Spanish Immersion I & II• Prepared lesson plans, reading questions, and other educational materials featuring En el tiempo de las mariposas by Julia Álvarez, Diarios de motocicleta/Motorcycle Diaries (2004 film), Hombres armados/Men with Guns (1997 film), and other texts and films• Instructed approximately 50-60 high school freshmen and sophomores on mastery of the Spanish language and understanding of Hispanic culture

Phd, Economics

Bachelor Of Science (Bsc), Theoretical Mathematics, Business Economics & Public Policy