Lead ETL Developer

Optimove•New York, NY

13d

About The Position

Optimove is a global marketing tech company, recognized as a Leader by Forrester and a Challenger by Gartner. We work with some of the world's most exciting brands, such as Sephora, Staples, and Entain, who love our thought-provoking combination of art and science. With a strong product, a proven business, and the DNA of a vibrant, fast-growing startup, we're on the cusp of our next growth spurt. It's the perfect time to join our team of ~500 thinkers and doers across NYC, LDN, TLV, and other locations, where 2 of every 3 managers were promoted from within. Growing your career with Optimove is basically guaranteed. As the ETL Team Lead, you will play a key leadership role in our dynamic, fast-growing global team, leading the development and execution of data transformation processes. You will oversee a team of talented ETL Developers and collaborate closely with internal Data Engineers, Project Managers, Customer Success teams, and clients' data teams across various business verticals. This position requires a blend of technical expertise and strong leadership capabilities to ensure the smooth execution of ETL projects and the alignment of our data solutions with client needs. You will be responsible for guiding the design, implementation, and optimization of ETL and client onboarding processes while ensuring that the team adheres to best practices and high-quality standards. This role provides an excellent opportunity to leverage your technical experience while growing as a leader in a cutting-edge technology environment.

Requirements

Bachelor's degree in Information Systems, Data Engineering, Mathematics, Statistics, Computer Science, Industrial Engineering, or a related field
Experience leading teams or acting as a senior contributor with mentorship responsibilities; prior formal team leadership is an advantage but not required.
Strong background in ETL development, with a deep understanding of data transformations, data pipelines, and data quality management.
Advanced expertise in SQL and relational databases.
Strong proficiency in Python and experience with automation and ETL tools (e.g., Airflow, Matillion).
Familiarity with cloud platforms (e.g., GCP, AWS, Azure,) and modern data warehouses (e.g., Snowflake).
Proven ability to lead or mentor others, influence technical direction, and collaborate effectively across teams with excellent interpersonal and communication skills.
Experience working with cross-functional teams in a client-facing environment.
Strong problem-solving abilities, with a creative and analytical approach to overcoming challenges.
High attention to details, with a proven ability to prioritize and manage multiple projects simultaneously while consistently meeting deadlines.
Ability to work in a fast-paced, dynamic environment and adapt to changing priorities.

Responsibilities

Lead, mentor, and manage a team of ETL Developers, providing technical guidance, training, and career development.
Foster a collaborative and high-performance team culture, ensuring efficient and effective project delivery.
Conduct regular code reviews, provide constructive feedback, and ensure adherence to coding standards and best practices.
Serve as the main point of contact for project scoping, planning, and execution, working closely with clients, internal stakeholders, and other teams.
Define project timelines, manage resources, and ensure the delivery of data transformation solutions within set deadlines and quality expectations.
Oversee the troubleshooting of data mismatches and provide solutions to ensure project deliverables meet client requirements.
Lead the design and implementation of robust and scalable ETL and onboarding processes, ensuring the integration of diverse data sources and application of data quality measures.
Ensure that ETL pipelines are optimized for performance, scalability, and reliability.
Continuously monitor, analyze, and improve ETL processes and methodologies to support business growth and evolving client needs.
Act as a liaison between technical teams and non-technical stakeholders, clearly communicating project status, risks, and solutions.
Engage with clients to understand their data needs and provide strategic guidance on data transformations, migrations, and analytics.
Identify opportunities for process optimization, automation, and technology enhancements to improve the overall ETL workflow.
Stay up to date with industry trends and emerging technologies, integrating them into team processes and toolsets.