Data Integration Consultant

Endava•New York, NY

1d•Hybrid

About The Position

Support enterprise integration initiatives across the Boomi platform and custom-built integration solutions. Design, develop, enhance, and support data integrations using the Boomi platform, application-specific tools and APIs, and custom integration code developed in C# and Python. Enterprise data flows, integration patterns, API-based development, data transformation, error handling, production support, and the movement of sensitive HR, Finance, and operational data across systems. Design, build, test, deploy, and support integrations using the Boomi platform. Develop Boomi processes for data extraction, transformation, routing, validation, and delivery across enterprise systems. Configure Boomi connectors, maps, profiles, decision logic, document properties, process properties, and exception handling. Build integrations using REST APIs, SOAP web services, SFTP, flat files, XML, JSON, CSV, databases, and other common integration endpoints. Monitor Boomi process executions, investigate failures, and resolve integration errors. Improve existing processes for reliability, maintainability, performance, and operational visibility. Implement logging, alerting, retry logic, and error-handling frameworks for production integrations. Design, develop, and support seamless integrations involving Workday HCM, Finance, Payroll, Benefits, Recruiting, Security, and Reporting data to allow for efficient data exchange and accurate reporting. Work with Workday integration technologies such as Workday Web Services, EIB, Core Connectors, RaaS reports, custom reports, Workday Studio, and Workday BIRT Reports where applicable. Design, develop, and maintain user-provisioning integrations that originate from Workday and flow into Google Workspace and other downstream enterprise systems. Extract, transform, analyze, and deliver Workday data to downstream systems through Boomi, APIs, files, or custom services. Troubleshoot integration issues related to data availability, security access, report output, transformation logic, and downstream system errors, providing primary integration support for all users. Develop and validate business logic, workflow, field mappings, supervisory organizations, cost centers, worker data, finance data, contracts, and approval-related data in Workday. Develop custom integration components, utilities, APIs, scripts, and services using C#, Python, and Java to ensure technical capability across platforms. Build lightweight services or tools to support data validation, API orchestration, file processing, exception handling, and integration automation. Develop scripts and utilize technical tools for data cleansing, reconciliation, transformation, XSLT comparison, and troubleshooting. Work with SQL databases, APIs, and file-based data sources to maintain robust documentation and ensure integration implementation is successful.

Requirements

Onsite 3 days a week in New York City office
Strong hands-on experience on designing and supporting Workday integrations.
Working knowledge of Workday Web Services, EIBs, Core Connectors, RaaS reports, and Workday security concepts.
Experience with Workday HCM, Workday Finance, Payroll, Benefits, or Procurement integrations.
Strong experience with REST APIs, SOAP services, JSON, XML, CSV, SFTP, and database integrations.
Experience with cloud platforms such as Google Cloud Platform, AWS, or Azure.
Hands-on development experience with C# and Python.
Strong SQL skills for data validation, troubleshooting, reconciliation, and reporting.
Experience with integration testing, deployment, monitoring, and production support.
Ability to troubleshoot complex data and integration issues across multiple systems.
4-years or more experience in the fields

Nice To Haves

Strong hands-on experience with Boomi integration development.

Responsibilities

Support enterprise integration initiatives across the Boomi platform and custom-built integration solutions.
Design, develop, enhance, and support data integrations using the Boomi platform, application-specific tools and APIs, and custom integration code developed in C# and Python.
Design, build, test, deploy, and support integrations using the Boomi platform.
Develop Boomi processes for data extraction, transformation, routing, validation, and delivery across enterprise systems.
Configure Boomi connectors, maps, profiles, decision logic, document properties, process properties, and exception handling.
Build integrations using REST APIs, SOAP web services, SFTP, flat files, XML, JSON, CSV, databases, and other common integration endpoints.
Monitor Boomi process executions, investigate failures, and resolve integration errors.
Improve existing processes for reliability, maintainability, performance, and operational visibility.
Implement logging, alerting, retry logic, and error-handling frameworks for production integrations.
Design, develop, and support seamless integrations involving Workday HCM, Finance, Payroll, Benefits, Recruiting, Security, and Reporting data to allow for efficient data exchange and accurate reporting.
Work with Workday integration technologies such as Workday Web Services, EIB, Core Connectors, RaaS reports, custom reports, Workday Studio, and Workday BIRT Reports where applicable.
Design, develop, and maintain user-provisioning integrations that originate from Workday and flow into Google Workspace and other downstream enterprise systems.
Extract, transform, analyze, and deliver Workday data to downstream systems through Boomi, APIs, files, or custom services.
Troubleshoot integration issues related to data availability, security access, report output, transformation logic, and downstream system errors, providing primary integration support for all users.
Develop and validate business logic, workflow, field mappings, supervisory organizations, cost centers, worker data, finance data, contracts, and approval-related data in Workday.
Develop custom integration components, utilities, APIs, scripts, and services using C#, Python, and Java to ensure technical capability across platforms.
Build lightweight services or tools to support data validation, API orchestration, file processing, exception handling, and integration automation.
Develop scripts and utilize technical tools for data cleansing, reconciliation, transformation, XSLT comparison, and troubleshooting.
Work with SQL databases, APIs, and file-based data sources to maintain robust documentation and ensure integration implementation is successful.

Benefits

Competitive salary package
share plan
company performance bonuses
value-based recognition awards
referral bonus
Career coaching
global career opportunities
non-linear career paths
internal development programmes for management and technical leadership
Complex projects
rotations
internal tech communities
training
certifications
coaching
online learning platforms subscriptions
pass-it-on sessions
workshops
conferences
Hybrid work and flexible working hours
employee assistance programme
Global internal wellbeing programme
access to wellbeing apps
Global internal tech communities
hobby clubs and interest groups
inclusion and diversity programmes
events and celebrations
Robust healthcare and benefits including Medical, Dental, vision, Disability coverage, and various other benefit options
Flexible Spending Accounts (Medical, Transit, and Dependent Care)
Employer Paid Life Insurance and AD&D Coverages
Health Savings account paired with our low-cost High Deductible Medical Plan
401(k) Safe Harbor Retirement plan with employer match with immediately vest