Mark Sosa
Summary
Data Analyst II with three years of experience in business operations and a Master's Degree in Business Analytics. Proven expertise in transforming complex data into actionable insights that enhance decision-making and business performance. Skilled in developing interactive dashboards, crafting intricate SQL queries, and leveraging Python for data automation. Adept at identifying trends and optimizing processes to drive efficiency and growth.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst II
Energy Solutions
Remote
06.2024 - Current
- Led automation project for corporate reporting, facilitating organization-wide adoption of business intelligence.
- Created and sustained over 5 Tableau dashboards, enhancing team and executive insights.
- Analyzed KPIs by producing detailed reports, contributing to a 15% rise in operational efficiency.
- Coached over 10 colleagues in Tableau, elevating data literacy across the team by 25% and enhancing ad hoc reporting.
- Optimized reporting using advanced SQL queries to provide real-time insights for over 20 stakeholders.
- Automated data cleaning using Python scripts to enhance accuracy.
Data Analyst I
Energy Solutions
Remote
09.2022 - 06.2024
- Built dashboards with Tableau to monitor key performance indicators.
- Developed custom reports using SQL queries as requested by stakeholders.
- Enhanced data workflows with Python to boost efficiency and precision.
- Led data consulting projects, providing strategic insights and solutions to optimize data-driven decision-making.
- Provided technical support for existing reports, dashboards or other tools.
- Collaborated with cross-functional teams to prioritize business and information needs.
Data Analytics Intern
T-Mobile
San Jose
04.2022 - 09.2022
- Performed comprehensive analysis of T-Mobile's High-Speed Internet, pinpointing market positioning.
- Gathered competitor plan and pricing data from aggregator websites using web scraping techniques to provide localized insights.
- Engineered a comprehensive BigQuery database containing more than 3 million rows of competitor data spanning 33,000 ZIP codes.
- Created interactive Tableau dashboard enabling sales representatives to swiftly obtain competitor plan information.
Education
MS - Business Analytics
Saint Mary's College
Moraga, CA09.2022
BS - Business Management
Sonoma State University
Rohnert Park, CA05.2021
Specialized Skills
Programming Languages: Python (Pandas, NumPy), SQL
Statistical & Analysis Tools: R, SAS
Data Visualization: Tableau, Power BI
Databases: MySQL, PostgresSQL, Oracle
Data Processing: Airflow, Spark
Productivity Tools: Excel (Pivot Tables, VLOOKUP), MS Office Suite
Certification
- Tableau Data Analyst
- Data Camp SQL Associate
Timeline
Data Analyst II
Energy Solutions
06.2024 - Current
Data Analyst I
Energy Solutions
09.2022 - 06.2024
Data Analytics Intern
T-Mobile
04.2022 - 09.2022
MS - Business Analytics
Saint Mary's College
BS - Business Management
Sonoma State University
Similar Profiles
Troy GiardTroy Giard
Director of Decommissioning at Energy SolutionsDirector of Decommissioning at Energy Solutions
Skylar BreedloveSkylar Breedlove
Process Technician at Energy SolutionsProcess Technician at Energy Solutions
Amar BadyalAmar Badyal
RADIATION TECHNICIAN at ENERGY SOLUTIONSRADIATION TECHNICIAN at ENERGY SOLUTIONS
Christopher ReeseChristopher Reese
Project Control Analyst at Energy SolutionsProject Control Analyst at Energy Solutions
Joshua DanielsJoshua Daniels
Data Analyst II at DynatraceData Analyst II at Dynatrace