Sofia Alvarez
Data Analyst
Milwaukee, WI 路 (414) 555-0186 路 sofia.alvarez@example.com 路 linkedin.com/in/example
Summary
Data analyst with almost two years of data analysis and business analytics in retail and insurance, after a statistics degree and a data analytics internship. Writes SQL queries, cleans and validates data in Python and Microsoft Excel, and builds Power BI and Tableau dashboards that turn complex data sets into data driven decisions for finance, marketing and supply chain teams.
Education
B.S. in Statistics, minors in Mathematics and Computer Science, Lakeshore State University, 2024
Skills
- Programming languages
- SQL, Python (pandas), R
- Analysis
- Microsoft Excel (pivot tables, formulas), Google Sheets, Statistical analysis, A/B testing
- Business intelligence
- Power BI, Tableau, Dashboarding, Data visualization, KPIs
- Data
- Data cleaning, Data quality
Experience
Data Analyst I, Northfield Grocers
Milwaukee, WI 路 2025 to present
- Built Power BI dashboards on store KPIs for 60 managers from SQL queries against the sales database, replacing a weekly Microsoft Excel pack.
- Cleaned and validated 3 years of supply chain data in Python, raising data accuracy on vendor lead times from 82% to 99% before a forecasting project.
- Helped run exploratory data analysis on promotions for the marketing team and presented the findings with Tableau data visualization for promotion optimization.
- Added data quality checks to the nightly sales refresh, catching 95% of data integrity issues before reports go out.
- Led data collection and data manipulation on 1.2 million loyalty records in Python for the data science team, giving its first churn model a clean training set.
- Pulled 3 years of point of sale data with SQL for a pricing review, then handed the queries to the engineers who now run them daily.
- Helped test a new SQL formatting tool, which the team later adopted.
Data Analytics Intern, Bluewater Mutual Insurance
Madison, WI 路 Summer 2024
- Created a claims report in SQL and Excel pivot tables for the finance team, covering 15,000 claims a month and used in every monthly close since.
- Documented the plan in Microsoft Office for a customer data migration of 200,000 records, presenting weekly status in Microsoft PowerPoint to the leadership team.
- Helped automate recurring Excel reports with Python and joined the data management review.
Capstone Project, Hospital Readmission Analytics, Lakeshore State University
Milwaukee, WI 路 2024
- Applied quantitative methods, statistical analysis and machine learning in Python to a public healthcare data set of 100,000 admissions.
- Designed an interactive Tableau dashboard of readmission risk across diagnoses.
- Modeled the data in a relational database, with SQL and Python coding for every query.