Business Intelligence Analyst Resume Example

Senior Business Intelligence Analyst · Salesforce

San Francisco, CA · 2022 - Present

• Led the development and implementation of 10+ critical dashboards in Tableau and Looker, reducing manual report generation time by 30% and improving executive decision-making speed.
• Optimized SQL queries for large datasets, resulting in a 25% decrease in query execution time and enhancing data retrieval efficiency for various business units.
• Mentored junior analysts, improving team's data modeling capabilities and contributing to a 15% increase in project delivery efficiency.
• Collaborated with product and engineering teams to define key metrics and implement robust data tracking, leading to a 5% increase in user engagement for a flagship product feature.
• Managed end-to-end data pipeline projects using Snowflake and Airflow, ensuring data quality and availability for critical business operations.

Business Intelligence Analyst · Dropbox

San Francisco, CA · 2019 - 2022

• Designed and maintained 15+ recurring reports and dashboards using Power BI and Excel, providing weekly performance insights to marketing and sales teams, contributing to a 10% uplift in campaign ROI.
• Performed ad-hoc data analysis using SQL and Python to identify trends and anomalies in user behavior, influencing product roadmap decisions.
• Developed and automated ETL processes for various data sources using Python scripts, reducing data preparation time by 20 hours per month.
• Collaborated with cross-functional teams to gather reporting requirements, translating business needs into technical specifications for data solutions.
• Created comprehensive documentation for data definitions, report logic, and dashboard functionalities, ensuring data consistency and usability across the organization.

Bachelor of Science in Data Science · University of California, Berkeley

Berkeley, CA · 2015 - 2019

• Graduated Magna Cum Laude with a GPA of 3.8/4.0.
• Awarded Dean's List for all semesters of study.
• Completed capstone project on predictive customer churn analysis using Python and machine learning.

Business Intelligence Analyst · Bloomingdale's

New York, NY · 2021 - Present

• Developed and maintained key performance indicator (KPI) dashboards in Tableau, tracking sales trends, inventory turnover, and customer behavior, leading to a 15% improvement in merchandising decision-making efficiency.
• Executed deep dive analyses on seasonal campaign performance, identifying critical success factors that informed future strategies and contributed to a 10% increase in Q4 online sales year-over-year.
• Automated weekly and monthly reporting processes using SQL and Python, reducing manual effort by 20 hours per month and improving data delivery timeliness by 24 hours.
• Collaborated with marketing teams to analyze customer segmentation, resulting in targeted campaigns that boosted email conversion rates by an average of 8%.

Senior Data Analyst · Etsy

Brooklyn, NY · 2019 - 2021

• Designed and implemented A/B tests for new product features and marketing initiatives, providing data-driven recommendations that increased user engagement by 6% and purchase intent by 4%.
• Performed comprehensive funnel analysis to identify conversion roadblocks, leading to UI/UX improvements that uplifted checkout completion rates by 5.5%.
• Developed and optimized complex SQL queries to extract, transform, and load data from various sources (BigQuery, Snowflake), supporting ad-hoc analysis for product and engineering teams.
• Created interactive dashboards using Google Data Studio to monitor seller performance and buyer satisfaction, enabling timely interventions that improved seller retention by 7%.

Data Analyst · Retail Analytics Consulting

Newark, NJ · 2017 - 2019

• Analyzed point-of-sale (POS) data for multiple retail clients, identifying regional sales trends and recommending promotional strategies that increased average transaction value by 3%.
• Assisted in building predictive models for inventory forecasting, reducing stock-outs by 10% and minimizing overstock situations for small to medium-sized retail businesses.
• Prepared detailed reports on customer demographics and purchasing patterns, providing insights that helped clients optimize store layouts and product placements, resulting in a 2% sales lift.
• Utilized Excel and basic SQL for data cleaning, aggregation, and initial visualization to support senior consultants in client presentations.

Master of Science in Business Analytics · New York University (NYU)

New York, NY · 2016 - 2018

• Thesis on predictive customer lifetime value in e-commerce, achieving 88% model accuracy for top-tier customers.
• Developed machine learning models for market basket analysis, identifying cross-selling opportunities for a 7% average uplift.

Bachelor of Science in Business Administration, Marketing Specialization · Rutgers University

New Brunswick, NJ · 2012 - 2016

• Led a student consulting project for a local retail business, optimizing their inventory strategy which reduced excess stock by 12%.
• Awarded 'Outstanding Achievement in Marketing Analytics' for a capstone project predicting campaign effectiveness.