ERP Data Engineer

JOB PURPOSE

The ERP/Data Engineer is responsible for administering and enhancing the organization’s ERP platform (SAP Business One), engineering data integrations, and managing the SQL Server environment to ensure reliable, high-quality data operations. This role supports enterprise reporting, analytics, and system workflows by designing ETL processes, building data pipelines, and maintaining cross-system data integrity.

The ERP/Data Engineer acts as a key technical resource supporting SAP B1, SQL Server databases, business applications, ETL workflows, and reporting platforms, ensuring performance, accuracy, and security across mission-critical systems.

ESSENTIAL JOB FUNCTIONS

ERP Administration (SAP Business One)

· Administer SAP B1 including user provisioning, roles/permissions, license management, password resets, and account maintenance.

· Develop and manage SQL-based queries and SAP Query Manager reports to support operational and financial data needs.

· Configure Boyum add-on components including custom fields, validations, form logic, and workflow rules.

· Create and manage SAP UDFs, UDTs, and modify database structures as required for business processes.

· Perform data imports and structured uploads into SAP B1 using Data Transfer Workbench (DTW), ensuring high data quality and control.

· Collaborate with SAP support partners for escalated issues, enhancements, and ERP optimization.

Data Engineering, ETL, & Integration Development

· Design, build, test, and maintain new ETL workflows and data pipelines to enable reliable data movement between business systems.

· Develop transformation logic, mapping rules, and data validation processes to ensure data consistency across platforms.

· Troubleshoot integration failures, missing or unprocessed records, API issues, and message-queue disruptions.

· Implement monitoring, error handling, and alerting dataflows to proactively detect and resolve issues.

· Work with business stakeholders to define data requirements, integration needs, and pipeline specifications.

SQL Server Engineering & Database Administration

· Develop SQL Server schemas, tables, views, stored procedures, and SQL Agent jobs to support operational workflows.

· Monitor, troubleshoot, and optimize SQL performance; maintain linked servers and scheduled job execution reliability.

· Manage SQL Server security including user accounts, permissions, and audit logs.

· Perform database restores, testing, and environment validation as required.

· Execute database cleanup tasks, maintain staging areas, and ensure removal of outdated or resolved error records.

Application & Cross-System Support

· Serve as point-of-contact for field users experiencing EHR, ERP, or other application-related issues, including access errors and system disruptions.

· Manage application accounts, roles, dashboards, and custom reporting in Cobblestone Contract Management.

· Ensure data synchronization accuracy between ERP and integrated business applications.

· Participate in vendor meetings for system updates, implementations, and issue resolution.

Business Intelligence & Reporting

· Develop dashboards and reports in Power BI, Tableau, and Report Builder to support decision-making across the organization.

· Build and manage SQL views and report datasets optimized for performance and accuracy.

· Refresh and modernize legacy reports to align with current systems and business definitions.

· Support future cloud-based reporting initiatives and data warehouse integrations.

Documentation, Quality, & Continuous Improvement

· Document ETL processes, data flows, integration logic, and system procedures.

· Conduct data quality checks, implement validation routines, and improve error detection mechanisms.

· Identify opportunities to automate and streamline operational tasks.

· Support incident investigations with root cause analysis and corrective action plans.

QUALIFICATIONS

Education & Experience

· Bachelor's degree in Information Technology, Computer Science, Data/Analytics, or a related field; equivalent combination of education and professional experience may be considered.

· 5+ years of experience in data engineering, ERP administration, SQL development, or related enterprise IT roles.

Technical Skills

· Strong proficiency in Microsoft SQL Server (T-SQL, stored procedures, agent jobs, views, indexing, roles/permissions).

· Experience with SAP Business One administration, Query Manager, DTW, and Boyum add-ons preferred.

· Understanding of ETL processes, data transformation methods, and pipeline development best practices.

· Experience troubleshooting data integrations, APIs, and system-to-system workflows.

· Hands-on experience with BI tools (Power BI, Tableau, or similar).

· Familiarity with cloud data concepts (Azure preferred).

Core Competencies

· Strong analytical, troubleshooting, and problem-solving skills.

· Ability to work in a fast-paced environment with shifting priorities.

· Excellent communication skills (written and verbal).

· High attention to detail and strong documentation discipline.

· Ability to maintain confidentiality and handle sensitive information responsibly.

· Customer-service orientation and teamwork mindset.

PHYSICAL REQUIREMENTS

· Prolonged periods sitting or standing at a computer workstation.

· Regular use of phones, video calls, and electronic communication tools.

· Occasional lifting of office materials up to 50 lbs.

WORK ENVIRONMENT

· This is a hybrid role requiring onsite presence on a weekly basis. Remote work opportunities are available following successful onboarding and demonstrated proficiency in the role, subject to business needs.

· Office environment with standard IT equipment.

· Regular interaction with staff, vendors, and cross-functional teams.

· Deadlines and operational demands may require prioritization and rapid response.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

Pay: $92,000.00 - $116,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

Work Location: Hybrid remote in Plymouth, MI 48170