Data Analytics Engineer

Direct Travel•Remote,

2h•Remote

About The Position

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.

Requirements

Bachelor’s degree in information technology, Computer Science, Data Science, or a related field or equivalent experience.
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.
Experience with a cloud providers such as Amazon AWS, Azure or GCP and associated data platforms and products they provide.
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.
Strong verbal and written communication skills to effectively share findings with stakeholders.
Adept at queries, report writing, and presenting findings.
Minimum 5 years of experience in business intelligence and/or data warehousing
Minimum 10 years of IT\Technical experience
Ability to work with executives
Ability to explain complex situations in a way anyone can understand
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
Requirement analysis
Requirement documentation
Report design
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
Advanced SSAS cube design and implementation
MDX
Basic functional understanding of travel, and finance\accounting

Nice To Haves

Proven working experience as a data analytics engineer.
Snowflake, Looker and LookML modeling experience.

Responsibilities

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