Your Name
Data Analyst — SQL, Product Analytics, and BI Dashboards
City, ST · (555) 010-0142 · you@email.com · github.com/yourname
Professional Summary
Data analyst with four years of experience turning product and customer data into decisions for growth, marketing, and finance teams. Writes production SQL, builds dbt models and Tableau dashboards, and analyzes experiments in Python. Known for defining metrics carefully, documenting assumptions, and presenting results in a way busy stakeholders can act on.
Skills
SQL (window functions, CTEs, query tuning) · Python (pandas, NumPy, Jupyter) · Excel (pivot tables, Power Query, XLOOKUP) · Tableau and Power BI · Looker and LookML · dbt and data modeling · Snowflake and BigQuery · A/B testing and experiment analysis · Cohort, funnel, and retention analysis · Descriptive statistics and regression · Data cleaning and validation · Stakeholder reporting and data storytelling
Experience
Data Analyst II
2023 – Present
Subscription software company, product analytics team · City, ST
- Built and maintain a Tableau executive dashboard covering activation, retention, and revenue, refreshed daily from dbt models and reviewed in the weekly leadership meeting.
- Analyzed a two-arm onboarding experiment in Python, showing a 6% lift in seven-day activation with a confidence interval that excluded zero, which led to a full rollout.
- Rewrote a set of slow reporting queries in Snowflake using CTEs and pre-aggregated tables, cutting dashboard load time from about 40 seconds to under 5.
- Defined a single company-wide definition of “active user” with product and finance, ending conflicting numbers across three teams’ reports.
- Ran a cohort retention analysis that identified a drop-off in month two for annual-plan customers and fed directly into a new renewal campaign.
Junior Data Analyst
2021 – 2023
Regional retail chain, finance and merchandising · City, ST
- Automated a weekly store performance report with SQL and Power Query, replacing roughly six hours of manual copy-and-paste work in Excel.
- Built Power BI reports on sales, margin, and stock levels for 30 store managers, with row-level security by region.
- Cleaned and reconciled point-of-sale and inventory data, documenting recurring data quality issues and the fixes agreed with IT.
- Produced a markdown analysis that helped merchandising adjust end-of-season discounts on slow-moving categories.
Education
- Bachelor of Science in Economics — University Name, City, ST
Certifications
- Google Data Analytics Professional Certificate — list only if held
- Current Microsoft Power BI certification — use the exact credential name the provider shows; list only if held
Projects
- Public transit ridership analysis in Python and Tableau Public — portfolio link