Data Analytics Engineer

Direct travel is on a journey of data transformation, and we are seeking a skilled and motivated Data Analytics Engineer to join our team to be a pivotal part of our history.

The ideal candidate will be crucial to the design, execution and delivery of a best-in-class global analytics platform, providing data insights and global reporting for both internal stakeholders and thousands of clients globally.

A successful candidate will have hands on experience crafting embedded analytics applications, possess a background in software engineering and understand the latest methods and techniques in provisioning key visualizations and self-service capabilities within our data products.

In the role of an Analytics Engineer, a qualified candidate will work across engineering and data related assignments, contributing to the development of analytics products and using a data-driven mindset to solve business problems across the organization.

• →Data Management: Data collection and processing across various raw and unimproved data marts.
• →Reporting & Visualization: Develop and implement key visualizations, reports, modeling and performance improving optimizations to our core data products.
• →Collaboration: Work closely with IT and business units to understand data requirements and provide actionable insights and solutions to data problems.
• →Process Improvement: Identify, analyze, and interpret trends or patterns in complex IT data sets to drive process improvements and policy development.​
• →Analytics & Insights: Provide key and differentiating industry insights for our customers through clear and concise analytical representations of core travel data.

• Educational Background: Bachelor’s degree in information technology, Computer Science, Data Science, or a related field or equivalent experience.
• Technical Proficiency:
• Advanced knowledge of and experience with databases of all varieties including RDBMS SQL based platforms as well as document stores.
• Demonstrable experience with a programming language typically used in the field of data and analytics engineering e.g. Python, R or Scala.
• Experience and understanding of web application development, front-end reactive applications such as VueJS or React as well as familiarity with middle and back-end software development methodologies.
• Understanding of the software development lifecycle and SCM through Git or an alternative.
• Cloud proficiency:
• Experience with a cloud providers such as Amazon AWS, Azure or GCP and associated data platforms and products they provide.
• Analytics:
• Full understanding of the data lifecycle, from pipeline development to warehouse architecture to reporting and analytics enablement.
• Senior level experience with more than one cloud-based analytics platform such as Looker, Tableau or PowerBI.
• Experience developing semantic models across wide-reaching data in sustainable and performant ways.
• Exposure and understanding to cloud-based warehouse platforms such as Snowflake, DataBricks or Azure DataLake.
• Prior experience implementing governance and compliance related frameworks to analytics data products.
• Inquisitive diagnostic skills related to query and system tuning and performance.
• Experience building bespoke data products from the ground up that utilize analytics and business intelligence platforms in an integration manner for visuals and core functionality.
• Communication Skills: Strong verbal and written communication skills to effectively share findings with stakeholders.
• Attention to Detail: Adept at queries, report writing, and presenting findings.​

• Experience: Proven working experience as a data analytics engineer.
• Platforms: Snowflake, Looker and LookML modeling experience.

Direct Travel/ATPI is one of the fastest growing Travel Management Companies (TMC) in the world. By leveraging both the expertise of its people and innovative technology solutions, Direct Travel/ATPI enables clients to derive the greatest value from their travel program in terms of superior service, progressive technologies, and significant cost savings. Direct Travel/ATPI has offices globally and is currently ranked among the top providers on Travel Weekly’s Power List. For more information, visit https://www.dt.com/about-us/careers/

Direct Travel/ATPI is an EOE/AA/Veteran/People with Disabilities employer

#LI-Remote

• Minimum 5 years of experience in business intelligence and\or data warehousing
• Minimum 10 years of IT\Technical experience
• Communication skills
  • Ability to work with executives
  • Ability to explain complex situations in a way anyone can understand
• Technical skills
  • Detailed understanding of DW concepts
  • Dimensional data modeling
  • Logical data mart (DM) design
  • Advanced SSAS tabular design and implementation
  • SSAS performance tuning
  • Advanced Power BI model design and implementation
  • Advanced Power BI visualization skills
  • Advanced Power Query
  • Basic M language
  • Advanced DAX
  • Advanced SQL query skills
  • T-SQL Development including stored procedures, udfs, views, and tables.
  • Basic SQL performance tuning
  • Basic SQL trouble shooting
  • SSIS\Cloud Data Factory for moving data from data warehouse into data marts or BI semantic models as required
• Additional skills
  • Requirement analysis
  • Requirement documentation
  • Report design
• Lead skills
  • Leadership
  • Basic project management skills including resource & task scheduling.
  • Mentorship\Training
• Must be able to lawfully work within the US\Canada and have unrestricted work authorization for US\Canada. Degree in business, computer science, or engineering or a related discipline
• Minimum 1 year of experience in lead\management role
• Technical skills
  • Advanced SSAS cube design and implementation
  • MDX
• Basic functional understanding of travel, and finance\accounting
• This is not necessarily an exhaustive list of responsibilities, skills, duties, requirements, or efforts associated with the position.