Sr. Software Engineer, Data Warehouse
Engineering | San Francisco, CA | Full Time
Want to join a company on the cutting edge of technology and travel?
Sojern provides digital marketing solutions for the travel industry. Powered by artificial intelligence and traveler intent data, Sojern activates multi-channel marketing solutions to drive direct demand. More than 10,000 hotels, attractions, tourism boards and travel marketers rely on Sojern to engage and convert travelers around the world.
Sojern made Deloitte’s Technology Fast 500 list 6 years in a row, was recognized on the Top Company Cultures list by Entrepreneur Magazine and named a Best Place to Work by AdAge. The company is headquartered in San Francisco, with teams based in Dubai, Dublin, Hong Kong, London, Mexico City, Omaha, Paris, and Singapore.
Need more convincing that Sojern is a great place to work? Check out our Glassdoor reviews!
As a member of our data warehouse team, some of the things you’d work on day-to-day include:
Build and enhance Sojern’s data warehouse platform for internal and external analytics and reportings needs
Generate periodic performance reports utilizing an ETL (extract/transform/load) process using Python and SQL
We’re looking for a Software Engineer who can leverage their prior Ad Tech and engineering experience to take on and lead large projects, from inception to completion.
The Expertise We’re Looking For:
At least 4-6 years of software engineering experience.
Proficient in SQL: constructing tables, normalization/denormalization techniques, query optimization
Familiarity with columnar databases (e.g. Google BigQuery, Amazon RedShift)
Hands-on experience with Kubernetes.
Excellent grasp of CS fundamentals - data structures and algorithms.
Experience with Distributed Systems.
Experience with Google Cloud Platform or Amazon Web Services infrastructure
Nice to have - AdTech experience - display/RTB, SEM, FB campaign optimization.
The Value You Deliver:
Evangelizing new technologies and processes.
Actively participating in code/design reviews.
Working closely with the product, data science, and SRE teams to design, build, and deploy highly scalable and efficient core platform services that drive company-wide value and make an impact.
Be responsible for the delivery of data and information critical for Sojern’s business decisions and strategic planning.
Opportunities: Be part of a growing team with training and support to help you grow.
Ownership: Lead creative and challenging projects.
Give Back: We give 40 hours a year to volunteer and organize office volunteer programs with local organizations.
Culture: Strong core business values, focus on teamwork, vibrant, social and fun environment.
Snacks: Variety of snacks in the office.
Upside: Stock options.
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, gender orientation, sexual orientation, age, marital status, veteran status, or disability status.