What are the responsibilities and job description for the Lead ETL Engineer position at Celonis?
Are you ready for a new challenge?
The time is now to start your next career step at Celonis, one of the fastest growing global tech companies worldwide.
Celonis is the leader in business transformation software - the Execution Management Systems (EMS) lifts barriers to execution capacity to maximize business performance. Powered by its market-leading process mining core, the Celonis EMS helps companies manage every facet of execution management from analytics, to strategy and planning, management, actions and automations. For Global 2000 companies, transforming to an intelligent enterprise has become a key strategic priority. Celonis disrupted what had previously been a manual, time-consuming and expensive consulting-driven approach to jump-start and operationalize change in transformation initiatives. Celonis has thousands of global customers including ABB, AstraZeneca, Bosch, Coca Cola, Citibank, Dell, GSK, John Deere, L’Oreal, Siemens, Uber, Vodafone, and Whirlpool. Particularly in these uncertain times Celonis plays an impactful role in helping customers to use their execution capacity the best way possible.
Celonis is headquartered in Munich, Germany and New York, US, and has in total 15 offices worldwide. The company has grown 5,000% in 4 years and 300% in the past year. Celonis now counts as a Decacorn, having raised $1 billion in our most recent funding round in June 2021, valuing the company at more than $11 billion. Since opening its US headquarter in New York in September 2016 it has quickly added blue chip customers like Lockheed Martin, ExxonMobil, Honeywell, and Mars to its client roster. The US is the fastest growing region for Celonis and will soon exceed 50% of its total revenue, and therefore expanding US offices in New York, San Francisco, Raleigh, as well as Toronto, Canada, and Latin America.
We are looking for a visionary Lead ETL Engineer with a passion to design, create, and maintain complex data pipelines at scale. You have a drive to write clear, understandable and testable SQL statements with continuous focus on maintainability and performance. You should be able to easily assess dependencies and troubleshoot inefficiencies within a complex system and be able to recommend tangible remediation steps. You will act as a player-coach by collecting, documenting, and ultimately imparting best practices to our field teams.
You:
… have a Bachelor's / Master’s degree in Computer Science, Mathematics, Engineering, Business Informatics, or a related field
… have at least 8 years of professional experience in writing and maintaining performant, complex SQL queries
… have a strong knowledge in ETL methods and working with databases
… have experience with data architecture, data modeling, schema design, and development
… have a good understanding of at least one coding language (e.g., Java, Python, Scala, etc)
… have knowledge in business intelligence, infrastructure, data engineering, data analytics, or a related subject
… have excellent communication skills with the ability to convey complex, technical information in an understandable manner
… have the ability to logically troubleshoot issues, determine root causes, and present suggested solutions clearly and concisely
… have the ability to handle competing - oftentimes sudden - priorities flexibly and address each in an effective and timely manner in a fast-paced working environment
...a natural curiosity for technical topics and willingness to self-start and self-educate
We:
... see people as the fundamental pillar of our success. Therefore, we invest into the personal growth and skill development of each individual alongside with the strength finder test
… offer attractive compensation models (best-in-class salary, stock option packages, employee referral bonus, family service, flexible working hours, …)
... are visionary and one of the fastest growing Software-Unicorns in the world
… are experts in the field of Process Mining - the new Celonis Execution Management System provides a set of instruments and applications: the EMS offerings help companies manage every facet of execution management from analytics, to strategy and planning, management, actions and automations
... distinguish ourselves through a unique combination of innovative start-up atmosphere paired with great professionalism and self-responsible work
Celonis is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Different makes us better.
Have a look at our full Diversity statement here.