Data Engineer II - Information Technology

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

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Regular St. Clair Shores, MI, US

Fisher Dynamics is the automotive industry’s premier supplier of safety – critical seat structures and mechanisms. Steeped in a tradition of excellence, and rooted in automotive innovation, the Fisher story is filled with automotive manufacturing milestones. We bring design, engineering, and manufacturing vehicle seating systems to a new level with innovative thinking. We’re about cutting edge ideas. We have created an environment that encourages an uninterrupted flow of revolutionary concepts and unique ideas.

The Data Engineer - II, will architect and build the data foundation that powers Fisher Dynamics' custom ERP platform and its embedded AI/LLM capabilities. They will design robust, scalable data pipelines that extract, transform, and load data from Plex and operational sources into the new ERP system. Along with building real-time data streaming systems that feed machine learning models with clean, accurate, and timely data for intelligent ERP features; this position will establish data governance, quality standards, and compliance frameworks that ensure data integrity, security, and regulatory adherence. Along with collaborating with ML/AI engineers, SW engineers, and business stakeholders to deliver a data-driven, AI-native ERP platform.

Candidates MUST be local to the Metro Detroit Area. Relocation is not available.

This role does not provide immigration sponsorship. Candidates must be legally authorized to work in the US without requiring sponsorship now or in the future.

• Design and build scalable, fault-tolerant data pipelines for ERP data ingestion, transformation, and loading.
• Implement ETL/ELT processes that migrate legacy ERP data into the new ERP system 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, complex transformations, and operational resilience.
• Data Governance & Quality Management
  • Establish data governance policies, standards, and procedures for ERP data.
  • Implement data quality monitoring and validation frameworks to ensure data accuracy and consistency.
  • Build data profiling, cleansing, and validation tools to maintain high-quality data.
  • Document data lineage, metadata, and data dictionaries for transparency and compliance.
  • Monitor data quality metrics and SLAs; alert on data issues and drive resolution.
• Design and implement cloud-based data architecture on AWS, GCP, or Azure (data warehouses, data lakes, etc.).
• Build and optimize data storage solutions for ERP transactional and analytical data.
• Implement data security, encryption, and access controls for sensitive financial and operational data.
• Optimize data infrastructure for performance, cost, and scalability.
• Monitor and troubleshoot data infrastructure issues.
• Collaborate with ML/AI engineers to understand feature requirements and data needs for AI models.
• Design and build feature stores and feature pipelines that deliver data for model training and inference.
• Engineer features from raw ERP data (transactions, master data, time-series) optimized for ML models.
• Build real-time feature serving infrastructure for low-latency model inference.
• Support ML/AI engineers with exploratory data analysis and data debugging.
• Data Migration & Integration
  • Lead data migration from Plex to new ERP system with data validation and reconciliation.
  • Build integrations with external data sources (suppliers, customers, market data) into ERP.
  • Implement data synchronization and consistency checks between source and target systems.
  • Manage historical data and archive strategies.
  • Support data cutover activities and validation.
• Performance Optimization & Troubleshooting
  • Monitor and optimize data pipeline performance, query efficiency, and data infrastructure.
  • Identify and resolve data bottlenecks and performance issues.
  • Build monitoring and alerting systems for data pipeline health.
  • Conduct load testing and capacity planning for data infrastructure.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education

Bachelor's degree in Computer Science, Data Science, Engineering, or related field.

Master's degree preferred.

Experience

4-6 years of professional data engineering experience building production data systems.

Demonstrated experience designing and implementing large-scale ETL/ELT pipelines and data architectures required.

Experience with ERP system data integration or data warehousing strongly preferred.

Skills

Advanced proficiency in Python, Scala, Java, or similar data engineering languages.

Expert-level SQL and relational/dimensional database design.

Strong experience with data pipeline orchestration tools (Airflow, Prefect, Dagster).

Expertise in cloud data platforms (AWS Redshift/S3, Google BigQuery, Azure Data Lake).

Experience with big data technologies (Spark, Hadoop, Kafka, Flink).

Knowledge of data warehousing, data lakes, and data architecture patterns.

Strong understanding of ETL/ELT patterns, data transformation, and data quality.

Experience with version control (Git) and data pipeline version management.

Proficiency with containerization (Docker) and orchestration platforms.

Understanding of data governance, security, and compliance requirements.

Experience with feature stores and ML data pipelines is preferred.

Familiarity with ERP systems and business data models is preferred.

Strong problem-solving and debugging skills.

Excellent communication and ability to collaborate with data scientists and engineers.

Working environment and physical requirements of this position are those typical of an office setting and manufacturing environment. Position requires collaboration with technical teams and business stakeholders.