- Built Looker dashboards for Finance and Product to monitor revenue and customer usage data.- Created Airflow jobs and Python scripts to import and refresh data using APIs as well as Fivetran.- Transformed raw data in dbt with Jinja templating and macros, creating 100+ tests for staging models.- Improved our processes by optimizing warehouse sizes for models, creating/enforcing a style guide for dbt, expanding the Confluence documentation.

- Built models in dbt using SQL and Jinja to create dashboards in Looker for executives and other stakeholders to be able to self-serve acquisition funnel, car insurance policy, and machine learning data- Presented dashboards, reports, experiment results to large Zoom audiences with executives, engineers, and non-technical members- Onboarded new data analysts, teaching them our processes, data best practices, and data solutions by training them to use Looker, dbt, and GitHub- Led projects involving data analysts, analytics engineers, and software engineers to meet compliance requirements through internal reporting software

- Support the company, particularly the Learning Experience/Product, Real Estate, and Marketing team with ad hoc data requests, forecasting models, reporting systems, data automation, dashboards, and performance metrics that support key business decisions in student performance, finance, marketing, business development/strategy, product analysis using Looker and SQL- Build Python-based data pipelines with Heroku pulling from APIs (Squarespace, Brandfolder, Google Sheets, Chargedesk, etc.) to RedShift- Manage and optimize processes for data ingestion, validation, and engineering, and identify risks in existing processes and recommend controls/governance- Communicate results and business impact of insights and initiatives to stakeholders across teams through Looker dashboards, spreadsheet reports, and presentations

- Developed Transition State Theory software using Python, NumPy, Matplotlib with Dr. Juliana Duncan- Mentored students one-on-one in lab hours and in class for three years to help them learn to code and research- Facilitated collaboration among project groups

- Graded homework for 200 students with personal feedback for two linear algebra classes- Corresponded with tenured and non-tenured professors on the specifications for assignments

- Monitored data to diagnose operational issues using Python, Pandas, and Bokeh- Analyzed trade data to evaluate quality per vendor- Sped up webpage rendering and search functionality by backend rendering and organize data with PostgreSQL- Created a portable Docker instance of Airflow and wrote documentation for developers to run scheduled local scripts- Generated job data monitors with alerts to indicate job failures, using Grafana and InfluxDB