Pamela Austin
I'm a Data Analyst with deep experience delivering high-impact analytical solutions across marketing, telecom, retail, and finance, specializing in turning complex datasets into actionable insights that drive measurable business outcomes.
Expert in advanced analytics, AI, and ML applications, including predictive modelling, forecasting, anomaly detection, automated financial workflows, and end-to-end ETL pipeline design using Python, PySpark, SQL, Snowflake, AWS, and Databricks. Proven success leading large-scale data quality and optimization initiatives — deduplicated 150M+ records with zero data loss, engineered cloud pipelines delivering 87.5% faster processing and $250K annual savings, and built ML forecasting models achieving 94%+ accuracy with multimillion-dollar impact.
Skilled in developing interactive BI dashboards and data products using Power BI (DAX), Tableau, and Snowflake; improved dashboard performance by 25% through optimized data governance, modelling, and validation frameworks. Developed advanced Excel models and high-impact PowerPoint presentations translating complex analytical and financial insights into clear, actionable narratives for C-suite and non-technical stakeholders.
📊 Featured Projects:
My work portfolio showcases data solutions that have driven real business value:
- 📊 Syilum LLC – Product BI & Self-Service Analytics – Power BI dashboards tracking product KPIs; SQL-driven user behaviour analysis; 99%+ data accuracy; 60% ad-hoc report reduction
- 💎 Signet Jewelers – M&A Financial Business Intelligence – Power BI dashboards + SQL analytics for $450M+ acquisition pipeline; $12.6M errors detected; 92% faster consolidation (6 weeks → 5 days)
- ⚙️ AT&T – Business Intelligence & Self-Service Analytics Platform – 25+ Power BI dashboards; 45s → 3s query optimization (93%); 150+ self-service users; 60% IT request reduction
- 📊 AT&T – Marketing Campaign Analytics & Reporting – Unified Workfront/Salesforce/ZoomInfo data; 200+ campaigns tracked; 40% manual reduction; 60% IT reduction
- 📈 AT&T – Predictive Analytics & Operational Dashboards – Forecasting models reducing project overruns 28%; 30% fewer escalations; integrated Power BI operational dashboards
- 📱 Syilum LLC – Product & Marketing Business Intelligence – 100+ dashboards; 10M+ daily events; A/B testing driving 23% feature adoption; 60% IT reduction
- 📣 AT&T/YP Advertising – Marketing Analytics & Data Governance – Multi-channel attribution model; data governance framework across 6 systems; 34% data quality improvement; advertiser churn prediction; 8,200+ accounts
- 🌌 Exoplanet Habitability Analysis – Personal ML project: 5,000+ exoplanets, 96.5% accuracy predicting habitable world candidates
💼 Professional Experience:
- Syilum LLC – Freelance Business Intelligence Analyst (Oct 2025 – Present)
- Signet Jewelers – Data Analyst (Jun 2025 – Sep 2025)
- AT&T – Data Analyst – Senior (Mar 2024 – Mar 2025)
- Syilum LLC – Product Data Analyst (Jan 2016 – Mar 2024)
- AT&T/YP Advertising – Data Analyst (Jan 2013 – Jan 2016)
🎓 Education & Certifications:
- B.S. Computer Science – National American University (2016)
- A.S. Finance & Accounting – University of Phoenix (2011)
- IBM – Database and SQL for Data Science with Python