Data Integration Administrator - Remote
Direct Travel
Data Integration Administrator – Remote
Embark on the next step in your career journey with Direct Travel!
As one of the fastest growing Travel Management Companies (TMC) in the world, Direct Travel is committed to reimagining what is possible for the industry, including business travel, personalized experiences, and meetings & events. Under the forward-thinking direction of our experienced leadership team, we are rapidly expanding and leveraging next-generation technologies to deliver on our vision for The Perfect Trip. This is your opportunity to grow your career and be part of a dynamic team that is setting the new standard of travel and service excellence. If you’re passionate about innovation and ready for what’s next, we’d love for you to join us!
As a key member within the IT Enterprise Architecture (ITEA) organization, the Data Integration Administrator will be responsible for the design, development, implementation, and management of SSIS processes for imports, exports, reconciliations, and custom data transformations. This role also involves performing basic database administration tasks, optimizing SQL queries and ensuring data accuracy across multiple systems.
The Data Integration Administrator will collaborate with cross-functional teams to support operational data needs, troubleshoot issues, and implement scalable solutions that drive business efficiency and data integrity.
Expedition Expectations
- Design, develop, implement and maintain SSIS packages to extract, transform, and load data from various sources into data warehouses or databases including use of C# script tasks and integration with APIs.
- Develop and maintain minor customizations for managing data quality within CentralCommand.
- Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications.
- Monitor and optimize SSIS packages for performance and efficiency.
- Ensure data quality and integrity for imports, exports and reconciliations.
- Stay up to date with the latest developments in SSIS, and related technologies, and recommend enhancements as needed.
- Provide training and support to team members and end-users on SSIS tools.
- Participate in project planning and execution, ensuring timely delivery of projects.
- Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications.
- Working with 3rd parties like Banks, Credit Card Vendors, and Data Platforms like Grasp Technologies to design, configure and run integrations in a scalable fashion
- Working with Customers on requirements, setup, configuration and troubleshooting
- Internal project management
Passport to Success
- Bachelor's degree or equivalent experience in Computer Science, Information Technology, or a related field.
- 3-5 years of experience with enterprise resource planning (ERP) platforms such as Unit4 ERP, Microsoft Dynamics 360, Oracle NetSuite or an equivalent.
- 7-10 years of extensive experience in SSIS design and development including use of C# script tasks and integration with APIs.
- 7-10 years of strong proficiency in SQL Server, T-SQL, and data modeling concepts.
- 3-5 years of basic SQL Server DBA skills including back-ups, restores, security, replication and basic troubleshooting.
- Excellent problem-solving skills and attention to detail.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
- 2-3 years of familiarity with cloud technologies is a plus.
- Must be able to lawfully work within the US and have unrestricted work authorization for US
Going the Extra Mile
- Certifications in Microsoft SQL Server or related technologies.
- Experience with Agile methodologies and project management.
- Previous Travel technology experience - EDIFACT
- Unit4 Central Command expertise
- Extensive DBA experience
Benefits Onboard
In addition to Medical, Dental, and Vision benefits Direct Travel offers an employee rewards and recognitions program, Total Rewards Package which includes Wellness, Sustainability, DE&I initiatives, and Mental Health Support.
Our Brand Voyage: Direct Travel
Direct Travel is a leading provider of corporate travel management services. By leveraging both the expertise of its people and innovative solutions, Direct Travel enables clients to derive the greatest value from their travel program in terms of superior service, progressive technologies, and significant cost savings. The company is led by CEO Christal Bemont and Executive Chairman Steve Singh, noted business investor and founder of Concur. Direct Travel has offices in over 80 locations and is currently ranked among the top providers of travel on Travel Weekly’s Power List. For more information, visit www.dt.com.
Direct Travel is an EOE/AA/Veteran/People with Disabilities employer
If you're ready to chart a new course and advance your career with the valuable moments and travel experiences that await, we welcome you to submit your resume for consideration at Direct Travel.