Paul McGee

Data Engineer

Role: Data Engineer at Nassau Candy Distributors, Inc.
Location: New York, NY, US
LinkedIn followers: 500 followers

View LinkedIn profile

About Paul McGee

MBA graduate from Binghamton University

Experience

Data Engineer
Nassau Candy Distributors, Inc.
Aug 2023 — Present
Led the development of a SQL Server database for analytics and reporting, collaborating closely with key stakeholders to understand challenges and document existing processes. Successfully integrated data from diverse sources, including a legacy COBOL ERP system and various CRM systems. This initiative significantly reduced reliance on manual data extraction, allowing for automation of reports that previously required hours of manual effort each week.• Automated ETL workflows using SQL, Python and internal APIs. Utilized SQL Server features like merge/upsert operations, stored procedures, transactions, logging, and error-handling to ensure data integrity and traceability.• Managed and optimized SQL databases, focusing on index tuning and query speed enhancement. Developed views for users of various skill, greatly reducing data retrieval effort and complexity by employing indexing, complex joins, CTEs, subqueries, window functions, and cross-apply techniques. Improved query speeds up to 90%.

Education

SUNY New Paltz
Marketing
2015 — 2019
SUNY New Paltz
Minor, Psychology
2018 — 2019
Binghamton University
Master of Business Administration - MBA, Business Analytics
2019 — 2020
Binghamton University
Master of Business Administration - MBA
2019

Contact information

Verified work emails, personal emails, and direct dials — unlocked in one click.

Work email
p••••••••@nassaucandy.com
Personal email
•••••@•••••.com
Direct dial
+•• ••• ••• ••••

Unlock verified contacts

Free to start · No credit card required

Current company

Nassau Candy Distributors, Inc.

Food and Beverage Services · 685 employees · Founded 1985 · Hicksville, New York, United States

Nassau Candy is one of North America's largest and most respected wholesale candy distributors, fine food suppliers, and private label manufacturers. With a legacy dating back to 1920, we have grown into a full-service B2B supplier offering an expansive selection of bulk candy, bulk chocolate, gourmet foods, novelties, and more to candy stores, retailers, specialty shops, concessionaires, and hospitality groups. We carry a vast catalog of top-selling national brands including Hershey’s, Jelly Belly, M&M’s, Haribo, NERDs, and Godiva, alongside exclusive in-house offerings such as Clever Candy and Nancy Adams. Our portfolio spans novelty candy, nostalgic treats, seasonal sweets such as Valentine’s Day, Halloween Candy, Christmas treats, and both bulk and packaged chocolate. We also offer healthy snack alternatives including trail mixes, nuts, gluten-free, and organic products. Beyond candy, Nassau Candy distributes a growing selection of gourmet food products, beverages, refrigerated items, personal care goods, household care products, souvenirs, and children’s and adult novelties. This makes us not only a leader in confectionery but also a versatile distributor across multiple product categories to better serve our diverse clients. As a vertically integrated company, Nassau Candy offers in-house product development, manufacturing, custom packaging, and private label programs. This allows businesses to tailor inventory and create differentiated assortments with ease, bringing their vision to reality. With strategically located distribution centers and a deep commitment to quality, Nassau Candy ensures fast and reliable delivery along with personalized service to support your business growth. From bulk bins to custom gift sets, from nostalgic favorites to trending new products, Nassau Candy is your trusted partner in sweetening retail success.

nassaucandy.com

Find verified contacts for anyone on LinkedIn

Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.

Start for free See how it works

Free plan included · No credit card required

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.