Bi Consultant

Ford Ford · Auto · Dearborn, MI +1 · Enterprise Technology

BI Consultant role focused on Master Data Management (MDM) systems, including design, development, migration from on-prem to SaaS, and integration using APIs. Requires experience with MDM tools, CI/CD, cloud environments, and database technologies.

What you'd actually do

  1. Design and develop new models on MDM SaaS, a modernized Master Data Management (MDM) platform.
  2. Develop strategy plan and execute/implement migration from MDM on-prem to MDM SaaS for the whole enterprise.
  3. Drive adoption and on-board new applications to use MDM.
  4. Consult for MDM configuration/development within Ford at the enterprise level and problem solve on MDM development/configuration at the application layer.
  5. Perform system design and code review.

Skills

Required

  • Master’s degree or foreign equivalent in Computer Engineering, Computer Science or a related field
  • 10 years of experience in the job offered or a related occupation
  • Designing, configuring, and developing Master Data Management (MDM) applications using on premise components HUB Console, Provisioning tool, Entity 360, SIF and User exists
  • Designing, configuring, and developing MDM SaaS using IDMC Services including IICS CDI and CAI, Business 360, Reference 360, Multi Domain GUI, AND Customer 360
  • Design and develop new models on the MDM SaaS platform and migrate existing MDM solutions to modernized MDM - SaaS plat form
  • Develop the solutions to integrate applications using API calls and DI
  • Utilizing Jenkins for continuous integration and multi-cloud continuous delivery to develop and maintain CI/CD pipelines and automate the testing and deployment process
  • Designing and implementing large-scale distributed system in a cloud-native environment
  • Utilizing NoSQL and SQL database technologies and databases including MongoDB, MySQL or data modeling
  • Develop the data pipelines using Cloud Services including Google Tekton, Looker and Cloud Data Fusion
  • API integration
  • BigQuery
  • GCP GCS
  • PostGreSQL
  • MangoDB
  • Developing the database scripts, functions and queries for SQL and NoSQL databases