Solution Design & Data Insights Associate

NewCold • Chicago, IL

4d

About The Position

At NewCold, the Solution Design & Data Insights Associate leads the end-to-end solution design lifecycle for new automated cold storage warehouses, translating complex customer data into optimized warehouse designs. The role supports data-driven decisions for scalable, efficient, and innovative cold chain logistics solutions aligned with NewCold’s operational and business objectives. It owns capacity modeling, data pipelines, and solution documentation throughout warehouse development, working across Business Development, Engineering, Warehouse Management Systems, Implementation, and Operations to turn data insights into actionable recommendations and support commercial success.

The position also contributes to budgeting tools and transport analysis models, improves data models and operational insights, and supports customer and internal workshops. Travel of up to 50% is required for customer workshops and site collaboration. The typical base pay range is $105,000–$115,000, with eligibility for a bonus in addition to base pay.

Requirements

• At least 5 years of hands-on analysis work owning outcomes, not only data preparation.
• Ability to independently write production-quality SQL, including CTEs, joins, aggregations, and data-type conversion, and explain a fact and dimension model.
• Advanced proficiency in Excel and strong hands-on experience with SQL and Power BI, including data modeling and DAX for decision-ready dashboards.
• Experience building and maintaining ETL pipelines that move data from source systems into a data model; able to handle mappings, load order, data quality checks, and failures.
• Experience building Power BI models and reports, including DAX measures, and reconciling results against the source.
• Experience presenting analysis results to non-technical stakeholders such as operations managers, sales teams, or customers, with an example to demonstrate.
• Ability to turn unclear questions and messy data into a structured approach, ask the right questions, and state assumptions.
• Willingness and ability to travel up to 50% to support customer engagements and site collaboration.
• Bachelor’s degree in Industrial Engineering, Mathematics, or a related technical discipline.
• Master’s degree in Industrial Engineering, Supply Chain Management, Operations Research, Data Science, Business Analytics, Information Systems, or a comparable quantitative field.

Nice To Haves

• Experience in supply chain, logistics, warehousing, distribution, or 3PL, with understanding of orders, order lines, SKUs, pallets, cases, inbound and outbound flows, throughput, and capacity.
• Experience with Azure Data Factory.
• Experience in warehouse design, slotting, automation, or cold chain.
• Experience with customer-facing analysis, such as in consulting, a 3PL, or a solutions or engineering team.
• Experience using Python for data work.

Responsibilities

• Lead capacity modeling and conceptual warehouse layouts using customer and market data to define warehouse size, dock numbers, storage locations, and operational parameters.
• Manage assumptions, constraints, and risk factors throughout solution design to ensure robust and scalable warehouse designs.
• Develop and maintain repeatable data ingestion, cleaning, and modeling pipelines using Power BI, Excel, and SQL.
• Build, run, and troubleshoot ETL pipelines, mappings, and load order, and fix failures without escalation.
• Keep scripts, mappings, and files structured and versioned so partnering team members can reproduce the work.
• Create executive-ready solution narratives, presentations, and dashboards communicating design rationale and data-driven recommendations to internal and external stakeholders.
• Collaborate with Business Development, Engineering, Warehouse Management Systems, Implementation, and Operations to validate assumptions and support handoffs during warehouse design and development.
• Facilitate and present customer and internal workshops, capturing decisions and driving follow-up actions to closure.
• Maintain a structured repository of datasets, queries, and version-controlled models to ensure data auditability and transparency.
• Continuously improve data models and insights to enhance warehouse operational performance and support budgeting and commercial proposal processes.
• Travel up to 50% for customer workshops and site collaboration to align design solutions with operational realities.
• Contribute to strategic projects, including budgeting tools and transport analysis models.

Benefits

• Opportunity to enroll in competitive benefit programs, generally including health insurance, retirement savings plans, life and disability insurance, and programs providing paid and unpaid time away from work; availability may vary by eligibility factors.
• Four weeks of accrued paid time off.
• Paid holidays throughout the calendar year.
• Eligibility for a bonus in addition to base pay.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level