Principal Data Engineer

ADTRAV Travel Management

Lead design and development of ADTRAV's business intelligence application. Require U.S.

Posted 5/1/2026full-time🇺🇸 United StatesLead💰 $140,000 - $160,000 per yearWebsite

Tech Stack

Tools & technologies

AzureETLMS SQL ServerPandasPostgresPythonSDLCSQLSSISTFS

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

medical
dental
vision
life
disability
Flexible Spending Accounts
401(k)
PTO

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL technologiesSSISPythonPandasData WarehousingDataVaultData MartSQLT-SQLData modeling

Soft Skills

mentoringcommunicationproblem solvingorganizational skillsanalytical skillsself-motivatedadaptabilitydetail orientedtime managementcollaboration