Business Systems Specialist

Ford Ford · Auto · Allen Park, MI +1 · PD Operations and Quality

The Business Systems Specialist will lead the data strategy for internal manufacturing operations and Quality, focusing on developing and maintaining relational databases, managing ETL processes and API integrations, supporting ERP system implementation and maintenance, and administering Atlassian tools. The role requires expertise in SQL, data warehousing, API integration, and ERP systems, with proficiency in Python/JavaScript/Groovy and Atlassian administration being a plus.

What you'd actually do

  1. Design, build, and maintain relational databases to support business applications and reporting requirements.
  2. Develop and manage ETL (Extract, Transform, Load) processes and API-led integrations to ensure seamless data flow between storage locations, the ERP system and Atlassian tools, including third-party applications.
  3. Monitor database performance, perform regular tuning, and ensure data integrity and security across all environments.
  4. Manage relationships with ERP vendors and consultants to resolve high-level technical bugs and influence product roadmaps.
  5. Act as the primary administrator for Jira (Software/Service Management) and Confluence.

Skills

Required

  • SQL (PostgreSQL, SQL Server, or MySQL)
  • Data warehousing
  • API integration (REST/SOAP)
  • ERP systems (SAP, Oracle NetSuite, Microsoft Dynamics 365, or specialized manufacturing ERPs)
  • Jira/Confluence administration
  • Systems integration
  • Business applications management
  • ETL processes
  • CI/CD Pipelines
  • Analytical Thinking
  • Communication
  • Project Management

Nice to have

  • Python
  • JavaScript
  • Groovy
  • GCP
  • JQL
  • Automation for Jira
  • Atlassian Certified Professional
  • Microsoft SQL Certification
  • ERP-specific credentials

What the JD emphasized

  • Expert-level SQL (PostgreSQL, SQL Server, or MySQL).
  • Experience with data warehousing and API integration (REST/SOAP)
  • Previous experience with major ERP platforms (e.g., SAP, Oracle NetSuite, Microsoft Dynamics 365, or specialized manufacturing ERPs).
  • Experience in Jira/Confluence administration (Cloud or Data Center).