Centro, Inc is expanding its data capabilities with a dedicated Data Engineer who will design, develop, and maintain the data infrastructure that supports reporting, analytics, and strategic decision-making across the organization. This onsite role in North Liberty, IA collaborates within Centro's Harbor data platform to transform data into actionable information for business decision-making.
Position Summary
Centro is seeking a Data Engineer to design, develop, and maintain the data infrastructure that supports reporting, analytics, and business decision-making across the organization. This role will be responsible for building scalable data pipelines, improving data quality, and delivering reliable datasets that enable operational and strategic insights. Working within Centro's Harbor data platform, the Data Engineer will collaborate with technical and business teams to transform complex data into actionable information.
Responsibilities
- Design, develop, and maintain ETL pipelines supporting enterprise reporting and analytics.
- Build and manage data workflows across extraction, change data capture (CDC), transformation, and loading processes.
- Orchestrate scheduled and on-demand workflows using Prefect.
- Integrate data from ERP, manufacturing, and business systems into centralized data platforms.
- Stage and transform source data within MongoDB environments and load curated datasets into Microsoft SQL Server.
- Implement incremental processing strategies utilizing Redis-backed CDC methodologies.
- Convert complex, nested, and multi-value data structures into relational data models optimized for reporting and analytics.
- Develop and maintain dbt models, data tests, and supporting documentation.
- Monitor pipeline performance and troubleshoot data quality issues, schema changes, and workflow failures.
- Collaborate with business stakeholders to understand data requirements and develop scalable solutions.
- Create and maintain technical documentation, operational procedures, and support resources.
- Identify opportunities to automate manual processes and improve data delivery efficiency.
- Ensure data accuracy, consistency, security, and reliability across systems.
- Stay current with emerging data engineering technologies, tools, and best practices.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field; or an equivalent combination of education and experience.
- Strong experience designing, building, and supporting production data pipelines.
- Proficiency in SQL and Python for enterprise data processing and integration.
- Experience working with structured, semi-structured, and unstructured data.
- Demonstrated ability to troubleshoot and optimize data workflows and performance.
- Strong analytical, organizational, and problem-solving skills.
- Effective written and verbal communication skills.
- Ability to manage multiple priorities and adapt to changing business needs.
Technologies
- SQL
- Python
- Prefect
- MongoDB
- Microsoft SQL Server
- Redis
- dbt
- Docker
- Apache Airflow
Physical Requirements & Work Environment
- Primarily office-based work performed in a professional business environment.
- Occasional exposure to manufacturing environments, including production floor areas.
- Ability to sit, stand, walk, and use computer equipment for extended periods of time.
- Occasional travel may be required.
- Typical schedule is Monday through Friday, 8:00 a.m. to 5:00 p.m., with flexibility as business needs require.
Why Join Centro?
Centro is a leader in rotational molding with a longstanding commitment to innovation, quality, and employee development. The company fosters a collaborative environment where team members actively contribute to improving business processes and supporting strategic growth through technology and data-driven decision making.
Equal Opportunity Employer
Centro is an Equal Opportunity Employer.
