Data Insights & Solution Design Lead (Travel Up to 50%)

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

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.