Data Integration Engineer

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:Design, develop and maintain robust, secure and scalable APIs to support data integration and exchange between systems for optimal performanceMonitor and troubleshoot ETL jobs to ensure data accuracy and integrityDesign 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 reliabilityMaintain and develop secure file transfer software (SFTP) workflowsCollaborate with Data Architects and Analysts to understand data requirements and design appropriate data models, while ensuring data quality and consistency across different systemsImplement data governance and best practices for data management, and standard upgrades to the ERP systemComplete routine database refresh cyclesProvide technical guidance and support to team membersDocument processes, designs and solutions for legacy informationQUALIFICATIONS:Bachelor's Degree in Computer Science, Information Science or related field or 5+ years of Integration & Data Engineer work experience3+ years of Integration & Data Engineer work experienceExperience in API development and ETL processesExperience with API frameworks (e.g., Flask, FastAPI, Spring Boot)Proficiency in programming languages such as Python, Java, or ScalaSystem 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) PREFERRED QUALIFICATIONS:Experience configuring & supporting Fortinet or equivalent enterprise firewall productsPrevious experience with SMB/enterprise network switching and wireless (Ubiquiti)Relevant industry certifications (Microsoft, Fortinet, CompTIA, etc.)Manufacturing, distribution, or industrial industry experience OUR EMPLOYEE VALUE PROPOSITION:Market competitive benefits package, including company-sponsored health coverage, life insurance, 401(k) plan with company match, paid parental leave and paid time offWork in a collaborative environment with passionate and innovative teammatesSolve is proud to be an Equal Opportunity Employer and prohibits discrimination or harassment of any kind. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, pregnancy, national origin, ancestry, citizenship status, age, marital or partnership status, sexual orientation, gender identity or expression, disability, genetic predisposition, veteran or military status, status as a victim of domestic violence, a sex offence or stalking, or any other class or status in accordance with applicable federal, state, and local laws.