Mike Chen

Data Engineer / San Francisco Community

San Francisco, California, United States

About

Experienced Data Engineer with a demonstrated history of working in the internet industry. Strong engineering professional skilled in Marketing Analytics and Product Analytics.

Experience

  • Member Board of Directors at San Francisco Municipal Transportation Agency (SFMTA)
    Oct 2024 - Present · 1 yr 10 mos

  • Data Engineer at Coda
    Apr 2022 - Aug 2025 · 3 yrs 5 mos

    ▶ Maintained and optimized data infrastructure with ingestion from AWS into Snowflake and task management in Airflow/Python ▶ Operationalized user value model from behavior signals, informed by data science, used by sales to expand and retain customers, and used by product for prioritization ▶ Expanded revenue reporting pipelines using Stripe and internal data to report Gross and Net ARR

  • Meta (7 yrs 11 mos)
    • Data Engineer
      Apr 2017 - Apr 2022 · 5 yrs 1 mo

      ▶ Design, build and maintain data logging, tables, and dashboards ▶ Schedule and run data pipelines using in-house version of Airflow, Python, SQL ▶ Build interfaces for data ingestion for production use cases

    • Data Scientist
      Jun 2014 - Apr 2017 · 2 yrs 11 mos

      ▶ Provide data support, insight and leadership on Facebook Growth, New User Acquisition product team. While on team, Facebook monthly active users grew from 1.32B in 2014 Q2 to 1.86B in 2016 Q4 (+540,000,000, +41%). ▶ Researched why multiple registrations use the same phone number. Findings unlocked significant increase in new user volume. ▶ Designed metrics to measure duplicate account creation so team can focus on true new user accounts. ▶ Build and maintain tools on internal stack to help product team understand experiment effects on team and company metrics. Run adhoc analysis on experiments as needed. ▶ Write data transformation pipelines with Python and Hive SQL to power datasets and dashboards. Advise on logging.

  • Senior Analyst at Analytics Operations Engineering
    Sep 2011 - May 2014 · 2 yrs 9 mos

    Company was acquired by McKinsey in 2016. ▶Designed, executed, and reported on marketing tests at >$1B specialty retailer, leading transition to a customer-focused marketing organization. Delved into Teradata SQL warehouse and determined strategies to improve customer profitability by up to 2%. Cooperated closely with marketing department and summarized results for senior management. ▶Found $4.4M in potential category crossover sales for $4B clothing retailer by changing store layout. Distilled recommendation from customer behavioral analysis of three years of transaction data using R. ▶Identified ~$28M (16%) in savings for $140M chemical distributor via coding network optimization heuristic in C++. ▶Advanced organization knowledge base by maintaining and updating internal R tutorial. Led training sessions for new hires.

  • University of Pennsylvania (Greater Philadelphia Area)
    • Resident Advisor
      Sep 2009 - May 2011 · 1 yr 9 mos

      ▶Oversaw and supported all aspects of residential life and community for 26 freshman residents. ▶Enforced rules, balanced monthly budget, and created weekly residential programming.

    • Information Technology Advisor Manager
      Sep 2007 - May 2011 · 3 yrs 9 mos

      ▶Led computer and networking support for 485 student residents. ▶Leveraged technical skill set to solve cases. ▶Recruited, hired and retained strategically to transition total staff from 13 to 8, cutting costs while maintaining high standards of customer service. Oversaw staff performance, coordinated hours and approved payroll. ▶Named "Most Valuable ITA" in first year of employment.

    • Teaching Assistant (Department of Mathematics)
      Sep 2010 - Dec 2010 · 4 mos

      ▶One of 3 undergraduates selected to lead recitation classes in undergraduate calculus. ▶Supported lectures and student learning by explaining and reinforcing material. Held office hours for additional help. ▶Graded exams and weekly homework assignments.