Senior Accountant
January 14, 2025Tax Director
January 17, 2025Data Integration Specialist
Job Summary:
Our client is seeking a Data Integration Specialist with experience in Azure, SQL, and data warehousing to support their growing team of developers. The ideal candidate will play a pivotal role in transitioning the acquired company’s systems to their platform, assisting with critical go-live phases and future initiatives. This position is integral to meeting project deadlines and ensuring a seamless migration off their current integration tool, Dell Boomi, to Azure.
Responsibilities:
- Design and Develop Integration Solutions: Create and implement integration workflows, understanding business requirements, data sources, and target systems.
- Build Data Integration Processes: Develop and configure processes to extract, transform, and load (ETL) data between various systems, including data warehouses, Azure, Medius, Workday and other applications.
- Maintain Data Warehouse: Create and maintain integration processes from ERP systems and other source systems into a data warehouse to maximize uptime and fresh data to be fed into Power BI reports for business users.
- Implement EDI File Transmission: Configure integration systems to handle the transmission and transformation of EDI messages between trading partners, ensuring compliance with industry standards.
- Integrate with Workday and Medius: Establish seamless integration between Azure and Workday, as well as Medius, to enable smooth accounts payable automation and streamline invoice processing.
- Collaborate with Stakeholders: Work closely with business analysts, data architects, system administrators, and other team members to gather requirements and ensure effective integration solutions.
- Ensure Data Quality: Implement data validation mechanisms to ensure data accuracy, consistency, and adherence to business rules.
- Optimize Performance: Analyze and optimize integration processes, identifying and resolving performance bottlenecks.
- Document and Report: Maintain clear and comprehensive technical documentation of integration processes, mappings, configurations, and workflows. Generate reports and provide insights into integration activities.
- Continuous Improvement: Stay updated with the latest industry trends, technologies, and best practices related to Azure, Dell Boomi, data integration, and the systems used (Workday, Medius, etc.).
Qualifications:
- Experience using Azure processes (ADF, Azure SQL DB, etc.)
- Heavy SQL experience (SSMS, SSIS, SSAS)
- Proficiency in building Boomi processes, managing/deploying/supporting APIs, and leveraging common frameworks such as message queuing, caching, complex mapping, and scripting (JavaScript, Groovy).
- Proficiency with integration technologies such as HTTP Web Services (SOAP/REST), XML, JSON, and Flat file.
- Experience with JDBC adapter, JMS adapter, Web Service (SOAP and REST), and WSDL.
- Understanding of enterprise integration tools, middleware technologies, and data integration patterns, including Pub/Sub Messaging, EIP, Event-Driven Architecture, SOA, and iPaaS.
- Experience in maintaining existing APIs, reviewing, and enhancing code.
- Experience with Boomi Atom Management, Process Reporting, Deployments, and API Management.
- Familiarity with various relational databases like Oracle, MS-SQL Server, and MySQL.
- Knowledge of EDI X12/EDIFACT transaction sets and working with real-time and scheduled processes.
- Strong technical designing, interface designing, research and development skills, client interaction, onsite coordination, estimations, application development, documentation, and code review.
#IND
#ZP
#ZIP
#ZR