Data Engineer II - Information Technology

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…