BI Developer

Sojern

About Us:

Want to join a company on the cutting edge of technology and travel? Want to be part of a fantastic and fun company thats revolutionizing the online travel advertising space?

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. Analyzing the world’s travel intent signals with its proprietary data science methods, the company delivered $10B in generated bookings for its clients to date by activating multi-channel branding and performance solutions on the Sojern Traveler Platform.

Recognized on the Top Company Cultures list by Entrepreneur Magazine, Sojern is headquartered in San Francisco, with teams based in Dubai, Dublin, Hong Kong, London, Mexico City, New York, Omaha, Paris, Singapore, and Sydney.

Responsibilities:

Design and build financial data warehouse for analytic and application purposes within BigQuery, Googles 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.

Requirements:

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.

Perks:

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

At Sojern, we value diversity and always treat all employees and job applicants based on merit, qualifications, competence, and talent. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

To apply for this job please visit the following URL: http://itjobpro.com/79014 →