ZYED AZIZI
Sacramento
Summary
Results-driven Data & BI Analyst with expertise in SQL and Power BI, previously at True Renewable Energy. Enhanced sales efficiency by translating complex metrics into actionable insights, while automating dashboards that reduced reporting time by 60%. Strong collaborator with a proven track record in KPI tracking and revenue optimization.
Overview
6
6
years of professional experience
Work History
Data & BI Analyst
True Renewable Energy
01.2022 - Current
- Owned analytics for marketing, sales, and financial operations across renewable-energy programs, delivering insights that improved conversion rates and revenue forecasts.
- Automated Power BI dashboards using SQL + DAX to unify CRM, ad, and finance data; cut manual reporting time by 60%.
- Developed KPI frameworks tracking CAC, ROI, and lead-to-install rate, increasing lead quality by 20%.
- Collaborated directly with executives to translate complex metrics into business actions, driving 10% improvement in regional sales efficiency.
- Streamlined weekly data refreshes with Python scripts, ensuring real-time reporting accuracy across 50K + records.
Marketing & Data Analyst
RibbonCurler LLC
07.2020 - 12.2021
- Owned end-to-end analytics for a 7-figure Shopify brand, managing sales, traffic, and marketing data across paid ads, email, and organic channels.
- Built automated dashboards in Power BI + SQL to monitor KPIs - revenue, CAC, retention, LTV, and ROAS - giving leadership real-time visibility into brand performance.
- Analyzed ad spend and funnel data across Facebook, Google, and Klaviyo campaigns, uncovering optimization opportunities that increased ROAS by 35%.
- Implemented cohort & retention tracking, identifying repeat-purchase patterns that improved customer lifetime value by 22%.
- Collaborated with marketing and operations teams to forecast demand, plan inventory, and align budgets - reducing overstock by 30% while maintaining fulfillment speed.
- Consolidated sales and marketing data pipelines from Shopify, GA, and CRM into clean datasets for faster weekly and monthly reporting.
- 7-Figure eCommerce Brand
Operations Intern
California Energy Network
Sacramento
01.2020 - 06.2020
- Assisted in data collection and quality assurance for state energy efficiency projects.
- Used Excel macros to track program performance and generate reports for senior analysts.
Education
B.S. - Computer Science
California State University
Sacramento, CASkills
- SQL and Python
- Data analysis with Pandas
- Data visualization with Power BI
- Spreadsheet management with Excel
- Pivot table creation
- Power Query expertise
- Tableau proficiency
- Cohort and funnel analysis
- KPI tracking and forecasting
- ROI optimization strategies
- Dashboard automation techniques
- Google Analytics insights
- Azure data concepts
- Shopify analytics integration
- CRM systems management
- HubSpot and Salesforce expertise
Projects
Sales Performance Dashboard, Built SQL queries and Power BI visualizations to track sales KPIs, reducing reporting time from 6 hours to 1 hour. Ad Campaign ROI Analysis, Analyzed ad platform data to evaluate spend vs. revenue; identified optimization opportunities boosting CTR by 15%.
Timeline
Data & BI Analyst
True Renewable Energy
01.2022 - Current
Marketing & Data Analyst
RibbonCurler LLC
07.2020 - 12.2021
Operations Intern
California Energy Network
01.2020 - 06.2020
B.S. - Computer Science
California State University