ADTRAV Travel Management, founded in 1977, has over four decades of experience in managing corporate, government, vacation, group, meetings, and incentive travel programs across the United States. We have experienced steady growth throughout our history and are currently ranked as one of the top business travel management companies in the country.

ADTRAV is seeking a Principal Data Engineer to be responsible for leading the design, development and implementation of components within ADTRAV’s business intelligence application.

This position has access to data as part of a government contract, and it is a requirement of the contract for individuals to be a U.S. citizen. Candidates must be able to show proof upon hire that they meet this requirement. In addition, this position is required to pass a government clearance process.

Essential Duties and Responsibilities include the following:

Lead the design, development, and implementation of major components of the RezIntel platform.
Work with cross-functional teams to gather requirements and understand data needs.
Implement data ingestion, storage, and processing solutions for structured and unstructured data.
Ensure the data storage system is scalable and highly available.
Develop and maintain data pipelines and ETL/ELT processes.
Maintain a strong understanding of a data lifecycle.
Conduct data modeling and create documentation like data definitions, data flow diagrams, and process definitions.
Automate and ensure data quality.
Design and develop database objects, tables, stored procedures, views, and ETL pipelines.
Conduct performance tuning of T-SQL, including stored procedures, views, functions, etc.
Mentor and instruct other engineers on best practices.
Analyze, solve, and correct issues in real-time.
Provide engineering estimates.
Use Agile development tools to track and communicate project progress.
Stay up to date on new information technologies and emerging trends, and their possible application in the company.
Work non-standard business hours to attend meetings and provide support via text/phone/email in a 24/7/365 environment.
Represent ADTRAV by embracing the company values and maintaining effective working relationships with employees, partners, vendors, and clients.
Adhere to company policies and procedures.
Other duties as assigned.

Qualifications:

Bachelor’s Degree in related field or equivalent experience required.
10+ years of experience in ETL technologies and concepts like SSIS and Python/Pandas.
8+ years of experience in Data Warehousing, DataVault, and Data Mart concepts and implementation especially in relational databases like SQL Server.
Ability to mentor engineering teams on best practices.
Strong SQL knowledge and work experience with relational databases such as Microsoft SQL Server, or PostgreSQL.
Experience in architecting, crafting, and developing highly scalable distributed data processing systems.
Experience architecting DataVault and/or Kimbell systems.
Experience in using visualization and reporting tools such as SSRS, Qlik Sense, and PowerBI.
Experience implementing data solutions in Azure and on-prem data centers using ETL tools, queues, batch scheduling services and various storage solutions.
Background in data analysis and data modeling.
Experience in Agile SDLC methodologies (Kanban and Scrum).
Experience building and deploying applications using continuous integration pipelines and automated deployment tools such as Azure DevOps, etc.
Hands on experience with Python, Pandas, and other Python ETL tools required.
Ability to estimate the work required and deliver the project on schedule as estimated.
Experience with source control such as Git or TFS.
Experience with issue tracking systems such as Jira or Azure DevOps.
Ability to learn ADTRAV’s business and products quickly and adapt to a dynamic development environment.
Excellent English written and verbal communication skills.
Ability to communicate ideas and concepts clearly and concisely, while also being open to receive feedback and direction as needed.
Highly self-motivated and able to prioritize and manage multiple tasks with varying deadlines.
Able to work in a fast-paced environment while balancing both strategic and tactical responsibilities.
Detail oriented with strong organizational and analytical skills.
“Can do” problem solving mentality, while still respecting standards, quality, and security.
Able to present a professional and positive demeanor with internal and external customers/clients and work cooperatively.
Ability to work remotely and meet the company home-office requirements, including stable, high-speed internet.
Able to maintain confidentiality of company and client information.
Able to work outside of normal business hours and provide 24/7/365 support to team.
Able to successfully pass a credit, criminal, and/or employment reference background check.
This position has access to data as part of a government contract, and it is a requirement of the contract for individuals to be a U.S. citizen. Candidates must be able to show proof upon hire that they meet this requirement.
Able to successfully pass a government clearance process as required by clients.

The salary range for this position is $140,000-160,000 a year but consideration may be given outside of this range. Pay is based on experience with the role and with the required applications/technologies. ADTRAV offers a competitive benefits package that includes medical, dental, vision, life, disability, Flexible Spending Accounts, 401(k), and PTO.

ADTRAV Corporation an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.