DataJobs.io
← Back to all jobs

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

Similar Jobs