Data Integration Developer

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

QUALIFICATIONS:

Education and/or experience:

• Bachelor's Degree in a technical field (statistics, mathematics, science, accounting, finance) or related field
• 2 Years of data processing experience
• 2 years' experience with data integrations
• 2 Years RDBMS experience
• Strong SQL Processing and modeling skills
• OLTP/OLAP experience
• Functional API experience
• Expertise in data pipeline transformation processes (ETL, ELT, Event Driven)
• Experience with SSIS, Azure Data Factory or comparable.

Preferred Skills:

• Data Warehouse experience
• Master Data Management
• Functional Data/Server administration skills
• Report construction familiarity.
• Cloud experience
• C#, Java or other procedural coding experience
• Experience with business process mapping, data flow diagraming and the use of project management software

Professional Skills:

• Demonstrated ability to manage time and prioritize projects to meet deadlines
• Excellent listening, written, and oral communication skills
• Excellent critical thinking skills to help solve business problems and make decisions, paired with a desire to take initiative
• Ability to maintain project plans, resourcing schedules, and forecasted activities
• Ability to work well under continually changing deadlines and priorities