Specializing in traveler path-to-purchase data for over a decade, Sojern is travel’s direct demand engine for thousands of brands—from global enterprises to boutique operators—across the hotel, airline, cruise, transportation, tourism industries and more.
From global enterprise brands to independent hotels, we work with companies around the world in air, hotel, car, cruise, and tourism to drive direct bookings. Sojern is headquartered in San Francisco with key offices in Dubai, Dublin, London, New York, Omaha and Singapore.
Design and build financial data warehouse for analytic and application purposes within BigQuery, Google’s Enterprise Cloud Data Warehouse.
Design and build application data integration and database schema.
Oversee creation of efficient ETL process and packages to fulfill financial data requirements to meet internal client and stakeholder needs
Collaborate across internal teams to deliver high quality analytics products and results, working within / between Tableau, Google BigQuery, Salesforce, Adaptive Planning and other best-in-class BI and data applications.
Provides troubleshooting and problem solving support for all financial data and financial data application purposes.
Advanced Data Analysis: Advanced SQL query capabilities. Experience in data modeling, data analysis and relational database design in addition to using advanced SQL.
Advanced Knowledge of Database Concepts: Use of data and other tools required to map and integrate data needed for reporting and application integration.
Analytical & Critical Thinking: Ability to analyze information, compare, contrast, trend data and draw conclusions. Using logic and reasoning to identify strengths and weaknesses of solutions.
Familiarity with standard financial and operational business concepts, basic understanding of online media industry a plus.
Results Orientation: Focuses self and others on achieving desired outcomes in a responsive timely manner. Strong attention to detail and accuracy.
Leadership: Self-driven. Willingness to lead, take charge, offer opinions and direction. Escalates appropriately in a timely manner.
Communication Excellence: Ability to interact with all levels of the organization. Listens openly, understands need behind the need and clearly conveys messages and information.
Resilience: Effectively manages stress in a fast-paced setting.
Team Work: Works effectively with others to accomplish objectives and goals. Interfaces with internal and external business units to understand workflows, data collection and reporting goals.
A minimum of seven years in BI or Data Engineering.
Bachelor's Degree in Engineering, IT, Finance, Statistics, Math, or related field.
Culture: Our team loves a good time
Snacks: Well-stocked kitchen to fill your breakfast, lunch, and snack needs
Opportunities: Be part of a growing team with training and support to help you grow
Give Back: We give 40 hours a year to volunteer and organize office volunteer programs with local organizations
Ownership: Lead creative and challenging projects
Meals: Monthly catered lunches & happy hours
Wealth: Stock options
Time Off: Flexible vacation days