ETL Development Lead

ADEC Innovations; Muntinlupa; On-site; PHP 1,800,000 - 2,400,000; Full time

Job summary

ADEC Innovations is seeking a Development Lead to drive the design, development, and maintenance of ETL/ELT solutions and data pipelines in the Philippines. This role guides a team of ETL developers, collaborating with Data Operations, Analysts, and DBAs to ensure scalable and secure data processing aligned with business needs.

The role emphasizes hands-on development when needed, setting technical direction, and enforcing standards for data management and compliance across projects.

Qualifications

• Lead ETL/ELT solution design and development.
• Review data mappings, transformation rules, and technical designs.
• Hands-on development, troubleshooting, and optimization for complex ETL requirements.

Responsibilities

• Manage the ETL Development team: assignment, delivery monitoring, coaching, performance management.
• Provide technical direction and ensure adherence to development, security, data management, and compliance standards.
• Promote code reviews, knowledge sharing, and continuous improvement within the team.
• Collaborate with Data Ops, Data Analysts, Software Delivery, and stakeholders to translate requirements into technical solutions.
• Ensure ETL solutions are reviewed, tested, documented, deployed, and transitioned to users and operations teams.

Skills

5+ years ETL development

2+ years in lead role

Data integration

Pipeline design

Cross-functional collaboration

Education

Bachelor's degree in information technology, Computer Science, Information Systems, Software Engineering, Data Engineering, or related field

Tools

Microsoft SQL Server

PostgreSQL

MySQL

Oracle

Python

.NET

Java

Shell scripting

Job description

Job Description:

Role/Position Summary:

Under the supervision of the Manager, the Development Lead is responsible for leading the design, development, implementation, maintenance, and continuous improvement of ETL/ELT solutions, data pipelines, and related data-processing tools.

The position manages and provides technical direction to ETL Developers and works closely with Data Operations, Data Analysts, Database Administrators, Software Delivery, GIS Developers and other stakeholders to ensure data-processing solutions are accurate, secure, scalable, maintainable, and aligned with operational, business, and technical requirements.

Duties & Responsibilities:

ETL Solution Design and Development

1. Lead the design, development, implementation, and maintenance of ETL solutions, data pipelines, transformation processes, and related data-processing tools. Creates wireframe, storyboard, prototype, or mock-up if and when necessary.
2. Review and approve data mappings, transformation rules, technical designs, and implementation approaches.
3. Perform hands-on development, troubleshooting, and optimization for complex, critical, or high-priority ETL requirements when necessary.

Team Leadership and Development

1. Manage the ETL Development team, including work assignment, delivery monitoring, coaching, performance management, and capability development.
2. Provide technical direction and ensure adherence to established development, documentation, security, data management, and compliance standards.
3. Promote code reviews, technical walkthroughs, knowledge sharing, cross-training, mentoring, and continuous improvement within the team.

Requirements and Delivery Management

1. Collaborate with Data Operations, Data Analysts, Software Delivery, and other stakeholders to analyze data-processing requirements and translate them into appropriate technical solutions.
2. Assess scope, dependencies, risks, effort, and resource requirements to support the planning and prioritization of ETL development activities.
3. Ensure ETL solutions are properly reviewed, tested, demonstrated, approved, documented, deployed, and transitioned to users and operational support teams, including appropriate training or knowledge transfer.

Quality, Governance and Compliance

1. Ensure ETL solutions and deliverables meet established quality, security, reliability, documentation, and software development standards.
2. Ensure processing issues and defects are investigated through root-cause analysis, appropriately resolved, and used to identify opportunities for continual improvement.
3. Ensure the team complies with applicable software development policies and procedures, and client-specific controls, including the use of prescribed workflow and document management systems.

Qualifications:

• Bachelor's degree in information technology, Computer Science, Information Systems, Software Engineering, Data Engineering, or another related field.
• At least 5 years of relevant experience in ETL development, data engineering, software development, or related technical roles.
• At least 2 years of experience in a technical lead, team lead, supervisory, or equivalent role.
• Experience supporting production data pipelines, data-processing operations, and cross-functional technology initiatives
• Strong knowledge of ETL/ELT concepts, data integration, data transformation, data mapping, and pipeline design
• Experience developing and supporting batch, scheduled, event-driven, and other data-processing solutions
• Strong knowledge of relational databases, SQL development, stored procedures, query optimization, and database design principles
• Experience with Microsoft SQL Server, PostgreSQL, MySQL, Oracle, or comparable database platforms
• Knowledge of at least one programming or scripting language used for data processing, such as Python, .NET, Java, or shell scripting

NOTICE:

As this website allows us to collect your information through your resumes, please read our Privacy Notice before proceeding: https://www.adec-innovations.com/privacy-statement/