Shift : Compensation :
Competitive
Capstone is a North American supply chain solutions partner with more than 650 operating locations, 19,000 associates, and 60,000 carriers. We have capabilities in freight management, warehouse and distribution center support, last-mile delivery, supply chain analytics, and optimization, and more. Our integrated, end-to-end logistics solutions uniquely position us to help partners reduce warehousing and transportation costs.
The Data Integration Developer will be responsible for the creation and maintenance of data integrations for entities within Capstone Logistics and partners outside of Capstone Logistics. Daily activities will include development and testing of integrations between systems and entities. In addition, this role will be responsible for monitoring and troubleshooting active data integrations. This candidate will act as technical expert for data integration initiatives.
- This role is responsible for executing initiatives in multiple functional areas, prioritizing requests and escalating risks and concerns.
- Develops domain expertise to contribute to technical and strategic discussions.
- Serves as a key contributor toward fostering a positive work environment and helping drive company culture.
ESSENTIAL FUNCTIONS :
Responsibilities :
Design, develop and test data integrations for both internal and external systems.Support requirements gathering on business process, existing systems / reports, and problem areas.Checking and correcting integration conflicts and resolving data errors.Analyze and improve current system integrations.Support the identification of data sources and perform extensive analysis and data profiling on these systems.Ability to provide technical assistance and troubleshooting by effectively responding to inquiries.Track scope and changes throughout the implementation of reports and application changes, keeping stakeholders notified of anticipated completion dates.Create and analyze business reports to provide performance insights, to forecast staffing needs, and determine trends.Generate regular and ad hoc reports for both internal and external use.Performs Additional Responsibilities As AssignedQUALIFICATIONS :
Education and / or experience :
Bachelor's Degree in a technical field (statistics, mathematics, science, accounting, finance) or related field2+ Years of data processing experience2+ years' experience with data integrations2+ Years RDBMS experienceStrong SQL Processing and modeling skillsOLTP / OLAP experienceFunctional API experienceExpertise in data pipeline transformation processes (ETL, ELT, Event Driven)Experience with SSIS, Azure Data Factory or comparable.Preferred Skills :
Data Warehouse experienceMaster Data ManagementFunctional Data / Server administration skillsReport construction familiarity.Cloud experienceC#, Java or other procedural coding experienceExperience with business process mapping, data flow diagraming and the use of project management softwareProfessional Skills :
Demonstrated ability to manage time and prioritize projects to meet deadlinesExcellent listening, written, and oral communication skillsExcellent critical thinking skills to help solve business problems and make decisions, paired with a desire to take initiativeAbility to maintain project plans, resourcing schedules, and forecasted activitiesAbility to work well under continually changing deadlines and priorities#LI-JJ1
#CB
Capstone Logistics, LLC is part of The Transportation and Logistics industry which has been designated a "Critical Infrastructure Segment". As a "critical infrastructure industry" worker in the Transportation and Logistics industry, associates are considered exempt from local restrictions such as curfews, shelter-in-place orders, and other mobility restrictions when reporting to, returning from, or performing his or her work functions.