Joseph Erlanger Email and Phone Number

As Klim's first dedicated data hire, I'm building end-to-end analytics infrastructure; driving data-first culture; and enabling and providing insights to further Klim's regenerative vision for agriculture.

Provide one-on-one career mentoring and technical project evaluations for classes of up to 20 analytics students.Topics covered range from soft (structuring analytic approaches, stakeholder management, presenting findings) to hard (SQL, Python, Tableau, database design, change management, A/B testing).

Evaluated and built PostgreSQL architecture and ETL pipelines for the collation of 4 TB of open-source academic literature and carbon dioxide removal sentiment data for the ERC-funded “Geoengineering and Negative Emissions Pathways in Europe” project.Initial analyses and MVP for best-fit data APIs and engineering requirements were conducted by me. Analyses were done in Python and the project was managed via Kanban method.The database was built using PostgreSQL 14 hosted on an Ubuntu server and featured three main academic schemas with heavy use of gin and trigram (pg_trgm) indexes to enable full-text search. This allows MCC's data scientists and climate researchers to build relevant datasets for NLP models using complex boolean logic.ETL was scheduled by simple crons with Python and bash scripts with the plan to run off of Apache Airflow / dbt. DBA and DevOps were also handled by me.

Head of data governance initiatives and data value maximization for international AdTech company. Data Value MaximizationPrimary stakeholder for petabytes of data across a wide range of databases, data lakes, and data warehouses, including: AWS (S3, Redshift, Athena), GCP (GCS, BigQuery), Apache Spark instances, and self-hosted SQL and NoSQL solutions. We analyzed opportunities to enhance revenue through cost-savings (e.g. data retention reduction, infrastructure improvements) or additional sales potential (e.g. new data products, enhancing existing ML models and products) and coordinated between technical and non-technical departments to implement projects.Data Governance InitiativesImproved cross-departmental confidence and data-based decision-making capabilities by incorporating data policies, standards, compliance, and data management principles into the data strategy: • Improved data standards and data quality. • Led agile optimization assessments and exercises to reduce cross-database redundancies. • Created a universal "source of truth" for data and KPIs by implementing data cataloging (AWS Glue, Amundsen) • Established monitoring and prevention frameworks to mitigate data abuse and privacy risks and test resiliency.

Integrated EU data science product and team acquisitions into US operations and business strategy. Led team and advised US and EU data teams.Coordinated the launch of commercial data product with $6M annual revenue.Automated data quality testing using Spark and Python (PySpark) with AWS EMR.Led implementation and enforcement of GDPR and CCPA privacy frameworks.Supervised redesign of internal analytics and data science architecture. Spearheaded investment in Looker analytics tool for 200 employees.

Managed a team of 5 analysts responsible for analytics, modeling, alerting, dashboarding, and reporting for all departments and the C-suite. These were accomplished primarily through SQL (AWS Redshift, GCP BigQuery), Python, and low-code dashboard and visualization tools like Tableau and GoodData. Queries were managed through git to reduce errors.Created interview process and SQL and logic tests for the hiring of additional analysts. Managed the daily work through the Kanban method, allowing further integration with relevant engineering teams working in scrum.Optimized data models for AWS Redshift, GCP BigQuery, and AWS Athena databases and ETL pipelines via Apache Airflow.Tested prototypes and validated new data tools and R&D initiatives for engineering teams.Led company-wide seminars and trainings including designing SQL training program for 100 employees.

Performed analyses, KPI development, A/B testing, reporting, and dashboarding for all departments and series funding rounds.Gave weekly state-of-company KPI presentations at all-hands meetings.Designed competitive indexing tool for ad campaign benchmarking, improving average budget by 5%.

Salesforce admin and sales analyst. Implemented a new company-wide ticketing platform. Led data integrity and sales reporting initiatives.Provided campaign optimization recommendations and monitored exchange yield, increasing campaign budget fulfillment by 6%.

Internship in operations analytics, focusing on airport efficiency for New York, Europe, and Asia operations.