Data Warehouse Engineer — Global Projects & Growth

SENSYS Inc.; Lahore; On-site; PKR 2,400,000 - 5,400,000; Full time

Benefits offered by this job

Global Exposure

Competitive Compensation

Annual Bonus

In-House Lunch

Health Insurance

Learning Opportunities

Work-Life Balance

Inclusive Environment

Job summary

INTECH Automation Intelligence in Lahore, Pakistan, is seeking a Data Warehouse Consultant/Engineer to design and deliver scalable SQL-based data warehouse solutions across oil & gas, petrochemicals, utilities and manufacturing.

You will build ETL/ELT pipelines, optimize queries, support Power BI reporting, and collaborate with BI developers and stakeholders. 5–10 years of DW/ETL experience, MS SQL Server, PostgreSQL/Oracle, SSIS/SSRS, and Python are preferred.

Qualifications

• 5–10 years of experience in Data Warehousing, Data Engineering, or related disciplines.
• Advanced proficiency in SQL, including T-SQL and/or PL-SQL, with hands-on experience with major relational DB platforms.
• Experience designing and implementing enterprise-grade ETL/ELT pipelines with multiple data sources.
• Strong understanding of dimensional modeling (Star/Snowflake) and DW architecture.

Responsibilities

• Design, develop, and optimize enterprise SQL-based data warehouse solutions from multiple sources.
• Build and maintain ETL/ELT pipelines for development, pre-production, and production environments.
• Develop high-performance SQL queries, stored procedures, and functions for large datasets.
• Enable Power BI reporting by delivering clean data models and transformations.
• Collaborate with BI analysts and stakeholders to translate requirements into scalable data models and integrations.

Skills

SQL

ETL/ELT

Power BI

Python

Data modeling

Problem solving

Stakeholder management

Education

Bachelor's degree in CS/IS/SE/Data Engineering

Tools

SSIS/SSRS

SQL Server

PostgreSQL

Oracle

Hadoop

Job description

INTECH Automation Intelligence in Lahore, Pakistan, is seeking a Data Warehouse Consultant/Engineer to design and deliver scalable SQL-based data warehouse solutions across oil & gas, petrochemicals, utilities and manufacturing.

You will build ETL/ELT pipelines, optimize queries, support Power BI reporting, and collaborate with BI developers and stakeholders. 5–10 years of DW/ETL experience, MS SQL Server, PostgreSQL/Oracle, SSIS/SSRS, and Python are preferred.