Solution Design & Data Insights Associate

NewCold Melbourne; Chicago (IL); On-site; USD 105,000 - 115,000; Full time

Job summary

NewCold is hiring a Solution Design & Data Insights Associate to translate customer data into optimized automated cold storage designs. You will own capacity modeling, data pipelines, and solution documentation throughout the warehouse development lifecycle, collaborating with Business Development, Engineering, and Operations.

You will create executive-ready narratives, dashboards, and models that translate insights into actionable design decisions, supporting budgeting and commercial proposals.

Qualifications

• 5+ years hands-on analytics ownership and delivery.
• Production-quality SQL and data modeling expertise.
• Power BI dashboards with DAX and data visualization.

Responsibilities

• Lead capacity modeling and warehouse layout concepts from data.
• Manage assumptions, constraints, and risk factors in design processes.
• Build and maintain ETL pipelines and data mappings with quality checks.
• Create executive-ready narratives, presentations, and dashboards for stakeholders.
• Collaborate with Business Development, Engineering, and Operations teams for smooth handoffs.

Skills

SQL

Power BI

Excel

Python

Data modeling

DAX

ETL pipelines

Azure Data Factory

SSIS

Education

Bachelor’s degree in Industrial Engineering

Master's degree in a quantitative field

Tools

Azure Data Factory

SSIS

Informatica

Talend

dbt

Job description

Solution Design & Data Insights Associate

Solution Design & Data Insights Associate

Build thefuture of food
At NewCold, we’re shaping the futureof the food supply chain. Our warehouses and transportnetwork connect the world’s major food manufacturers with retailers and food service providers.

Join a collaborative team of doers,innovators, and engineers who are dedicated to making a real impact. Togetherwith advanced robotics and cutting-edge technology, we’re not just keeping upwith the times —we’re pioneering smarter, more sustainable operations to keep theworld’s food fresh and safe.

To support our rapid growth, we’re constantly looking for talented people to join our team. Want to be a part of a dynamic, forward-thinking environment? Join us!

Your role as a Solution Design & Data Insights Associate

Key responsibilities:

Position Overview

As a Solution Design & Data Insights Associate at NewCold, you will lead the end-to-end solution design lifecycle
for new automated cold storage warehouses by translating complex customer data into optimized warehouse
designs. Your role is pivotal in enabling data-driven decisions that support scalable, efficient, and innovative cold
chain logistics solutions, ensuring alignment with NewCold’s operational and business objectives.
You will directly impact NewCold’s automated warehouse operations by owning capacity modeling, data pipelines,
and solution documentation throughout the warehouse development lifecycle. Collaborating closely with Business
Development, Engineering, and Operations teams, you will ensure that data insights translate into actionable
design recommendations, supporting the delivery of cutting-edge, automated cold storage facilities that meet
customer needs and drive commercial success.

Roles and 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 the solution design process to ensure
  robust and scalable warehouse designs.
• Develop and maintain repeatable data ingestion, cleaning, and modeling pipelines using Power BI, Excel,
  and SQL to support decision-making and reporting.
• Build, run and troubleshoot ETL pipelines, mappings and load order, and fixes failures without escalation.
• Keep scripts, mappings and files structured and versioned so partnering team members can reproduce the
  work.
• Create clear, executive-ready solution narratives, presentations, and dashboards that communicate
  design rationale and data-driven recommendations to internal and external stakeholders.
• Collaborate cross-functionally with Business Development, Engineering, Warehouse Management Systems, Implementation, and Operations teams to validate assumptions and ensure smooth handoffs during warehouse design and development.
• Facilitate and present in 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.
• Support travel up to 50% for customer workshops and site collaboration to align design solutions with operational realities.
• Contribute to strategic projects such as developing budgeting tools and transport analysis models that enhance NewCold’s competitive positioning.

Requirements

• 5+ years of hands-on analysis work where the candidate owned the outcome, not only the data preparation.
• Ability to write production-quality SQL independently (CTEs, joins, aggregations, data-type conversion) and can explain a fact and dimension model.
• Advanced proficiency in Excel, strong hands-on experience with SQL and Power BI including data modeling and DAX for building decision-ready dashboards.
• Has built and maintained ETL pipelines that move data from source systems into a data model, for example with Azure Data Factory, SSIS, Informatica, Talend, dbt or Python. Can handle mappings, load order, data quality checks and failures.
• Experience building Power BI models and reports, including DAX measures, and reconciles results against the source.
• Has presented analysis results to non-technical stakeholders such as operations managers, sales or customers, and can show an example.
• Experience turning an unclear question and messy data into a structured approach, asks the right questions and states assumptions.
• Preferred experience in supply chain, logistics, warehousing, distribution or 3PL. Understands orders, order lines, SKUs, pallets, cases, inbound and outbound flows, throughput and capacity.
• Preferred experience with Azure Data Factory.
• Preferred experience in warehouse design, slotting, automation or cold chain experience.
• Preferred experience with customer-facing analysis, for example in consulting, a 3PL or a solutions or engineering team.
• Preferred experience using Python for data work.
• Willingness and ability to travel up to 50% to support customer engagements and site collaboration.

Education/Certification

• 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 required.

Who we are looking for:

We are seeking motivated and forward-thinking individuals who thrive incollaborative and fast-moving environments. Our ideal candidate has:

Ready to make an impact?

Ourgoal is to keep the world’s food fresh and safe with our proprietarytechnologies and innovative solutions. Join our team andhelp build a more efficient, innovative, and sustainable food supply chain.Your next career chapter starts at NewCold.

Whether you’re a seasoned expert or just starting your career, NewColdprovides the opportunities and challenges that allow you to grow and excel.Ready to turn your curiosity into impact?

Explore careers at NewCold

Can we welcome you on board as our new Solution Design & Data Insights Associate and help continueour successful growth?

NewCold provides equal employment opportunities to all employees and applicants for employment without regard to race, color, ancestry, national origin, gender, sexual orientation, marital status, religion, age, disability, gender identity, results of genetic testing, medical condition (including cancer and genetic characteristics), or service in the military. Equal employment opportunity applies to all terms and conditions of employment, including hiring, placement, promotion, termination, layoff, recall, transfer, leave of absence, compensation, and training.

NewCold expressly prohibits any form of unlawful employee harassment or discrimination based on any of the characteristics mentioned above. Improper interference with the ability of other employees to perform their expected job duties is absolutely not tolerated.

Pay Range

The typical pay range for this role is:

$105,000 - $115,000

This position is eligible for a bonus in addition to the base pay range listed above.
This pay range represents the base hourly rate or base annual full-time salary for all positions in the salary band within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors.

Benefits

NewCold also provides eligible employees with an opportunity to enroll in a full range of competitive benefit programs, generally including health insurance, retirement savings plans, life and disability insurance programs, and programs that provide for both paid and unpaid time away from work. In addition, we offer employees 4 weeks of accrued Paid Time Off as well as paid holidays throughout the calendar year.
The specific programs and options available to any given employee may vary depending on eligibility factors such as geographic location, and date of hire.