Data Analytics Engineer

Your Expedition (Position Overview)

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.

Going the Extra Mile (Responsibilities)

• 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.

Your Passport to Success (Qualifications)

• 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.​

Preferred Qualifications

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

Your Benefits Onboard

In addition to Medical, Dental, and Vision benefits Direct Travel/ATPI offers a Total Rewards Package which includes Retirement Plans, Wellness, Rewards and Recognition, Sustainability, DE&I initiatives, and Mental Health Support.

Embark on the next step in your career journey with Direct Travel!

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

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/ATPI.

#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.