Junior Data Analyst

Junior Data Analyst — Apex Consulting Group

Charlotte, NC | June 2024 – Present

• Cleaned and processed 5M+ raw transaction records using Python (Pandas) and SQL, improving overall database query performance by 22% and reducing ETL pipeline runtime by 15 minutes daily.
• Designed and maintained 8 interactive Tableau dashboards for senior leadership, increasing user adoption rate by 30% and enabling faster weekly operational decision-making.
• Collaborated with 3 senior consultants to deliver client-facing data insights, identifying $45,000 in supply chain inefficiencies for a major professional services client.
• Automated weekly business performance reporting pipelines using SQL stored procedures and Python scripts, saving 8 hours of manual data entry work for the consulting team each week.

Data Analyst Intern — Beacon Advisory Services

Charlotte, NC | June 2023 – May 2024

• Conducted statistical analysis on 12 client datasets using R and Excel, identifying key market trends that supported a 15% increase in lead generation for professional services campaigns.
• Drafted 25+ comprehensive documentation pages detailing data definitions, schemas, and pipeline processes, which successfully reduced onboarding time for 5 new hires by 3 weeks.
• Assisted in auditing data quality across 4 legacy client databases, identifying and correcting 1,400+ duplicate records, which successfully improved reporting accuracy by 19%.
• Supported senior analysts in preparing weekly PowerPoint slide decks for 12+ corporate client presentations, using clear visualizations to communicate statistical insights and key project KPIs.

SQL, Python, R, Tableau, Power BI, Microsoft Excel, Data cleaning, ETL pipelines, Statistical modeling, A/B testing, Google BigQuery, PostgreSQL, Git, Dashboards

Customer Churn Prediction Model

Role: Lead Analyst

Tools: Python, Scikit-Learn, SQL, Power BI

Built a logistic regression model to identify at-risk clients, reducing customer churn by 12% over a 6-month trial period.

Automated Financial Reporting Pipeline

Role: Data Developer

Tools: Python, PostgreSQL, Git, Excel

Developed ETL pipelines to aggregate regional client billing data, reducing weekly report preparation time from 10 hours to 45 minutes.

• Google Data Analytics Professional Certificate (2023)
• Microsoft Certified: Power BI Data Analyst Associate (2024)

• Languages: English (Fluent), Spanish (Conversational)
• Professional Membership: Active member of the American Statistical Association (ASA)
• Availability: 2 weeks notice for transition