We are seeking an Data Integration Analyst to work within our Business Intelligence team to design, develop, test and implement Data Services ETL solutions for batch and real-time. Perform tasks associated with data migration of ERP systems: conduct mapping sessions with subject matter experts; perform data profiling, cleansing, matching, de-duplication and transformation; perform testing and mock loads; participate in "go-live" events. Troubleshoot and debug existing ETL processes in a production environment. Provide technical support for patch and release upgrades to ETL software. Contribute ideas for continuous improvement of existing processes. Perform other duties as assigned.

Required Skills

• Business Objects Data Services (BODS) ETL and Admin work.
• Azure Synapse Analytics and Azure Data Bricks ETL work.
• Knowledge of SAP Business Objects Data Services (BODS) version 4.2 including Designer, Management Console, etc.
• Experience working with large volumes of data in a diverse database environment.
• Strong knowledge of relational data design and structured query language (SQL)
• Experience with MS SQL and SAP HANA.
• Knowledge of SAP ERP and integration tools (LSMW/IDOC/BAPI/Winshuttle)is highly preferred. Experience with other ERP systems is also beneficial.
• Exposure to SAP HANA SDI and SDA integration technologies.
• Ability to work with spreadsheets and other file formats as inputs and outputs.
• Experience with File transfer protocols (FTP, SFTP)
• Coding experience in SQL and ABAP.

Following Skills/Experience is a Plus

• SAP Data Replication experience preferred
• Exposure to SAP Business Warehouse.
• Knowledge of MDM, PIM, CRM and Hybris.
• SAP ECC functionality in the areas of Sales, Purchasing, Inventory and Finance.

Education:

• Bachelor's degree in Computer Science, Engineering or related field.

Applied Industrial Technologies (NYSE: AIT)is a leading value-added distributor and technical solutions provider of industrial motion, fluid power, flow control, automation technologies, and related maintenance supplies. Our leading brands, specialized services, and comprehensive knowledge serve MRO and OEM end users in virtually all industrial markets through our multi-channel capabilities that provide choice, convenience, and expertise.

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, gender, sexual orientation, age, disability, protected veteran status, marital status, medical condition or any other characteristic protected by law.

If you need accommodation for any part of the employment process because of a disability, please send an email to hiring@applied.com or call 216-426-4389 to let us know the nature of your request.