Learn Data Skills
Beta
Rachel Swalin

Rachel Swalin

Data Analyst

People Analytics Analyst | M.S. HR Analytics | Tableau Certified Data Analyst, Python, Power BI, Excel | Pittsburgh, PA

Technologies

HR/People Data Analyst. Highly-skilled analytics professional with 10 years of experience in data-driven functions. My greatest strength is translating analyses into clear insights to drive decision-making and process improvement.

My Work

Take a look at my latest work.

notebook

Using Python & Machine Learning to Address RN Burnout/Turnover

Python
article

Tableau Visualization Project: Analyzing Employee Data Collected from ADP

PythonTableauExcel
dataset

Tableau DEI Dashboards: Prototypes Built for Exera Solutions Inc.

Tableau
notebook

Using Python & Machine Learning to Address RN Burnout/Turnover

Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Tableau Certified Data Analyst

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Introduction to Power BI
Intermediate SQL
Introduction to R

My Work Experience

Where I've interned and worked during my career.

Exera Solutions Inc. | Jan 2025 - May 2025

Master's Capstone Project – Team Member

Consulted with a cloud-based HR Analytics software startup to build an MVP for the frontend data visualizations: –Developed a comprehensive project charter in collaboration with the CEO. –Designed and built four Tableau dashboards aligned to Exera’s strategic DEI goals, delivering actionable insights on recruitment, turnover, leadership diversity, and pay equity. –Designed and generated a synthetic dataset for analyzing recruitment metrics, specifying variable types, value distributions, and frequency patterns to simulate real-world workforce trends. –Authored a detailed technical documentation guide for future scaling of the platform, including variable definitions, metric calculations, and visualization specifications.
Show More

Wild Sky Media | Jul 2022 - Sep 2023

Social Media Analytics Senior Manager

–Led implementation of new tools, including AI-powered social scheduling and analytics platforms (e.g., True Anthem, Parse.ly), improving workflow efficiency and adoption of technology across teams. –Led testing and rollout of a data-informed Facebook content strategy, resulting in a 50% increase in organic monthly traffic by optimizing image post format and first-comment placement across multiple brand pages. –Gathered platform requirements from editorial teams and translated needs into technical specifications for engineering, supporting the successful development of an automated content publishing process via RSS and social tools. –Drove the creation and department-wide adoption of self-service analytics resources. Responsibilities included: –Designed and implemented self-service analytics resources. –Trained and supported four editorial teams on interpreting analytics, using reporting tools, and applying data insights to strategy, improving data literacy across the organization. –Authored internal guides on reporting best practices, content governance, and platform tools to standardize analytics processes and improve cross-team consistency.

Wild Sky Media | Jul 2018 - Jul 2022

Social Media Analytics Manager

–Built and maintained four KPI dashboards and 13 performance reports using Google Analytics, Data Studio, Sheets, and Supermetrics, tracking content and engagement trends across four brands with a combined audience of 6.5M+. –Created and delivered daily, weekly, monthly, and year-over-year reports, uncovering insights that supported content optimization and helped drive a 66% YoY increase in cross-brand traffic. –Developed automated reporting tools using advanced formulas, data validation, and conditional logic in Google Sheets, reducing manual reporting time by 40% and improving accuracy. –Coordinated global workflows by managing shared documents between U.S. and Thailand-based teams, ensuring smooth handoffs, data tracking, and process alignment.

CafeMom | Sep 2017 - Jun 2018

Social Media Director

–Analyzed cross-platform metrics and delivered performance reports, providing actionable insights that drove a 60% YoY increase in social interactions for CafeMom.com. –Trained a 10+ member team on interpreting analytics, benchmarking performance, and applying data insights to guide editorial strategy and engagement. –Utilized AWS reports to assess content performance by revenue, identifying key drivers of paid social efforts and contributing to a 66% YoY increase in Facebook-driven revenue.

Hearst Digital Media | Nov 2016 - Aug 2017

Social Media Analytics Manager

–Tracked and analyzed traffic and engagement metrics across four social platforms, supporting a 15% audience growth in six months through data- informed content strategy. –Optimized Facebook content strategy using performance data, helping ElleDecor.com achieve an average of 2MM interactions per month. –Monitored and reported on Instagram engagement trends and follower growth, contributing to a 32% increase in followers and the highest Instagram engagements across Hearst brands (2MM+). –Led audience engagement reporting by identifying high-performing content and flagging key behavioral trends for editors and the site director.

Trusted Media Brands, Inc. | Mar 2015 - Nov 2016

Social Media Analytics Manager

–Analyzed engagement metrics and traffic data across three platforms, contributing to a 45% YoY increase in site visits and a peak of 1.9M visits for ReadersDigest.com. –Developed monthly analytics reports and presented performance insights to the site director, chief content officer, and cross-functional teams, enhancing data-driven content strategy. –Collaborated with editorial and marketing teams to execute data-informed campaigns, including Trusted Brands Survey promotions that reached 5.2M users across social channels. –Led development of social traffic-sharing partnerships with brands like Huffington Post and Weather.com, driving 15% of total social traffic through cross-brand collaboration.

My Education

Take a look at my formal education

Master of Science in Human Resource AnalyticsMontclair State University | 2025
Bachelor of Science in JournalismOhio University | 2013

About Me

Rachel Swalin

Passionate about helping people thrive at work through People Analytics. With 10+ years in data roles and a foundation in communications and HR analytics, I turn insights into impact—blending rigor, empathy, and storytelling to drive change.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free