Jonathan Rockower Email & Phone Number

San Francisco, Ca, Us

As a Senior Data Engineer (B2C) I turn business needs from internal leaders into data pipelines used across teams within Glassdoor to support our internal data infrastructure. Using tools such as Airflow, I have designed, developed, tested, and deployed to production many ETL pipelines across our petabytes-level data warehouse to deliver tested data on a regular schedule to meet stakeholder SLA requirements. In collaboration with product owners, engineering teams, and stakeholders, I build easy-to-understand tables and metrics to meet business needs, support growth, and allow for internal performance transparency.• Leading a proof-of-concept initiative with Confluent Kafka to reduce latency and cost (by 10s of thousands of dollars) of consumer metrics from daily batch processing to near real-time, using Kafka to transport data from MSSQL, transform data in ksqlDB, and send to Rudderstack with Confluent connectors• Developed ETL pipeline to assist in migration of A/B testing framework to Optimizely, using the Optimizely API to download batch A/B testing events, S3 sensors to check when data has landed, and a custom Hive operator to clean data

San Francisco, Ca, Us

• Technologies/Languages: Airflow; Hive; Python; SQL; Hadoop; Presto; AWS S3 and EMR; Shell Scripting; Git; Bitbucket/Stash; GitLab; Jenkins; Ambari; Jira; Asana• As a B2C Data Engineer, I developed an Airflow DAG to power a Tableau dashboard for the CEO and other executives to monitor customer and business performance, such as the millions of users and registrations to the site. • I worked alongside the Data Science and BizOps teams to understand requirements, develop, test, and deploy this DAG to meet a daily SLA for key executives, with a focus on timely, accurate, and easy-to-understand results.• Utilize Airflow for ETL processing: ingest many source data formats (ORC, Parquet, Avro, TXT, JSON, CSV), transform the data using Hive, and ultimately load the data to the target destination.• Tune Hive queries to improve performance in the Data Warehouse via query monitoring in the Ambari UI.

Chicago, Il, Us

- Automated a data ingestion pipeline by developing a shell script script to execute a sequence of R script to extract data from the Energy Information Administration API, a process that previously was done manually- Evaluating the economic costs of the Jones Act by estimating the costs of wasteful imports and exports through analysis in R of U.S. imports and exports of oil and refined products

- Researching nationwide property tax assessments by local tax assessors to determine levels of tax regressivity, where low-value homes are assessed at a higher percentage of their true market value than are high-value homes- Analyzing nationwide property tax data utilizing R and R Markdown to generate automated reports

San Francisco, Ca, Us

- Managed and collaborated with teams of of 3 – 12 members to perform financial, economic, and statistical analysis for litigation matters for Fortune 500 companies in cases with potential losses of $20 million – $1+ billion- Worked on regulatory investigations, corporate finance, and securities litigation- Supervised a team of 8+ analysts to prepare formal exhibits as part of research into Consumer Financial Protection Bureau (CFPB) enforcement actions, published in a legal journal- Led team of 7 analysts to conduct extensive data analysis in R (tidyverse) and built charts using ggplot2 to investigate rates of warranty claims on a case involving heavy-duty truck engines- Directed office non-billable projects: Analyst Recruiting Co-Head Social Committee Head; CFPB Enforcement Actions Publication Analyst Co-Head

San Francisco, Ca, Us

- Led team of 7 analysts to conduct extensive data analysis in R (tidyverse) and built charts using ggplot2 to investigate rates of warranty claims on a case involving heavy-duty truck engines- Performed multivariate regression analysis in Stata on stock time series data as part of securities litigation matters- Directed office non-billable projects: Northwestern University Recruiting Co-Head

San Francisco, Ca, Us

- Utilized SAS and SQL to conduct in-depth financial analyses on large datasets (100+ million observations) to assess damages scenarios for a benchmark interest rate manipulation case

Evanston, Il, Us

Performed research on the effects of student debt for former Chief Economist at the Department of Treasury Analyzed data to determine the value of Mortgage Backed Securities given easier access to refinancing of mortgages

Addressed constituents’ inquiries and needs via phone and referred to appropriate resources or contacts Researched district issues to prepare office for meetings between Congressman Pascrell and dignitaries within the district on issues such as the continuing support needed for Hurricane Sandy victims

Parsippany, New Jersey, Us

Updated and reviewed hundreds of files on a daily basis to facilitate collections Communicated with courts to monitor the status of cases and to confirm case progress

Conducted research on new towns added to district to improve the assemblyman’s knowledge of unique issues among these new towns Produced 10-15 page reports of information summarizing key facts and issues about the new towns Prepared campaign office in West Orange for successful re-election by staffing campaign events

Master Of Science - Ms, Computational Analysis And Public Policy

Bachelor'S Degree, Mathematical Methods In The Social Sciences, Economics, Financial Economics, Political Science

High School