select * from katie.intro_blurb
Data and analytics engineer and analyst focused on the developer tool space. I'm a passionate learner who loves a challenging problem to solve and I thrive in a workplace where I am able to level up my skills and also mentor others who are trying to level up their skills. I have an eye for automation and creating efficient data solutions for the people I work with. I've worn a lot of hats in my 15+ years in technology roles and I think they are all pieces in the very unique experience puzzle that is me.
select * from katie.core_skills
Data cleaning & analyzing
Using SQL & Python to clean, analyze and visualize data. I pretty much use both every (work) day!
Documentation
I believe documentation in any project is just as important as the project itself. I love to organize and document a project. I think almost everything should have a URL, especially in a remote working environment.
Data modeling
Taking raw disjointed datasets and transforming them into usable, business friendly entities that folks with little to no SQL knowledge can use.
Mentorship
I love learning and I love passing along my learnings to other folks. I thrive in roles where I can be mentored and I can pass along skills i've learned to others.
Data automation
Using tools like Fivetran and Airflow to automate data loading processes. Writing Python scripts and Jinja macros to make my life a little easier. Building reports to monitor data quality and issues in an automated way.
Executive presence
I have a ton of experience presenting to leadership and executive teams as well as putting together quarterly board and investor reports. If you'd like some samples of this work please let me know!
select tools, companies, communities from katie.experience
Volunteering & misc. communities
2022 - current
Data Angels
a data Slack community for women
2020 - current
Good Food Project (412 Food Rescue)
a non-profit in Pittsburgh aimed at reducing local food insecurity issues
Tool experience
​
-
Fivetran and Airflow for data pipelines
-
GitHub for software development
-
dbt for data modeling
-
Snowflake & BigQuery for data warehouseing
-
Mode, Hex & Looker for data visualization
-
Census & Hightouch for reverse ETL
-
Segment for event logging
-
Various APIs for doing fun side projects
-
Salesforce for the customer lifecycle
Where i've worked
2024 - current
Analytics Engineer
Neon
2021 - 2024
Analytics Engineer & Analyst
PlanetScale
2020 - 2021
Senior Data Analyst
GitHub
2015 - 2020
Senior Product Manager
GitHub
2014 - 2015
Technical Product Lead
MagmaLabs
2009 - 2014
Technical Project Manager
ModCloth