Business Systems Specialist

Ford Motor • Allen Park, MI

3d • Hybrid

About The Position

The Business Systems Specialist is primarily responsible for leading the data strategy to include the development of a relational, automated database in support of internal manufacturing operations and Quality. Additionally, this role bridges the gap between technical infrastructure and business efficiency by architecting robust database integrations, helping support the integration of our Enterprise Resource Planning (ERP) system and managing legacy and new developments in our Atlassian environment. The ideal candidate is a "technical polymath" who can move seamlessly from SQL query optimization to ERP process mapping and Jira workflow configuration.

Requirements

• Bachelors Degree or equivalent combination of relevant education and experience.
• 5-10 years of experience in systems integration or business applications management, preferably in a manufacturing or process related environment
• Expert-level SQL (PostgreSQL, SQL Server, or MySQL).
• Experience with data warehousing and API integration (REST/SOAP)
• Procurement, Provision and Management using technical governance of CI/CD Pipelines (experience with GCP preferable)
• Previous experience with major ERP platforms (e.g., SAP, Oracle NetSuite, Microsoft Dynamics 365, or specialized manufacturing ERPs).
• Proficiency in Python, JavaScript, or Groovy (for Jira scripts/database automation) is a significant plus.
• Experience in Jira/Confluence administration (Cloud or Data Center).
• Familiarity with JQL (Jira Query Language) and Automation for Jira.
• Ability to troubleshoot complex integration failures and identify root causes.
• Ability to explain technical concepts to non-technical stakeholders across various departments.
• Strong organizational skills to balance maintenance tasks with long-term implementation projects.

Nice To Haves

• Relevant certifications (e.g., Atlassian Certified Professional, Microsoft SQL Certification, or ERP-specific credentials) are preferred.

Responsibilities

• Design, build, and maintain relational databases to support business applications and reporting requirements.
• 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.
• Monitor database performance, perform regular tuning, and ensure data integrity and security across all environments.
• Capture and integrate business needs into user-interface applications.
• Create complex analysis queries and views to provide clean data sets for Business Intelligence (BI) tools and executive dashboards.
• Manage relationships with ERP vendors and consultants to resolve high-level technical bugs and influence product roadmaps.
• Support the end-to-end implementation of ERP modules, including requirement gathering, configuration, User Acceptance Testing (UAT), and go-live support.
• Work with stakeholders to translate business requirements into ERP functional specifications.
• Perform regular system updates, patch management, and troubleshooting of ERP-related issues (e.g., finance, supply chain, or manufacturing modules).
• Act as the primary administrator for Jira (Software/Service Management) and Confluence.
• Design and implement custom workflows, permission schemes, notification schemes, and screen schemes tailored to departmental needs.
• Provide technical support to end-users and develop documentation/best practices to increase adoption and tool efficiency

Benefits

• Immediate medical, dental, vision and prescription drug coverage
• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more
• Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
• Vehicle discount program for employees and family members and management leases
• Tuition assistance
• Established and active employee resource groups
• Paid time off for individual and team community service
• A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
• Paid time off and the option to purchase additional vacation time.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree