CrawlJobs Logo

Lead ETL Developer

optimove.com Logo

Optimove

Location Icon

Location:
United States , New York

Category Icon

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided

Job Description:

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.

Job Responsibility:

  • 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

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
  • 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

Additional Information:

Job Posted:
January 05, 2026

Job Link Share:

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Lead ETL Developer

Senior Ab Initio Lead Developer

The Applications Development Technology Lead Analyst is a senior level position ...
Location
Location
United Kingdom , London
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • ETL Ab Initio experience, create generic components, batch and continuous flows, Testing framework, Express IT and API integration
  • Oracle PL/SQL experience
  • Experience with CI/CD practices for Ab Initio workflows is a plus. Familiarity with integrating Ab Initio jobs into automated pipelines using version control, testing, and deployment tools is desirable
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
  • Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies etc
What we offer
What we offer
  • Equal opportunity policies
  • Accessibility accommodation for candidates with disabilities
  • Fulltime
Read More
Arrow Right

Applications Development Technology Lead Analyst

The Applications Development Technology Lead Analyst is a senior level position ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 10 - 14 years of relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • 10+ years of ETL Ab Initio experience, create generic components, batch and continuous flows, Testing framework, Express IT and API integration
  • 8+ years of Oracle PL/SQL experience
  • Experience with CI/CD practices for Ab Initio workflows is a plus
  • Familiarity with integrating Ab Initio jobs into automated pipelines using version control, testing, and deployment tools is desirable
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
  • Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies etc.
  • Fulltime
Read More
Arrow Right

Applications Development Technology Lead Analyst

The Applications Development Technology Lead Analyst is a senior level position ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 10 - 14 years of relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • 10+ years of ETL Ab Initio experience, create generic components, batch and continuous flows, Testing framework, Express IT and API integration
  • 8+ years of Oracle PL/SQL experience
  • Experience with CI/CD practices for Ab Initio workflows is a plus
  • Familiarity with integrating Ab Initio jobs into automated pipelines using version control, testing, and deployment tools is desirable
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals
  • Identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made
  • Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies
  • Fulltime
Read More
Arrow Right

Ab Initio Applications Development Lead

An Ab Initio Application Development Lead is a senior technical role responsible...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 10+ Years of application development experience
  • Minimum 8 Years into Ab initio Development
  • Strong experience into requirement gathering, application design
  • Should be strong at stakeholder management
  • Prior experience of managing 5-6 team members
  • Experience in systems analysis and programming of software applications
  • Experience in managing and implementing successful projects
  • Working knowledge of consulting/project management techniques/methods
  • Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
Job Responsibility
Job Responsibility
  • Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development
  • Monitor and control all phases of development process and analysis, design, construction, testing, and implementation
  • Provide user and operational support on applications to business users
  • Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues
  • Recommend and develop security measures in post implementation analysis of business usage
  • Consult with users/clients and other technology groups on issues, recommend advanced programming solutions
  • Ensure essential procedures are followed and help define operating standards and processes
  • Serve as advisor or coach to new or lower level analysts
  • Operate with a limited level of direct supervision
  • Exercise independence of judgement and autonomy
  • Fulltime
Read More
Arrow Right

Applications Development Technology Lead Analyst

The Applications Development Technology Lead Analyst is a senior level position ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 10 - 14 years of relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • 10+ years of ETL Ab Initio experience, create generic components, batch and continuous flows, Testing framework, Express IT and API integration
  • 8+ years of Oracle PL/SQL experience
  • Experience with CI/CD practices for Ab Initio workflows is a plus. Familiarity with integrating Ab Initio jobs into automated pipelines using version control, testing, and deployment tools is desirable
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
  • Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies etc.
  • Fulltime
Read More
Arrow Right

Senior Data Engineer ETL Lead

The Sr Data Engineer ETL Lead is a senior level position responsible for establi...
Location
Location
United States , Irving
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication
  • Bachelor’s degree in Computer Science or equivalent /University degree or equivalent experience
  • Data Warehouse/ETL design and development methodologies knowledge and experience required
  • ETL expertise on AbInitio tool (EME, GDE, Co-op) bringing together all components like Unix, Oracle, Storage
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
What we offer
What we offer
  • Medical, dental & vision coverage
  • 401(k)
  • life, accident, and disability insurance
  • wellness programs
  • paid time off packages including vacation, sick leave and paid holidays
  • Fulltime
Read More
Arrow Right

Sr. ETL Developers

We are looking for talented individuals to become part of our growing business a...
Location
Location
United States , Scottsdale; Naperville
Salary
Salary:
Not provided
thinkartha.com Logo
Artha Solutions
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 6 years of experience in IT Industry
  • At least 6 years of technical experience with databases or data warehousing
  • Experience in Oracle DB, SQL Server, Mysql, No SQL such as Mongo DB with strong skills on SQL and PL/SQL and Java
  • BS/BA in Computer Science or related discipline required
  • Candidates with Talend certifications & experience will be given a strong preference
  • Strong understanding of relational database concepts & technology – data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture
  • Experience with setup, configuration, design best practices, performance optimization, team based development approaches with a leading Talend/BI tool
  • Well organized and able to manage multiple projects in a fast paced demanding environment
  • Attention to detail and quality
  • excellent problem solving and communication skills
Read More
Arrow Right

ETL Developer

We are looking for talented individuals to become part of our growing business a...
Location
Location
United States , Scottsdale; Naperville
Salary
Salary:
Not provided
thinkartha.com Logo
Artha Solutions
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Overall years of experience: Varies based on the role. A minimum experience of 3 years
  • At least 3 years of technical experience with databases, data warehousing, and BI tools
  • BS/BA in Computer Science or related discipline required
  • Experience with reporting and analytics tools is an advantage
  • Experience in Oracle DB, SQL Server, Mysql, No SQL such as Mongo DB with strong skills on SQL and PL/SQL and Java
  • Candidates with Talend certifications & experience will be given a strong preference
  • Strong understanding of relational database concepts & technology – data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture
  • Experience with setup, configuration, design best practices, performance optimization, team-based development approaches with a leading Talend/BI tool
  • Well organized and able to manage multiple projects in a fast paced demanding environment
  • Attention to detail and quality
Read More
Arrow Right