ETL Development Lead

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

Job summary

ADEC Innovations in Metro Manila is seeking an experienced Development Lead to drive the design, development, and maintenance of ETL/ELT solutions and data pipelines. You will provide technical direction to the ETL Developers and collaborate with Data Operations, Analysts, DBAs, and GIS developers to ensure secure, scalable data processing.

The role requires strong knowledge of ETL concepts, data integration, and pipeline design, with at least 5 years in ETL or related roles and 2 years in a

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

Responsibilities

• Lead the design, development, implementation, and maintenance of ETL solutions, data pipelines, transformation processes, and related data-processing tools.
• Review and approve data mappings, transformation rules, technical designs, and implementation approaches.
• Perform hands-on development, troubleshooting, and optimization for complex, critical, or high-priority ETL requirements when necessary.
• Manage the ETL Development team, including work assignment, delivery monitoring, coaching, performance management, and capability development.
• Provide technical direction and ensure adherence to established development, documentation, security, data management, and compliance standards.
• Promote code reviews, technical walkthroughs, knowledge sharing, cross-training, mentoring, and continuous improvement within the team.
• Collaborate with Data Operations, Data Analysts, Software Delivery, and other stakeholders to analyze data-processing requirements and translate them into appropriate technical solutions.
• Assess scope, dependencies, risks, effort, and resource requirements to support the planning and prioritization of ETL development activities.
• Ensure ETL solutions are properly reviewed, tested, demonstrated, approved, documented, deployed, and transitioned to users and operational support teams, including training or knowledge transfer.
• Ensure ETL solutions and deliverables meet established quality, security, reliability, documentation, and software development standards.
• Ensure processing issues and defects are investigated through root-cause analysis, appropriately resolved, and used to identify opportunities for continual improvement.
• 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.

Skills

ETL/ELT concepts

Data integration

Data transformation

Data mapping

Pipeline design

SQL development

Python/Java/.NET

Education

Bachelor's degree in IT, CS, IS, Software Engineering, Data Engineering or related field

Tools

Microsoft SQL Server

PostgreSQL

MySQL

Oracle

Job description

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

• 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.
• Review and approve data mappings, transformation rules, technical designs, and implementation approaches.
• Perform hands-on development, troubleshooting, and optimization for complex, critical, or high-priority ETL requirements when necessary.

Team Leadership and Development

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

Requirements and Delivery Management

• Collaborate with Data Operations, Data Analysts, Software Delivery, and other stakeholders to analyze data-processing requirements and translate them into appropriate technical solutions.
• Assess scope, dependencies, risks, effort, and resource requirements to support the planning and prioritization of ETL development activities.
• 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

• Ensure ETL solutions and deliverables meet established quality, security, reliability, documentation, and software development standards.
• Ensure processing issues and defects are investigated through root-cause analysis, appropriately resolved, and used to identify opportunities for continual improvement.
• 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/