Pamela Austin

I'm an experienced Data Analyst with 10+ years specializing in data engineering, business intelligence, and analytics. You can check out my resume .

For over a decade, I've helped companies solve business problems with data across telecommunications, healthcare, retail, and finance. I see my role as building scalable data pipelines and creating actionable insights that drive measurable business impact (instead of letting valuable data sit unused).

I'm passionate about data engineering, especially with modern cloud platforms. I have expertise in AWS (Redshift, Glue, AppFlow), Snowflake, Python/PySpark, SQL, and visualization tools like Power BI and Tableau.

πŸ“Š Featured Projects:

My work portfolio showcases data solutions that have driven real business value:

πŸ’Ό Professional Experience:

  • Signet Jewelers – Senior Data Analyst (2025)
  • AT&T – Senior Data Analyst (2024-2025)
  • Syilum LLC – Business Intelligence Analyst (2016-2024)
  • Support Optics – Data Analyst (2013-2016)
  • AT&T \ YP Advertising – Marketing Analyst (2010-2013)

πŸŽ“ Education & Certifications:

  • B.S. Computer Science – Georgia State University (2016)
  • A.S. Finance & Accounting – Georgia State University (2011)
  • IBM Data Science Professional Certificate – SQL for Data Science

Recent Work

Nov 2025 Data Science

🌌 Exoplanet Habitability Analysis

Comprehensive machine learning analysis of 5,000+ exoplanets to predict habitability and estimate life-supporting worlds in our galaxy. Built predictive models using Python scikit-learn and TensorFlow achieving 96.5% accuracy, with interactive visualizations and statistical extrapolation estimating ~300M potentially habitable planets in the Milky Way.

Python Machine Learning scikit-learn TensorFlow Pandas Seaborn
View Project β†’
Sep 2025 Data Engineering

Enterprise Data Deduplication Pipeline

Led end-to-end deduplication of 150+ million customer and transaction records for Signet Jewelers. Designed and implemented scalable AWS/Redshift architecture with automated Salesforce integration, achieving zero data loss and 35% cost reduction.

AWS Redshift PySpark Salesforce ETL Pipeline
View Project β†’
May 2024 - Nov 2024 Machine Learning

Predictive ML Forecasting Model

Built predictive analytics system for AT&T revenue forecasting, processing 512M records with 94.2% accuracy. Developed forecasting models using Python, scikit-learn, and Azure ML Studio integrated with Snowflake, reducing forecast cycle time by 40% and enabling $12M annual cost savings.

Python Azure ML Studio Databricks Snowflake scikit-learn
View Project β†’
Mar 2024 Cloud Migration

☁️ AT&T Multi-System Cloud Migration to Snowflake

Led 8-person cross-functional team migrating WebPhone, Bynder, and Workfront systems into unified Snowflake data warehouse. Comprehensive data mapping of 500+ fields across disparate schemas, processed 2.4M daily records, achieved 87.5% faster processing (6 hrs β†’ 45 min), 99.9% data accuracy, and $250K annual savings. Enabled real-time analytics for 5,000+ users.

Snowflake Apache Airflow DBT Python Data Mapping ETL Pipeline Team Leadership
View Project β†’
Jan 2024 - Nov 2024 Business Intelligence

Marketing Analytics Platform

Architected unified marketing data platform at AT&T integrating Workfront, Bynder, and Webphone using Snowflake, Fivetran, and dbt. Eliminated 15+ hours weekly manual reporting, improved data accuracy to 98.2%, and enabled real-time campaign optimization with $2.3M cost savings identified.

Snowflake Fivetran dbt A/B Testing
View Project β†’
2017-2019 Financial Analytics

🏦 Enterprise Banking Financial Analytics Platform

Built comprehensive financial analytics platform for $2.8B regional bank analyzing 125K+ customers and 850K+ monthly transactions. Implemented SQL Server data warehouse, Python predictive models (91.5% credit risk accuracy), and Power BI executive dashboards. Reduced credit risk by 28%, increased operational efficiency by 42%, and identified $3.2M in revenue opportunities through customer segmentation and churn prediction.

SQL Server Python Power BI Machine Learning Financial Analysis Risk Management
View Project β†’
2016-2024 Product Analytics

Product Analytics & A/B Testing Framework

Led product analytics initiatives at Syilum LLC for 8+ years using IBM Cloud Pak for Data. Designed A/B testing frameworks, tracked KPIs across multiple products, and created executive dashboards that informed strategic product decisions.

IBM CP4D Watson Query A/B Testing DAX
View Project β†’
2016 Data Engineering

πŸ₯ Healthcare Data Integration & ETL Pipeline

Enterprise-grade HIPAA-compliant ETL pipeline integrating 50,000+ patient records from EHR, billing, and pharmacy systems into unified Snowflake data warehouse. Detailed data mapping with PHI de-identification, cross-system patient matching via Master Patient Index, and automated data quality validation (98.7% score). Built AWS Glue/PySpark pipeline with encryption, deduplication, and 99.8% uptime.

AWS Glue PySpark Snowflake Data Mapping HIPAA Compliance ETL Pipeline
View Project β†’
2013-2016 Healthcare Analytics

Healthcare Quality Analytics Dashboard

Built HEDIS measure tracking, CMS star ratings, and care gap analysis platform for 125,000+ members across 7 facilities at Support Optics Healthcare. Improved from 3 to 4.5 CMS stars, achieved 18% HEDIS score improvement and 33% readmission reduction, unlocking $4.2M in quality bonuses.

SQL Server SSIS Tableau HEDIS Tableau
View Project β†’
2010-2013 Marketing Analytics

Campaign Performance & ROI Optimization

Analyzed 100+ digital marketing campaigns at YP Advertising, delivering insights that improved ROAS by 20%. Created automated Tableau dashboards for real-time campaign monitoring and audience segmentation analysis.

Marketing Analytics SQL Tableau Python
View Project β†’