Data Warehouse Developer

Cleveland Steel Container Corporation; Hudson (OH); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Flexible spending accounts

401k with company contribution

Profit sharing

Employee Stock Ownership Plan ESOP

Paid holidays

Paid vacation

Life insurance

Short-term and long-term disability

Job summary

Cleveland Steel Container Corporation in Hudson, Ohio is seeking a Data Warehouse Developer to own ELT pipelines and the Snowflake data warehouse for internal analytics. The role sits on the Data & Analytics team in the Hudson corporate office, onsite.

You will design and optimize data models, ensure data reliability and integrate APIs, Python applications, and modern ELT tooling to support business decisions.

Qualifications

• Bachelor’s Degree in Computer Science, Information Systems, Statistics or a related field is preferred
• 3 to 5 years of hands-on experience in a data engineering role
• Strong SQL proficiency and data modeling concepts for analytical workloads
• Practical experience with Snowflake or a comparable cloud data warehouse platform
• Familiarity with ELT/ETL pipeline concepts and tools; ability to learn our stack quickly
• Experience with WhereScape RED, Matillion, Airbyte, dbt, or comparable ELT automation tools
• Working knowledge of Python for data processing and scripting
• Experience with API integrations and working with REST-based data sources
• A methodical approach to troubleshooting and comfort digging into unfamiliar systems to identify root causes
• Experience using GitHub for version control

Responsibilities

• Oversee daily operation, maintenance, and enhancement of ELT pipelines and the Snowflake data warehouse
• Identify and remediate pipeline failures, data quality issues, and performance bottlenecks
• Design, develop, and document new data models and transformations to meet evolving analytical needs
• Ensure data reliability, consistency, and availability for downstream consumers
• Support and extend API integration workflows built on Boomi and Python
• Maintain and contribute to custom Python applications developed by the team
• Collaborate with internal stakeholders to scope and deliver new data integration initiatives
• Contribute to evaluating modern data tooling options to identify potential improvements to the current architecture
• Document systems, processes, and decisions to build institutional knowledge over time

Skills

SQL proficiency

Data modeling

ELT/ETL concepts

Python data processing

REST API integrations

Troubleshooting

Version control

Education

Bachelor’s Degree in Computer Science or related field

Tools

Snowflake

WhereScape RED

Matillion

Airbyte

dbt

GitHub

Oracle EBS

SalesForce

Boomi

Python

Job description

The Data Warehouse Developer role at Cleveland Steel Container Corporation, located onsite in Hudson, Ohio, focuses on owning and evolving ELT pipelines and the Snowflake data warehouse to power internal analytics. This position joins the Data & Analytics team in the Hudson corporate office.

Responsibilities

• Oversee daily operation, maintenance, and enhancement of ELT pipelines and the Snowflake data warehouse
• Identify and remediate pipeline failures, data quality issues, and performance bottlenecks
• Design, develop, and document new data models and transformations to meet evolving analytical needs
• Ensure data reliability, consistency, and availability for downstream consumers
• Support and extend API integration workflows built on Boomi and Python
• Maintain and contribute to custom Python applications developed by the team
• Collaborate with internal stakeholders to scope and deliver new data integration initiatives
• Contribute to evaluating modern data tooling options to identify potential improvements to the current architecture
• Document systems, processes, and decisions to build institutional knowledge over time

Requirements

• Bachelor’s Degree in Computer Science, Information Systems, Statistics or a related field is preferred
• 3 to 5 years of hands-on experience in a data engineering role
• Strong SQL proficiency and data modeling concepts for analytical workloads
• Practical experience with Snowflake or a comparable cloud data warehouse platform
• Familiarity with ELT/ETL pipeline concepts and tools; ability to learn our stack quickly
• Experience with WhereScape RED, Matillion, Airbyte, dbt, or comparable ELT automation tools
• Working knowledge of Python for data processing and scripting
• Experience with API integrations and working with REST-based data sources
• A methodical approach to troubleshooting and comfort digging into unfamiliar systems to identify root causes
• Experience using GitHub for version control

Technologies

• Snowflake
• Boomi
• Python
• WhereScape RED
• Matillion
• Airbyte
• dbt
• GitHub
• Oracle EBS
• SalesForce

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Flexible spending accounts
• 401k with company contribution
• Profit sharing
• Employee Stock Ownership Plan ESOP
• Paid holidays
• Paid vacation
• Life insurance
• Short-term and long-term disability insurance

Ability To

• Support and extend API integration workflows built on Boomi and Python
• Maintain and contribute to custom Python applications developed by the team
• Collaborate with internal stakeholders to scope and deliver new data integration projects

Additional Skills

• Exposure to enterprise integration platforms such as Boomi or similar iPaaS tools
• Experience with Oracle EBS and SalesForce
• Familiarity with data pipeline orchestration concepts
• Experience working closely with BI or analytics teams as a technical partner