SmarterTravel, a TripAdvisor Company, offers travelers a portfolio of travel sites to help them find the right trip at the right price.  We are a team of passionate professionals who push and drive and innovate like a start-up, but we also have a track record of success and we benefit from being a part of a large, public company.

Come join SmarterTravel’s growing Business Intelligence team as a BI Engineer. You will be involved in all phases of data warehousing from planning to implementation to support.  We are a small team of 4 that move quickly, are proud of our very high level of service to all parts of the business, and are constantly looking to improve how we collect and provide data solutions to our customers.

SmarterTravel currently uses the full Microsoft SQL Server BI stack and is looking to add/use additional tools as required such as Hadoop, Hive, Kafka, Spark, Redshift, R, Graph DBs, etc.

This person will fill an essential role in the continued build out and refactoring of the existing Smarter Travel BI solutions. We are looking for someone with a solid foundation in both traditional SQL based data warehouse building as well as larger scale technologies such as Hadoop/Hive and who is not afraid to explore solutions that may be outside of our core SQL Server based tool set.

Essential Job Functions:

  • Work with internal and external clients to understand business requirements
  • Design, implement, and refactor Hive/Hadoop Data Lake solutions
  • Design, implement, and refactor data warehouse schemas across SQL Server and Hive/Hadoop platforms
  • Design, implement, and support ETL flows for the data warehouse across SQL Server and Hive/Hadoop platforms
  • Design, implement, and deliver reports based on business requirements using SSRS, PowerBI
  • Understand the data source systems and source data in detail and become a SME
  • QA any work done by self and other team members
  • Document all of the design and development artifacts
  • Troubleshoot and support all BI related production processing
  • Understand the current reporting environment and use that knowledge to continuously improve the enterprise data warehouse.

Skills:

  • 4+ years’ experience in the design, development, and testing of Data Warehouse implementations both traditional relational and Hadoop/Hive based solutions
  • 4+ years of experience with SQL and Relational Databases
  • 5+ years of overall software industry experience
  • Experience with MS SQL Server is a must; preferably 2012+
  • Extensive experience with writing SQL and Stored Procedures, query tuning etc.
  • Experience with Apache Hadoop/Hive integration, R, Spark, Kafka, Java, C#, working with 3rd party API’s (Facebook, Criteo, Google)
  • Deep knowledge of dimensional modeling and experience with it on at least 2 large projects in production
  • Experience with ETL tools such as SSIS
  • Experience with reporting tools such as SSRS, PowerBI, Excel
  • Ability to communicate and work with both technical and non-technical team members
  • Ability to work in a fast-paced and dynamic environment
  • Excellent interpersonal skills including verbal and written communication, teamwork, and issue resolution
  • A problem-solving mindset; this individual should be highly motivated and self-directed

Education:

  • BS or BA (or equivalent) in computer science or related discipline (EE, Math etc.)

At SmarterTravel, we have built an open & collaborative environment and we hire the people we want to work with (not just the ones with the right qualifications), but who also think different to us and challenge the status quo.  We empower people, giving the support and autonomy needed to succeed.  We embrace data to make decisions and overcome obstacles.  We choose speed over perfection, but not at the expense of quality.  We do what we do well, but we’re always looking to make it better.  Let us know if you’d like to help.

SmarterTravel is an equal opportunity employer and evaluates applicants regardless of an individual’s age, race, color, gender, religion, national origin, sexual orientation, disability, veteran status, or musical preferences. We think a diverse team builds a better product.

*** This employer participates in E-Verify. The employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee's I-9 to confirm work authorization. ***

*LI-TW1
Apply for this Job
* Required
(Optional)
Almost there! Review your information then click 'Submit Application' to apply.

File   X
File   X


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at TripAdvisor are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 1/31/2020

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities1. To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.


Share this job: