ETL Developer

Comrise; Philippines; On-site; PHP 800,000 - 1,200,000; Full time

Job summary

Comrise is seeking a data engineer to design, build, and maintain scalable data pipelines and data warehouses in a fast-paced environment. You will optimize ETL/ELT processes, integrate data from APIs, cloud storage, and databases, and ensure data accuracy and availability for analytics teams.

The role requires 2–4 years of SSIS experience, SQL Server development, and strong collaboration with the data team to deliver reliable data solutions.

Qualifications

• 2-4 years of experience with ETL tools, specifically Microsoft SSIS.
• Design and develop SQL Server database components and ETL solutions using SSIS.

Responsibilities

• Design, build, and maintain scalable data pipelines from multiple sources.
• Maintain databases, data warehouses, and data lakes ensuring integrity.
• Implement ETL/ELT processes to automate collection, cleaning, and transformation.
• Integrate data from internal and external sources including APIs and cloud storage.
• Optimize data architectures for performance, scalability, and cost efficiency.
• Collaborate with the data team to deliver clean, accessible data solutions.
• Implement data validation and monitoring to ensure accuracy and integrity.

Skills

Data pipelines

Data integration

ETL/ELT

Tools

SSIS

SQL Server

Job description

• Design, build, and maintain scalable data pipelines that support data collection, transformation, and integration from various sources.
• Maintain databases, data warehouses, data lake ensuring data integrity, scalability, and reliability.
• Implement efficient ETL/ELT (Extract, Transform, Load) processes to automate data collection, cleaning, and transformation tasks.
• Integrate data from various internal and external sources, including APIs, cloud storage, third-party systems, and databases.
• Optimize data architectures for performance, scalability, and cost efficiency. Ensure fast and reliable data retrieval.
• Work closely with the data team to understand data needs and deliver reliable, clean, and accessible data solutions.
• Implement data validation and monitoring processes to ensure data accuracy and integrity. Identify and troubleshoot data issues and bottlenecks.

Qualifications

• At least 2-4 years' of experience in ETL tools such as Microsoft SSIS.
• Has experience in design and develop SQL Server database components and ETL solutions using SSIS, ensuring accurate data movement and efficient processing