Automation & Integration Specialist--PJ

Responsibilities

• Follow enterprise data management processes under supervision of Data Operations Manage to perform the following job duties. Manage existing integrations and troubleshoot errors
• Design and implement integrations between packaged software solutions with support of team members, consultants and third-party developers as needed
• Perform end to end testing both internally and with third party partners to ensure any new software integration meets requirements
• Analyze documentation and technical specifications of any new integrated application being considered to determine fit for use Build and maintain data warehouse solutions supporting BI solutions

Requirements

• Critical-Thinking, Problem-Solving, Team Collaboration Understanding of system integration design Experience with cloud integration software/middleware (like Workato, or Boomi) Microsoft Office/Microsoft 365
• Experience with Visio or other business flow tools Intermediate level experience with MS Excel functionalities (Pivot Table, vlookup)
• Experience building API s using REST or SOAP Exposure to Database management tasks (create tables, views, joins etc. ) will be a plus
• Experience with cloud data platforms will be a plus (like Redshift or Snowflake) Knowledge of SQL, Python, R will be a plus

Technical Skills

• System Integration, Cloud Integration, Middleware, Workato, Boomi, Microsoft Office, Microsoft 365, Visio, MS Excel, APIs, REST, SOAP, Database Management, Redshift, Snowflake, SQL, Python, R