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 skillsAbility to work with executives Ability to explain complex situations in a way anyone can understand Technical skillsDetailed 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 skillsRequirement analysis Requirement documentation Report design Lead skillsLeadership 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.