Owen Barrett
Data Analyst, Product and Revenue Analytics
Minneapolis, MN | owen.barrett@example.com
Professional summary
Data analyst with 4+ years of experience transforming raw data into actionable business insights using SQL, Python, and Tableau. Known for building self-service dashboards, automating recurring reports, and identifying revenue opportunities through exploratory analysis.
Experience
Data Analyst
Subscription software company (12 million events a day) · Minneapolis, MN · 2022 to Present
- Built 12 Tableau dashboards used by marketing, sales, and product teams to track KPIs, reducing ad-hoc reporting requests by 45%.
- Wrote complex SQL queries across 3 data warehouses to identify a $600K revenue leakage in the subscription billing pipeline.
- Automated weekly reporting workflows using Python (pandas, schedule), saving the analytics team 10+ hours per month.
- Partnered with product managers to design A/B test frameworks, contributing to a 15% improvement in onboarding conversion.
Business Intelligence Analyst
Retail chain (60 stores) · Minneapolis, MN · 2020 to 2022
- Modeled 40 source tables into a star schema and cut the nightly warehouse run from 95 to 38 minutes.
- Built a store performance dashboard adopted by 60 store managers and the regional team inside one quarter.
- Found a 210,000 dollar annual markdown leak by joining the promotion calendar to item-level margin.
- Replaced 11 manual spreadsheet reports with scheduled queries and freed about six analyst hours a week.
Reporting Analyst
Insurance brokerage · St. Paul, MN · 2019 to 2020
- Wrote SQL for more than 30 recurring client reports and documented each definition in a shared metric glossary.
- Cleaned a 400,000-row policy dataset and cut duplicate records from 4.1% to 0.3%.
- Automated month-end reporting with a scheduled Python job and removed two days of manual work.
- Trained four account managers to pull their own numbers from the reporting tool.
Education
- B.S. Statistics | State university | 2019
Certifications
- Tableau Desktop Specialist | 2023
Skills
SQL · Python (pandas, NumPy) · Tableau/Power BI · Data visualization · Excel/Google Sheets · A/B testing · Data warehousing · Statistical analysis