> Markdown version of [/jobs/ext/2600314-data-engineer-ii](https://www.wearedevelopers.com/jobs/ext/2600314-data-engineer-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer II - **Company:** Fisher Dynamics - **Location:** St. Clair Shores, MI, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Artificial Intelligence, Airflow, Amazon Web Services, Amazon S3, Data Analysis, Microsoft Azure, Batch Processing, Big Data, Cloud Database, Data Architecture, Data Validation, Data Dictionary, Information Engineering, Data Governance, Data Infrastructure, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Profiling, Data Security, Data Synchronization, Data Warehousing, Software Debugging, Document-Oriented Databases, Fault Tolerance, Apache Hadoop, Python (Programming Language), Load Testing, Machine Learning, Operational Data Store, Operational Databases, Performance Tuning, Cloud Services, Azure Data Lake, Scala (Programming Language), SQL Databases, Data Streaming, Data Storage Technologies, Feature Engineering, Large Language Models, Apache Spark, Plex, Git, Build Management, Containerization, Data Lakes, Kubernetes, Information Technology, Apache Flink, Data Analytics, Google Bigquery, Apache Kafka, Data Management, Stream Processing, Software Version Control, Data Pipelines, Docker, Amazon Redshift - **Published:** August 6, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=143b10507cf85532 ## About the Role 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. Work Environment 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. Physical Demands Ability to lift 40lbs ## Description 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., * Data Pipeline Architecture & Development * 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. * Cloud Data Infrastructure * 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. * Feature Engineering & ML Support * 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. ## Related Videos - [Docker Compose: Rediscovered](https://www.wearedevelopers.com/videos/1978-docker-compose-rediscovered) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Docker build without Docker](https://www.wearedevelopers.com/videos/100114-docker-build-without-docker) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)