Data Warehouse Engineer
- Hybrid
- Berlin, Berlin, Germany
- Amsterdam, Noord-Holland, Netherlands
- Hamburg, Hamburg, Germany
+2 more- Corporate Reporting
Job description
Who We Are
Verve has created a more efficient and privacy-focused way to buy and monetize advertising. Verve is an ecosystem of demand and supply technologies fusing data, media, and technology together to deliver results and growth to both advertisers and publishers–no matter the screen or location, no matter who, what, or where a customer is. With 30 offices across the globe and with an eye on servicing forward-thinking advertising customers, Verve’s solutions are trusted by more than 90 of the United States’ top 100 advertisers, 4,000 publishers globally, and the world’s top demand-side platforms. Learn more at www.verve.com.
Who You Are
As a Data Warehouse Engineer, you will work for the whole Verve Ecosystem, collaborating with the Data teams of different departments. You will work with operational, business, financial, and other KPI data. The work will include analyzing business requirements and data sources, designing architecture and data models, developing and testing ETL processes, and implementing the data warehouse. Ensuring its performance, scalability, and reliability is also crucial. Additionally, you will monitor and troubleshoot the data warehouse, maintain and update it, and ensure data quality, integrity, and security in collaboration with other engineers, analysts, and stakeholders.
This position is available with a hybrid working model in our Berlin, Hamburg or Amsterdam offices (with office days on Tuesdays, Wednesdays, and Thursdays, with free lunches provided for on these days)!
What You Will Do
Design, build, implement, and maintain the data warehouse and self-service business intelligence reporting solutions
Maintain the current data warehouse and shape its evolution by adopting new technologies under the guidance of a mentor
Help to build the next-generation reporting data warehouse pipeline with robust and steady data flow with efficient costs
Provide technical expertise on Google Cloud Platforms Big Data technologies including BigQuery, Looker, Dataflow, Cloud Composer
Coordinate with business departments, analysts and systems engineering; lead automation, implement review code
Deliver high-quality results, meet timelines, and be agile
Make appropriate recommendations on the management of data extraction, and analysis
Job requirements
What You Will Bring
Bachelor’s degree in a technical or scientific discipline, or equivalent work experience
3+ years of SQL experience; having a foundation in writing and interpreting SQL queries is essential, with the expectation of crafting and handling more complex queries
3+ years of experience in Big-data platforms and ETL tools like BigQuery, Trino, GitHub, Airflow, Python
Strong knowledge and wide range of experience in Python development including Airflow development and in-depth knowledge of BigQuery or alternative cloud-based database
Advanced ETL expertise with a comprehensive understanding and hands-on experience in ETL processes
Proactive, autonomous go-getter who prioritizes tasks independently and takes ownership
Ability to work cross-departmentally
Good working level of English language
What We Offer
Join one of the top privacy-first omnichannel ad platforms and gaming companies
Be part of a multicultural team (55+ nationalities) that is bringing advertising to the next level
Benefit from working with some of the most experienced professionals in our industry and constantly grow with us
You will learn and evolve in an empowering environment characterized by entrepreneurial actions
Responsibility, independence, and an opportunity to participate in projects that have a significant impact on Verve’s success
3 Wellness days per year to help you maintain your well-being (in Q1, Q2, and Q3)
Enhance your professional skills with a yearly training budget and improve your language skills through German and/or English classes
Work and Travel Program (monthly raffle after 2 years of employment)
We are happy to build a great team together and we appreciate your help through our Employee Referral Bonus
Align your interests with the company's success and take part in our Employee Shares Purchase Plan
You will be entitled to 27 holidays per year in addition to any of the public/bank holidays
- Personalized Benefits Platform; with a budget of 100 EUR/month, you can choose the benefits that fit you best from the following options:
Internet allowance
Mobility allowance such as BVG/HVV tickets and car/bicycle rental
Kindergarten, daycare center subsidy
Sport membership and personal development
Shopping vouchers
Enjoy food and beverage benefits with colleagues and have fun during team events
Take advantage of our Employee offers and discounts
Corporate Pension Scheme
or
All done!
Your application has been successfully submitted!