Data Engineer - II

Pakistan Single Window (PSW); Karachi Division; On-site; PKR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Competitive salary

Fuel Card

Health benefits

Professional development opportunities

Inclusive work culture

Job summary

Pakistan Single Window (PSW) is seeking a data engineer to develop and implement ELT data pipelines using ODI, design scalable data models, and collaborate with stakeholders to meet data requirements. You will analyze data, build visualizations, and ensure data quality and security across systems.

The role also involves data integration across applications, troubleshooting pipeline issues, and staying current with new data technologies to drive business insights.

Qualifications

• Bachelor's degree in Computer Science or related field preferred.
• 1–2 years of experience in ETL/ELT; ODI experience preferred.
• Strong SQL queries and data modelling concepts are mandatory.
• Good analytical and problem-solving skills with effective communication.

Responsibilities

• Develop and implement ELT data pipelines using Oracle Data Integrator to extract, transform, and integrate data from multiple systems.
• Design and develop efficient, scalable data models to meet business needs.
• Partner with stakeholders to understand data requirements and deliver solutions addressing data quality and security needs.
• Conduct data analysis and develop data visualizations to support business insights.
• Integrate data across applications and troubleshoot data pipeline issues.
• Stay current on emerging data technologies and evaluate their application to business problems.

Skills

SQL queries

Data modelling

Analytical thinking

Problem solving

Communication

Stakeholder collaboration

Education

Bachelor's degree in Computer Science (preferred)

Tools

Oracle Data Integrator

Job description

• Develop and implement ELT data pipelines using Oracle Data Integrator to extract, transform, and integrate data from multiple systems
• Design and develop efficient, scalable data models to meet business needs
• Partner with stakeholders to understand data requirements and deliver solutions addressing data quality and security needs
• Conduct data analysis and develop data visualizations to support business insights
• Integrate data across applications and troubleshoot data pipeline issues
• Stay current on emerging data technologies and evaluate their application to business problems

• Develop and implement ELT data pipelines using Oracle Data Integrator to extract, transform, and integrate data from multiple systems
• Design and develop efficient, scalable data models to meet business needs
• Partner with stakeholders to understand data requirements and deliver solutions addressing data quality and security needs
• Conduct data analysis and develop data visualizations to support business insights
• Integrate data across applications and troubleshoot data pipeline issues
• Maintain clear, up-to-date data documentation
• Stay current on emerging data technologies and evaluate their application to business problems

Requirements

• Bachelor's degree in Computer Science or a related field (preferred)
• Minimum 1-2 years of experience in the relevant field
• Proven experience in ETL/ELT; Oracle Data Integrator (ODI) preferred
• Strong analytical thinking and problem-solving capabilities
• Effective communication and interpersonal skills
• Strong SQL queries and data modelling concepts (mandatory)

Benefits

• Competitive salary
• Fuel Card
• Health benefits
• Professional development opportunities
• Inclusive work culture & much more