• Own pipeline and infrastructure work from intake through production • Build and maintain ingestion and transformation pipelines from operational systems, third-party APIs, and event streams into the warehouse • Turn product and business requirements into specifications and well-modeled datasets • Write and maintain Terraform for the AWS resources your pipelines run on • Use CI/CD to ship pipeline and infrastructure changes safely and often • Build data quality checks, unit tests, and integration tests for the pipelines you own • Use modern tooling, including AI assistants, to move faster on development, testing, and documentation • Build datasets and reporting layers for product features, BI, and operational reporting • Work with Product, Engineering, Operations, Sales, and Compliance so data solutions actually fit the downstream use case • Write the runbooks and documentation that on-call teammates and stakeholders will rely on • Watch your pipelines in production and fix issues before someone has to ask • Keep up with what is changing in data engineering, cloud infrastructure, and fintech compliance

• Join a ~100-person team of experienced problem solvers building real products across Cloud, Data & AI, and Software Development • Work in an AI-oriented environment applying modern tech to real business problems • Collaborate with clients from diverse sectors - publishing, banking, healthcare, and beyond • Face varied technical challenges and work across different data ecosystems and architectures • Contribute to meaningful projects in a culture built around trust, growth, and getting things done properly

Role Description 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. - 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. - Able to successfully pass a government clearance process as required by clients. Benefits - 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) - PTO Company Description 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.

• Desarrollo y mantenimiento de procesos ELT/ETL en entornos cloud • Diseño y optimización de modelos de datos en Snowflake • Desarrollo de transformaciones y lógica de negocio con dbt • Calidad del dato y buenas prácticas analíticas • Optimización de rendimiento y costes • Colaboración con equipos multidisciplinares • Documentación técnica y gobierno del dato • Control de versiones y despliegue de soluciones