Data Integration Engineer
Charlotte, NC
Full Time
Experienced
Solve Industrial Motion Group is a global manufacturer of bearings and power transmission parts. Solve’s brand portfolio includes P.T. International, IPTCI Bearings, LMS Bearings, TRITAN Precision Power Transmission Components, SST, MasterDrive and SPB. Collectively, they represent more than 100,000 products available from nine locations nationwide. Our unmatched dedication to quality materials and manufacturing processes, rigorous quality control, and end-to-end support and service have helped us grow to become a trusted supplier to high-performance industries worldwide. Our team members are knowledgeable “go-to” resources for power transmission products, support, and advice that keeps our customers’ businesses moving forward.
POSITION DESCRIPTION: Reporting to the CIO, the Data Integration Engineer is Solve’s architect of synergy; designing, developing and implementing solutions that allow for efficient data exchange and process automation across various platforms. In this multi-faceted role, the ideal candidate will have a deep understanding of both hardware and software, ensuring that system integrations are executed smoothly, securely, and in a way that optimizes performance. The Data Integration Engineer will utilize their excellent problem-solving and communication skills in collaboration with business stakeholders to gather requirements, as well as software development, database, and business intelligence teams to deliver high quality integration solutions. The ideal candidate will lean into their experience with ETL processes, API integrations, data architecture, and cloud solutions as the “go-to” person for seamless data management and integration for the organization.
RESPONSIBILITIES:
POSITION DESCRIPTION: Reporting to the CIO, the Data Integration Engineer is Solve’s architect of synergy; designing, developing and implementing solutions that allow for efficient data exchange and process automation across various platforms. In this multi-faceted role, the ideal candidate will have a deep understanding of both hardware and software, ensuring that system integrations are executed smoothly, securely, and in a way that optimizes performance. The Data Integration Engineer will utilize their excellent problem-solving and communication skills in collaboration with business stakeholders to gather requirements, as well as software development, database, and business intelligence teams to deliver high quality integration solutions. The ideal candidate will lean into their experience with ETL processes, API integrations, data architecture, and cloud solutions as the “go-to” person for seamless data management and integration for the organization.
RESPONSIBILITIES:
- Design, develop and maintain robust, secure and scalable APIs to support data integration and exchange between systems for optimal performance
- Monitor and troubleshoot ETL jobs to ensure data accuracy and integrity
- Design and implement ETL pipelines to extract, transform, and load data from various sources into data warehouses or other storage solutions, while optimizing processes for efficiency and reliability
- Maintain and develop secure file transfer software (SFTP) workflows
- Collaborate with Data Architects and Analysts to understand data requirements and design appropriate data models, while ensuring data quality and consistency across different systems
- Implement data governance and best practices for data management, and standard upgrades to the ERP system
- Complete routine database refresh cycles
- Provide technical guidance and support to team members
- Document processes, designs and solutions for legacy information
- Bachelor's Degree in Computer Science, Information Science or related field or 5+ years of Integration & Data Engineer work experience
- 3+ years of Integration & Data Engineer work experience
- Experience in API development and ETL processes
- Experience with API frameworks (e.g., Flask, FastAPI, Spring Boot)
- Proficiency in programming languages such as Python, Java, or Scala
- System architecture and system/data engineering experience
- Strong working knowledge of SQL and database management systems (e.g., PostgreSQL, MySQL, SQL Server)
- Experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery)
- Experience with ERP integrations (Epicor, Oracle, SAP, NetSuite)
- Experience with cloud platforms (e.g., AWS, Azure, GCP)
- Experience configuring & supporting Fortinet or equivalent enterprise firewall products
- Previous experience with SMB/enterprise network switching and wireless (Ubiquiti)
- Relevant industry certifications (Microsoft, Fortinet, CompTIA, etc.)
- Manufacturing, distribution, or industrial industry experience
- Market competitive benefits package, including company-sponsored health coverage, life insurance, 401(k) plan with company match, paid parental leave and paid time off
- Work in a collaborative environment with passionate and innovative teammates
Apply for this position
Required*