Jeff Erickson Email & Phone Number

Porvoo, Fi

Helsinki, Uusimaa, Finland

New York, New York, United States

• Contributed as technical lead to the Supply Chain Team, responsible for software which fulfills orders of frozen food products to 48 US states using multiple fulfillment centers and carriers• Lead large-scale integration project with fulfillment centers to streamline the order fulfillment process using Apache Airflow• Designed and built inventory management system for tracking inventory across entire network of manufacturers and shipping centers using event sourcing/CQRS model… Show more • Contributed as technical lead to the Supply Chain Team, responsible for software which fulfills orders of frozen food products to 48 US states using multiple fulfillment centers and carriers• Lead large-scale integration project with fulfillment centers to streamline the order fulfillment process using Apache Airflow• Designed and built inventory management system for tracking inventory across entire network of manufacturers and shipping centers using event sourcing/CQRS model, multiple cloud technologies, Go, and Protocol Buffers• Built system to allow for Operations to make regular changes to shipping configurations based on geography• Designed and contributed to a system to better optimize dry ice levels used per order• Developed internal software development kit to streamline development of internal Apache Airflow projects• Mentored junior and mid-level engineersPrevious role:Senior Software Engineer (September 2019 - July 2020) Show less

New York, New York, United States

• Contributed as a member of the Data Import Team on Moat Analytics, a platform for collecting and reporting digital advertising viewability statistics• Developed and maintained ETL pipelines in Python, processing TBs of data per day from third-party APIs and FTP servers using Airflow, Hive, and AWS services, such as ECS, EMR, Athena, S3/Glacier, and SQS• Refactored and unified disparate legacy codebases into a modern ETL system using Airflow and Python 3• Deployed and managed all… Show more • Contributed as a member of the Data Import Team on Moat Analytics, a platform for collecting and reporting digital advertising viewability statistics• Developed and maintained ETL pipelines in Python, processing TBs of data per day from third-party APIs and FTP servers using Airflow, Hive, and AWS services, such as ECS, EMR, Athena, S3/Glacier, and SQS• Refactored and unified disparate legacy codebases into a modern ETL system using Airflow and Python 3• Deployed and managed all AWS infrastructure using Terraform• Maintained CI/CD pipelines using Jenkins and Gitlab• Developed and maintained unit and integration tests using Pytest, moto, etc.• Provided on-call support ensuring uptime of all ETL systems and troubleshooting when necessary Show less

New York, New York, United States

• Contributed as a member of SA Technology's engineering team, the Automation Team• Designed and developed backend REST APIs and microservices using AWS (Lambda, SNS, API Gateway, S3, etc.) for various projects, both internal- and external-facing, implementing event sourcing and CQRS if appropriate• Designed and developed frontend interfaces using Angular for SA Families, an external, family-facing website• Maintained and developed ETL processes between SA’s two student information… Show more • Contributed as a member of SA Technology's engineering team, the Automation Team• Designed and developed backend REST APIs and microservices using AWS (Lambda, SNS, API Gateway, S3, etc.) for various projects, both internal- and external-facing, implementing event sourcing and CQRS if appropriate• Designed and developed frontend interfaces using Angular for SA Families, an external, family-facing website• Maintained and developed ETL processes between SA’s two student information systems• Designed and developed an internal framework called Submarine to allow rapid development of Periscope (SQL-based) dashboards by other developers and analysts• Designed and developed web apps enabling school staff to make data-driven decisions based on current and historical academic and culture data• Consulted on the creation and administration of internal survey initiatives to ensure representative data was being collected• Designed and developed a number of Slack bots used by staff across the organization• Re-factored legacy codebase and database design for efficiency• Negotiated and managed vendor contractsPrevious role:Research Scientist (October 2015 - April 2017) Show less

New York, New York, United States

• Managed team of 3 policy analysts to develop, analyze, and report on school accountability policies and initiatives• Implemented new quantitative principal evaluation system for over 1600 school principals• Developed new measure of student poverty using a blend of internal data and census data• Developed student grouping algorithm with concurrent Python and Go to measure achievement of “similar” students• Performed ad-hoc analyses using SAS, R, and SQL, often with data sources… Show more • Managed team of 3 policy analysts to develop, analyze, and report on school accountability policies and initiatives• Implemented new quantitative principal evaluation system for over 1600 school principals• Developed new measure of student poverty using a blend of internal data and census data• Developed student grouping algorithm with concurrent Python and Go to measure achievement of “similar” students• Performed ad-hoc analyses using SAS, R, and SQL, often with data sources of 1 million+ observations• Led introductory R trainings attended by over 50 colleagues and presented on various topics such as using Git and RStudio/RMarkdown for data analysis projects via the DOE Analytics Club• Led trainings for educators and parents on how to understand and use public reports of school qualityPrevious role:Associate Director, Office of School Performance (October 2013 - November 2014) Show less

New York, New York, United States

• Managed team of 2 network staff and 22 school staff to collect, analyze, and report academic data• Designed, developed, and implemented an academic data warehouse using MySQL for storage of all internal data, and developed software to leverage this database and automate many forms of internal reporting• Conducted internal research and analysis using collected data• Produced many reports of internal accountability used by school leaders, teachers, CEO, and board members•… Show more • Managed team of 2 network staff and 22 school staff to collect, analyze, and report academic data• Designed, developed, and implemented an academic data warehouse using MySQL for storage of all internal data, and developed software to leverage this database and automate many forms of internal reporting• Conducted internal research and analysis using collected data• Produced many reports of internal accountability used by school leaders, teachers, CEO, and board members• Coordinated and developed data-related trainings for school-based staff• Managed forms of external accountability, including city/state government and grant reporting• Managed external vendors, contracted software developers, and seasonal internsPrevious roles:Data and Accountability Manager (June 2012 - April 2013)Data and Accountability Associate (June 2011 - June 2012)Data and Accountability Assistant (August 2010 - June 2011) Show less

New York, New York, United States

New York, New York, United States

New York, New York, United States

New York, New York, United States

New York, New York, United States

Seattle, Washington, United States

Master Of Arts (M.A.), Statistics

Capstone: Two Americas in Tweets: A Method for Analyzing Twitter Data with Structural Topic Models

Bachelor Of Arts (B.A.), Mathematics

Master Of Arts (M.A.), Mathematics Education

New York State Teaching License also acquired

Swedish Language And Literature