Data Engineer
About The Position
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. The ideal candidate is a problem-solver who enjoys working with large datasets, designing efficient data workflows, and continuously improving data reliability and performance.
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.
Nice To Haves
- Experience within manufacturing, ERP, or operational data environments.
- Experience with workflow orchestration platforms such as Prefect or Apache Airflow.
- Experience implementing change data capture (CDC) or incremental loading strategies.
- Experience with dbt for data modeling, testing, and documentation.
- Familiarity with MongoDB, Redis, and Microsoft SQL Server.
- Experience working with containerized development environments, including Docker.
- Knowledge of cloud-based analytics and modern data architecture concepts.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
