Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Lead Efficiency Data Engineer
MetaLead Efficiency Data Engineer
Feb. 2019 - Feb. 2025Greater Seattle Area* Project lead to improve "freshness" of data to ML models, saving $500M/year in 2023. Mapped and priority ranked all 20,000+ critical paths for data flows to ML training, and drove effort to improve reliability and performance of these data flows. * Migrated 2.5 million cpu-days and 440 PB worth of daily data warehouse workload from Hive from Data Warehouse to Spark and/or Presto. Saved $20mil/year in efficiency gains. * Ascended to Efficiency Ninja, helping manage a program of data efficiency across the company. Held regular office hours unblocking ~200 teammate’s projects helping find ways out of stifling performance issues. * Automate the detection of inefficient pipelines, automatically fixed them provided recommendations across 80000+ pipelines in the warehouse, saving $53mil/year in 2021
Contract Data Engineer at Facebook
VertisystemContract Data Engineer at Facebook
Jul. 2018 - Feb. 2019Seattle, WashingtonImprove the execution of Hive data pipelines moving trillions of records, petabytes of data, and migrate them to run using more modern engines like Spark or Presto. In the first two months, saved almost 2000 CPU-days/day equating to ~ $1.5 million saved per year, and directed pipeline owners where possible on how to self-migrate, saving even more. Applied data science skills to drive work where it would have the most impact, collecting pipeline metadata, creating scoring model, classifying ones which would likely benefit from manual intervention to improve efficiency.
Contract Data Engineer and Data Scientist
Apex SystemsContract Data Engineer and Data Scientist
Apr. 2018 - Jul. 2018Seattle, WAAdvancing oversight capability of Amazon Pets group through the use of advanced analytics, data analysis, predictive modelling to optimize various supply chain costs, promote in-stock metrics, and understanding parity with competitors.
Contract Data Engineer and Data Scientist
Unify ConsultingContract Data Engineer and Data Scientist
Oct. 2017 - Jan. 2018Greater Seattle AreaClassified marketing leads for Microsoft’s C+E division to find ways to increase Known Leads, MAQLs, and SQOs. Reported on trends with Microsoft’s marketing lead funnel metrics from Marketo
Lead Business Intelligence Developer / Advanced Analytics / Data Scientist
Brooks RunningLead Business Intelligence Developer / Advanced Analytics / Data Scientist
Apr. 2015 - Oct. 2017Fremont, Seattle, Washington Developed risk reduction models to predict credit default potentials among Brooks customers. Used Python, scikit-learn, logistic regression.  Doubled loading speed for reports and dashboards through code improvements. Reduced EDW loading time by 90% by rewriting SQL stored procedure transforms for data quality/efficiency. Established unit testing of transact-sql (t-sql) transforms, coding standards, two-week Agile sprints.  Reduced report generation costs by hundreds of man-hours through data visualization and advanced analytics of sales trends using Tableau. Worked with Sales Rep Managers and VP of Sales to address latency, slowness, bad data and other concerns. Developed Tableau Sales Dashboards fed by data warehouse data, live source data, and data fed from retailers.  Created predictive model from thousands of runners' biometric data for a shoe recommender application. Model was built in Python using multinomial logistic regression and K-means clustering. Advised lab scientists on experimental designs, data collection, feature generation.  Served on Enterprise Data and Advanced Analytics Committee promoting company-wide data-driven decision making.
Lead Enterprise Data Warehouse Developer
Seattle Children'sLead Enterprise Data Warehouse Developer
Jun. 2012 - Apr. 2015Greater Seattle Area• Led team in building clinical data warehouse on IBM Netezza, transforming billions of records for various projects. • Doubled EDW refresh speed by optimizing SQL, data structures, and job steps, saving time for upstream teams. • Improved productivity with test-driven development, data quality framework, and standardized release processes. • Mentored analysts/developers on SQL query and Tableau classes, enhancing self-service capabilities across the hospital.
Senior Data Engineer
University of WashingtonSenior Data Engineer
Aug. 2010 - Jun. 2012Harborview Medical Center, Seattle, WA Drove 100x increase in real-time EDW load performance of discrete clinical events using C#, micro-batching to SQL Server.  Architected financial, clinical data marts in SQL, SSAS, SSIS, including one for the Harborview Budget Director and the Daily Flash Report using SSRS and later Tableau
Senior Full Stack Software Engineer
Arizona State UniversitySenior Full Stack Software Engineer
Jan. 2008 - Jan. 2010Phoenix, Arizona Area Created an estimated savings of $200K per year by improving nursing student admission processes and increasing speed of admissions by writing a web-based system to automate the complex processing of incoming Nursing students, using Java, JSP, Spring, Maven, Oracle, calling on various university and external web-APIs for coursework, grades, immunizations, exam scores.  Played a critical role in implementing GE Centricity EMR for health clinics, transferring all patient data, and rewriting all extracts to provide data to grant providers including Title X.  Automated time-consuming data transformation tasks using Transact-SQL previously performed by clerical staff. Optimized databases running on SQL Server, MySQL
Full Stack Software Engineer
Rhino Internet SolutionsFull Stack Software Engineer
Jan. 2007 - Jan. 2008Tempe, AZ Helped design and build Head2Head.com, a fantasy football site for TimeWarner. Gathered technical specifications. Developed conceptual/logical/physical data models. Worked closely with graphics designers and implemented use cases. Followed Agile project management on all projects and led scrum.  Designed and optimized databases on MS SQL Server, MySQL, and Oracle. Used C#, Java, Transact-SQL, SSIS, Perl, and PL/SQL for data transformation.
Front-End Software Engineer
Arizona State UniversityFront-End Software Engineer
Jan. 2006 - Jan. 2007Tempe, AZReduced form handling errors by 90% by designing and building a complex student form tracking system in C# for ASP.NET to handle many time-consuming tasks within the College of Liberal Arts and Sciences.

Requests

Touchpoint image
0
Service Pitch
Data-Driven Strategy Consulting Expertise
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Andrew on Intch
IT
451129 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
ITData Engineer
35446 people
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC
33
Investor Relations Manager @ ExxonMobil