Data Engineer

TenX; Lahore; On-site; PKR 900,000 - 1,500,000; Full time

Job summary

TenX in Lahore, Pakistan is seeking a Data Engineer to design and build the data warehouse, ETL processes, and BI data models. You will turn business requirements into scalable data pipelines and reports, ensuring data quality and timely availability for analytics.

The role focuses on data modeling, ETL scripting, and collaboration with analysts to translate business needs into concrete data solutions, using tools like Talend, Informatica, and Hadoop ecosystems.

Qualifications

• Bachelor's degree in CS/BIT/BBIT or related field; master’s preferred.
• 1-2 years of experience in data engineering or related field with exposure to Big Data methodologies.
• Strong knowledge of RDBMS and SQL.
• Familiarity with ETL tools like Talend, Informatica, SSIS, or IBM Infosphere Datastage.
• Experience with Big Data technologies such as Hadoop, Cloudera, Talend for Big Data preferred.

Responsibilities

• Participates in developing the Data Models and Data Marts from various source systems.
• Develops and maintains ETL scripts to load data into Staging Area, Data Warehouse, and Data Marts.
• Identifies opportunities to use objects and code to reduce development effort and enforce data rules.
• Identifies opportunities for analysis and reporting solutions within the company.
• Participates in evaluation and selection of Data Modeling, BI and DW tools.

Skills

RDBMS

SQL

ETL

Big Data

Education

Bachelor's degree in CS/BIT/BBIT

Master's degree preferred

Tools

Talend

Informatica

SSIS

IBM Infosphere Datastage

Hadoop

Cloudera

Job description

Job Description:

JOB SUMMARY:

Data Engineers are responsible for designing and creating the data warehouse and all related extraction, transformation, and load of data functions. He should be able to analyze and digest what a business wants to accomplish with its data and design the best possible ETL/BI process around those goals.

DESCRIPTION:

Data Warehouse /ETL

• Participates in developing the Data Models and Data Marts that comes from various source systems.
• Using the data flow design, develops and maintains the ETL scripts that acquire data from various source systems to load information into the Staging Area, the Data Warehouse and Data Marts.
• Identifies and develops opportunities to utilize objects and code where appropriate to reduce development effort and enforce consistent business rules.
• Identifies opportunities for analysis and reporting solutions within the company.
• Participates in evaluation and selection of Data Modeling, BI and DW tools.

Business Intelligence

• Translates business requirements into technical Data Models and Data Marts.
• Understands key business drivers.
• Contributes to the overall development of the BI initiative within the company.
• Provides input and feedback to the vision of the overall BI Strategy.
• Communicates BI strategy and concepts to other business users.

Reporting & Drafting

• Clearly documents all development to company standards.
• Works in a small team environment and supports team members where needed.
• Assists in establishing new standards and processes for BI data modeling.
• Clearly communicates task status, progress and problems to project lead.

Requirements:

• Minimum bachelor’s degree in computer science, BIT, BBIT, or a related field, master’s degree will be preferred.
• 1-2 years of experience in data engineering or a related field with additional exposure to Big Data methodologies.
• Strong knowledge of RDBMS and SQL.
• Familiarity with ETL tools like Talend, Informatica, SSIS, or IBM Infosphere Datastage.
• Candidate with experience in Big Data technologies such as Hadoop, Cloudera, Talend for Big Data will be preferred