• Data Integration Specialist

    Robert Half Technology (Dallas, TX)


    Description Data Integration Specialist

    Key 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, data integration, and the systems used (Workday, Medius, etc.).

    Qualifications:

    • Heavy experience using Azure processes (ADF, Azure SQL DB, etc.)

    • SQL experience (SSMS, SSIS, SSAS)

    • Python experience

    • Proficiency 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.

    • Familiarity with various relational databases like Oracle, Microsoft-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. Requirements ETL - Extract Transform Load, SSIS ETL, Azure Data Factory, Microsoft SQL, Python Technology Doesn't Change the World, People Do.®

     

    Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

     

    Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.

     

    All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

     

    • 2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https://www.roberthalf.com/us/en/terms) .