Data Warehouse Developer (Data Warehouse Engineer, Data Engineer) at Cleveland Steel Container in Hudson, OH

Job description

• Cleveland Steel Container, an Employee Owned and World Class Steel Pail Manufacturing company, is seeking an enthusiastic, responsible, and customer-oriented individual that has a positive attitude and shares the values of our company culture, which is built around teamwork, family, honest communication and producing desirable results for our Hudson, OH corporate office.
• INDUSTRY LEADING BENEFIT PROGRAM THAT INCLUDES LOW EMPLOYEE PREMIUMS FOR MEDICAL INSURANCE, UNMATCHED RETIREMENT PROGRAMS AS AN EMPLOYEE OWNER. DENTAL, VISION, LIFE AND DISABILITY INSURANCES. NEW EMPLOYEES ARE ELIGIBLE FOR 15 DAYS OF PAID VACATION PER CALENDAR YEAR AND 11 PAID COMPANY HOLIDAYS.
• We're looking for a Data Engineer to join our Data & Analytics team and take ownership of the data infrastructure that powers our internal analytics and reporting capabilities. You'll be the primary technical resource responsible for maintaining and evolving our ELT pipelines and Snowflake data warehouse, working closely with a team of analysts and systems administrators who depend on reliable, well-structured data to do their jobs.

Responsibilities

• Own the day-to-day operation, maintenance, and enhancement of our ELT pipelines and Snowflake data warehouse
• Diagnose and resolve pipeline failures, data quality issues, and performance bottlenecks
• Design, build, and document new data models and transformations as analytical needs evolve
• 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 projects
• Contribute to the evaluation of modern data tooling options as we assess potential improvements to our current architecture
• Document systems, processes, and decisions to build institutional knowledge over time

Requirements

• Bachelor’s Degree in Computer Science, Information Systems, Statistics or similar subjects is preferred
• 3-5 years of hands-on experience in a data engineering role
• Strong proficiency with SQL and data modelling concepts for analytical workloads
• Practical experience with Snowflake or a comparable cloud data warehouse platform
• Familiarity with ELT/ETL pipeline concepts and tools — you don't need to know our specific stack on day one, but you should be able to learn it 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 — comfortable digging into unfamiliar systems to find the root cause
• Experience with GitHub for version control
• 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
• Exposure to enterprise integration platforms (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

Skills

Required

• SQL
• Data modelling
• ELT/ETL pipeline concepts
• Python
• API integrations
• REST-based data sources
• GitHub
• Troubleshooting

Preferred

• Boomi or similar iPaaS tools
• Oracle EBS
• SalesForce
• Data pipeline orchestration
• BI or analytics teams

Benefits

• Cleveland Steel Container offers a competitive salary based on commensurate experience and a comprehensive benefits program that includes medical, dental, and vision insurance, flexible spending accounts, 401k with company contribution, profit sharing, paid holidays and vacations, life insurance and short & long-term disability coverages along with an Employee Stock Ownership Plan (ESOP).