Portrait of Patrick McAlinden

Patrick McAlinden

Product Analyst at Dick's Sporting Goods · New Jersey, USA

I turn terabytes of messy data into pipelines, dashboards, and decisions.

About

I'm a data professional with 4+ years of experience building and deploying ETL pipelines, designing data models, and delivering self-service reporting solutions that process terabytes of data at scale.

Day to day I work in SQL, PySpark, and Python, with hands-on experience in Azure Databricks, Git-based deployment workflows, and Airflow-based orchestration.

B.S. Finance, Kean University · GPA: 4.0 / 4.0 · Class of 2021

Experience

  1. Jan 2026 — Present

    Product Analyst II

    Dick's Sporting Goods · Remote, USA

    • Ingest streaming data from Kafka topics into Databricks, enabling near real-time data availability for downstream reporting and analytics.
    • Developed a PySpark pipeline to identify duplicate inventory entries, helping engineers fix the root cause and ensuring accurate stock levels across all stores.
  2. May 2023 — Jan 2026

    Business Intelligence Analyst

    Red Storm Entertainment · Remote, USA

    • Led ETL validation and modification for a data migration impacting 4M+ customer profiles, delivering 100% accurate reporting on day one of launch.
    • Analyzed customer behavior trends, delivering insights that boosted D7 retention by 5% and D21 by 3%.
    • Built self-service datasets and Tableau dashboards for 4 product lines, enabling near real-time KPI tracking for stakeholders.
    • Optimized ETL pipelines with PySpark on Azure Databricks, cutting average runtime by 7% while processing terabytes of data daily.
  3. Mar 2022 — Aug 2022

    Rebate Finance Analyst

    CVS Health · Remote, USA

    • Developed SQL procedures to automate verification and standardize reporting, ensuring 97% data accuracy and a 20% efficiency improvement.
    • Analyzed rebate reports to detect over- and under-payments, correcting discrepancies across multi-million dollar contracts.
  4. Mar 2021 — Dec 2021

    Marketing Data Analyst

    Freelance · Remote, USA

    • Automated reporting for marketing and email campaigns, generating acquisition insights that reduced Google Ads spend by 12%.
    • Built browser automation scripts with JavaScript and Puppeteer to streamline e-commerce workflows, improving productivity by 13%.

Skills

Programming

  • Python
  • Pandas
  • PySpark
  • SQL
  • JavaScript

Visualization & Reporting

  • Tableau
  • Power BI
  • Plotly

Data Platforms & Tools

  • Azure Databricks
  • Kafka
  • Airflow
  • Apache Hadoop
  • GCP
  • Elastic
  • Git
  • Jira

Projects

Contact

I'm always happy to talk data, dashboards, or new opportunities. The fastest way to reach me is email.