John Stauffer

About John Stauffer

I enjoy using SQL, Python, and BI tools (Power BI or Tableau) to provide quantitative…

Experience

1. Business Intelligence Manager

   Chargie

   Nov 2021 — Present · Culver City, CA, US

   Architected and implemented ETL processes using Python between the company’s ERP system, CRM, and Project Management tool, collaborating with key stakeholders to understand system requirements and ensuring data quality across systemsPerform database audits using SQL following new app releases to identify any bugs that may affect data quality in the databaseDesigned and implemented database updates to allow for new segmentation of reporting and facilitate new business processes as requiredMoved manual weekly and monthly reporting for sales, product, and construction to Power BI, reducing labor hours spent on reporting by 20 hours per week Created a linear regression model using scikit-learn to predict the number of unique users based on the number of electric vehicle charging station installations over time Wrote SQL queries to calculate customer churn and recovery rates using PostgreSQL, enabling tracking of new product KPIs Collaborated with cross-functional groups to create SOPs for maintaining data quality within the company’s systemsParticipated in peer code reviews to ensure efficient and maintainable code across the data teamGathered requirements for new dashboards and KPIs on an ongoing basis from cross-functional groups, in order to remain one of the subject matter experts on the company’s data sourcesTrained and managed one analyst to fulfill ad-hoc requests and maintain dashboards