Data Engineer II: AI-Driven ERP & Real-Time Pipelines

Fisher & Company, Inc.; Saint Clair Shores, Northern (MI, KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Fisher Dynamics, a premier automotive supplier, seeks a Data Engineer - II to architect and build the data foundation powering its ERP platform and embedded AI capabilities. You will design scalable pipelines, implement ETL/ELT processes, and enable real-time data streaming for model training and inference.

Collaborating with ML/AI engineers, SW engineers, and stakeholders, you will establish governance, quality standards, and security for data integrity and compliance in a manufacturing

Qualifications

• 4-6 years of professional data engineering experience.
• Demonstrated experience designing and implementing large-scale ETL/ELT pipelines and data architectures.
• Experience with ERP system data integration or data warehousing preferred.
• Strong Python/Scala/Java and SQL skills.

Responsibilities

• Design and build scalable data pipelines for ERP data ingestion, transformation, and loading.
• Implement ETL/ELT processes with data validation and quality checks.
• Build real-time data streaming pipelines using Kafka, Spark, or similar technologies for continuous data flow.
• Develop batch processing jobs for scheduled data transformations and aggregations.
• Ensure data pipelines handle large volumes and complex transformations with resilience.
• Collaborate with ML/AI engineers and business stakeholders on data needs for AI features.

Skills

Python/Scala/Java

SQL

Data governance

Communication

Problem solving

Collaboration

Cloud platforms

Education

Bachelor’s degree in CS/DS/Engineering

Master’s degree preferred

Tools

Airflow

Prefect

Dagster

AWS Redshift/S3

Google BigQuery

Azure Data Lake

Spark

Kafka

Flink

Hadoop

Docker

Kubernetes

Git

Job description

Fisher Dynamics, a premier automotive supplier, seeks a Data Engineer - II to architect and build the data foundation powering its ERP platform and embedded AI capabilities. You will design scalable pipelines, implement ETL/ELT processes, and enable real-time data streaming for model training and inference.

Collaborating with ML/AI engineers, SW engineers, and stakeholders, you will establish governance, quality standards, and security for data integrity and compliance in a manufacturing