Lead Software Engineer (Lead ETL PySpark Developer)

Clarivate; United States; Remote; USD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a Lead ETL Developer to join their innovative data team. This role offers a unique opportunity to work with cutting-edge big data technologies and lead the development of ETL pipelines. You will provide technical leadership, collaborate with teams to design a data lake platform, and ensure best practices in big data management. Join a global team of experts dedicated to delivering data solutions that empower clients and enhance product offerings. If you are passionate about technology and eager to make a significant impact, this position is perfect for you.

Qualifications

• 5+ years in building ETL pipelines with proficiency in PySpark.
• 2+ years experience with Python3, Databricks, and Apache Spark.

Responsibilities

• Provide technical leadership and evaluate technologies for data solutions.
• Collaborate to design and implement a data lake platform.

Skills

ETL pipelines

PySpark

Python3

Apache Spark

SQL

non-SQL database skills

big data management

Tools

AWS EC2

AWS ECS

AWS RDS

AWS S3

OpenSearch

Snowflake

Oracle

PostgreSQL

Docker

Job description

We are looking for a Lead ETL Developer to join our C3 Data team based in Bangalore. This role offers a unique opportunity to work on Clarivate Customer Cloud (C3) and make rich content available across the Clarivate platform to all customers. As the Lead ETL Developer, you will support the data team by loading new content to Clarivate Customer Cloud, and you will have the chance to work with modern, cutting-edge big data technologies. Our team has expertise in Python, PySpark, Spark, Databricks, ECS, AWS, and Airflow -- and we would love to speak with you if you have experience in Spark, Databricks, or PySpark.

About You – experience, education, skills, and accomplishments

• At least 5+ years of experience in building ETL pipelines and proficiency in PySpark.
• At least 2 years of proficiency in Python3 and experience with Databricks and Apache Spark.
• Strong SQL and non-SQL database skills.
• Passionate about code and software architecture.

It would be great if you also had

• AWS services: EC2, ECS, RDS, S3.
• OpenSearch, Snowflake.
• Oracle, PostgreSQL.
• Docker.

What will you be doing in this role?

• Providing technical leadership and guidance, evaluating various technologies to balance business needs and cost-effectiveness.
• Collaborating with business and IT teams to design and implement a data lake platform.
• Maintaining the overall solution architecture for the data lake platform.
• Establishing technical best practices for big data management and solutions, from technology selection to architecture and implementation.
• Ensuring all components of the data lake platform meet SLAs.
• Leading technical investigations, POCs, and hands-on coding to make technical recommendations.
• Mentoring and coaching team members to enhance their technical and professional skills.

About the Team

The C3 Data team consists of over 50 experts across the globe who work on Clarivate Customer Cloud to provide access to data for products, consulting-led engagements, or direct customer access.

Hours of Work

This is a permanent position in Bangalore (8 hours per day as per IST Time zone).

At Clarivate, we are committed to providing equal employment opportunities for all persons with respect to hiring, compensation, promotion, training, and other terms, conditions, and privileges of employment. We comply with applicable laws and regulations governing non-discrimination in all locations.