Data Insights & Solution Designer (Cold Storage)

NewCold; Chicago (IL); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Bonus eligible

Health insurance

4 weeks PTO

Job summary

NewCold seeks a Solution Design & Data Insights Associate to lead end-to-end design for automated cold storage warehouses, translating complex customer data into optimized layouts. You will own capacity modeling, data pipelines, and documentation to support scalable operations.

You will work with Business Development, Engineering, and Operations to turn insights into actionable design decisions, supporting budgeting and commercial proposals while traveling up to 50% for site engagements.

Qualifications

• 5+ years of hands-on analysis ownership.
• Production-quality SQL skills and data modeling knowledge.
• Advanced Excel and Power BI with DAX for dashboards.
• Experience building ETL pipelines (Azure Data Factory, SSIS, Informatica, Talend, dbt, Python).
• Experience building Power BI models and reports; ability to reconcile with source data.

Responsibilities

• Lead capacity modeling and conceptual warehouse layouts using data.
• Manage assumptions, constraints, and risks in the design process.
• Develop/maintain data pipelines using Power BI, Excel, and SQL.
• Build/run ETL pipelines and handle mappings, load order, and data quality checks.
• Version control scripts and files for reproducibility across teams.
• Create executive narratives, presentations, and dashboards for stakeholders.
• Collaborate across Business Development, Engineering, Operations for smooth handoffs.
• Present at workshops; capture decisions and follow-up actions.
• Maintain a structured repository of datasets and models for auditability.
• Improve data models and insights to support budgeting and proposals.
• Travel up to 50% for customer engagements and site collaboration.
• Contribute to budgeting tools and transport analysis models.

Skills

Analytical thinking

Data storytelling

Stakeholder communication

Problem solving

Education

Bachelor's degree in Industrial Engineering or Mathematics

Master's degree in Industrial Engineering / Data Science / Analytics

Tools

SQL

Power BI

Excel

Azure Data Factory

SSIS

Informatica

Talend

dbt

Python

Job description

NewCold seeks a Solution Design & Data Insights Associate to lead end-to-end design for automated cold storage warehouses, translating complex customer data into optimized layouts. You will own capacity modeling, data pipelines, and documentation to support scalable operations.

You will work with Business Development, Engineering, and Operations to turn insights into actionable design decisions, supporting budgeting and commercial proposals while traveling up to 50% for site engagements.