Specialty Development Consultant- W2 Hybrid

Title: Specialty Development Consultant 3 openings

Location: Dearborn Mi /hybrid (requires up to 4 days in the office).

Visa: USC/GC only

Additional Information:

GCP Certification preferred Ford Experience preferred

Job Description:

Materials Management Platform (MMP) is a multiyear transformation initiative aimed at transforming Companys Materials Requirement Planning & Inventory Management capabilities. This is part of a larger Industrial Systems IT Transformation effort.

This position responsibility is to design & deploy Data Centric Architecture in GCP for Materials Management platform which would get / give data from multiple applications modern & Legacy in Product Development Manufacturing Finance Purchasing NTier Supply Chain Supplier Collaboration

Skills Required:

Design and implement datacentric solutions on Google Cloud Platform (GCP) using various GCP tools like Big Query Google Cloud Storage Cloud SQL Memory Store Dataflow Dataproc Artifact Registry Cloud Build Cloud Run Vertex AI Pub/Sub GCP APIs.

Build ETL pipelines to ingest the data from heterogeneous sources into our system

Develop data processing pipelines using programming languages like Java and Python to extract transform and load (ETL) data

Create and maintain data models ensuring efficient storage retrieval and analysis of large datasets

Deploy and manage databases both SQL and NoSQL such as Bigtable Firestore or Cloud SQL based on project requirements

Optimize data workflows for performance reliability and costeffectiveness on the GCP infrastructure.

Implement version control and CI/CD practices for data engineering workflows to ensure reliable and efficient deployments.

Utilize GCP monitoring and logging tools to proactively identify and address performance bottlenecks and system failures

Troubleshoot and resolve issues related to data processing storage and retrieval.

Promptly address code quality issues using SonarQube Checkmarx Fossa and Cycode throughout the development lifecycle

Implement security measures and data governance policies to ensure the integrity and confidentiality of data

Collaborate with stakeholders to gather and define data requirements ensuring alignment with business objectives.

Develop and maintain documentation for data engineering processes ensuring knowledge transfer and ease of system maintenance.

Participate in oncall rotations to address critical issues and ensure the reliability of data engineering systems.

Provide mentorship and guidance to junior team members fostering a collaborative and knowledgesharing environment.

Experience Required:

8 years of professional experience in:

o Data engineering data product development and software product launches

o At least three of the following languages: Java Python Spark Scala SQL and experience performance tuning.

4 years of cloud data/software engineering experience building scalable reliable and costeffective production batch and streaming data pipelines using:

o Data warehouses like Google BigQuery.

o Workflow orchestration tools like Airflow.

o Relational Database Management System like MySQL PostgreSQL and SQL Server.

o RealTime data streaming platform like Apache Kafka GCP Pub/Sub

o Microservices architecture to deliver largescale realtime data processing application.

o REST APIs for compute storage operations and security.

o DevOps tools such as Tekton GitHub Actions Git GitHub Terraform Docker.

o Project management tools like Atlassian JIRA

Automotive experience is preferred

Support in an onshore/offshore model is preferred

Excellent at problem solving and prevention.

Knowledge and practical experience of agile delivery

Experience Preferred:

Experience in IDOC processing APIs and SAP data migration projects.

Experience working in SAP S4 Hana environment

Education Required:

Requires a bachelors or foreign equivalent degree in computer science information technology or a technology related field

Education Preferred:

Masters preferred