Hey, I'm Patrick McAlinden! šŸ‘‹

I uncover hidden patterns and opportunities within your data.

šŸ“Š Data-Driven Insights🧮 SQLšŸ Python⚔ SparkšŸ“ˆ Tableau

About Me

I’m passionate about turning raw data into something useful—whether that’s through analysis or building the pipelines behind the scenes. I like figuring out the small things others might miss, whether it’s a weird edge case in a dataset or a way to make a workflow run faster.

I work with tools like Python, Spark (PySpark and Spark SQL), Databricks, Tableau, and Power BI to help answer questions and support better decisions. I enjoy the process of making complex things simple and helping others see what’s possible with data.

Outside of work, I’m usually gaming or messing around with cars—both things I’ve always loved. I try to use data wherever I can, whether it's tracking performance in a game or figuring out what’s going on under the hood. It’s all about finding those little details that make a difference.

Experiences

Business Intelligence Analyst

@ Red Storm Entertainment May 2023 - Present

I use Spark (PySpark and Spark SQL), Databricks, Tableau, and Power BI to answer complex analytics questions about player behavior across multiple games. My work focuses on building scalable pipelines and intuitive dashboards that uncover insights for game designers, product teams, and studio leadership.

Rebate Finance Analyst

@ CVS Health Mar 2022 - Sep 2022

I verified and reported on rebate discrepancies using SQL and Excel, working to identify, validate, and resolve financial issues across large datasets. My role involved close collaboration with finance and operations teams to ensure rebate accuracy and support smoother reimbursement workflows.

Marketing Data Analyst

@ Freelance May 2021 - Dec 2021

I helped small businesses grow their ecommerce presence by analyzing campaign performance, site traffic, and conversion rates. Using Python, Tableau, Google Analytics, and Facebook Insights, I uncovered key opportunities that improved sales and marketing ROI.

Mobile Sales

@ Best Buy June 2018 - Oct 2020

This job basically forced me to talk—a lot. It taught me how to ask better questions, read the room, and communicate clearly, skills I now use to understand users and stakeholders just as much as customers.

Projects

Spotify Data Analysis preview

Spotify Data Analysis

I frequently use Spotify and, as I have experience with the Spotify API, I decided to utilize my extensive history data to interact with the API and conduct data analysis.

PythonPandasTableau
Citi Bike Dashboard preview

Citi Bike Dashboard

This project analyzes Citibike usage patterns using SQL for data preparation and Tableau for building an interactive dashboard that highlights key trends in rider behavior and station activity.

TableauMySQL
MLB Analysis preview

MLB Analysis

Analysis of historical baseball data using PySpark, focusing on player batting averages, home run leaders, and team slugging percentages. Includes SQL queries and insights into MLB player performances.

PythonSpark SQL
Spotify Stats preview

Spotify Stats

This site, built with Bootstrap and JavaScript, connects to the Spotify API to display personalized music stats. Users can view their top songs and artists across weekly, six-month, and yearly timeframes in a clean dashboard layout.

JavascriptHTMLCSS

Get In Touch

Interested in discussing data insights or potential opportunities? Feel free to reach out!