Industrial Data Warehouse Engineer | ETL & Power BI

INTECH Process Automation; Pakistan; On-site; PKR 1,500,000 - 3,500,000; Full time

Benefits offered by this job

Global exposure

Competitive compensation

Annual bonus

In-house lunch

Job summary

INTECH Automation Intelligence in Pakistan seeks a Data Warehouse Consultant/Engineer to design scalable data warehouse solutions for enterprise reporting and analytics across industries including Oil & Gas, Petrochemicals, Utilities, and Manufacturing.

You will build ETL/ELT pipelines, optimize SQL-based models, and enable Power BI reporting while collaborating with BI developers and stakeholders. Travel may be required for customer engagements as needed.

Qualifications

• 5–10 years of experience in Data Warehousing or Data Engineering.
• Advanced SQL skills (T-SQL/PL-SQL) with relational databases.
• Proven experience designing enterprise ETL/ELT pipelines.
• Experience with industrial data sources (SCADA/ historians) is a plus.
• Strong dimensional modeling and data quality practices.
• Knowledge of Power BI data modeling and DAX is desirable.

Responsibilities

• Design, develop, and optimize enterprise SQL-based data warehouse solutions.
• Build and maintain robust ETL/ELT pipelines across environments.
• Develop high-performance SQL queries, stored procedures, and functions.
• Deliver datasets optimized for Power BI reporting and analytics.
• Collaborate with BI developers, analysts, and stakeholders to translate requirements.

Skills

SQL proficiency

ETL/ELT design

Power BI

Python

SCADA/OT data

Education

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

Tools

SQL Server

PostgreSQL

Oracle

SSIS/SSRS

Power BI

Job description

INTECH Automation Intelligence in Pakistan seeks a Data Warehouse Consultant/Engineer to design scalable data warehouse solutions for enterprise reporting and analytics across industries including Oil & Gas, Petrochemicals, Utilities, and Manufacturing.

You will build ETL/ELT pipelines, optimize SQL-based models, and enable Power BI reporting while collaborating with BI developers and stakeholders. Travel may be required for customer engagements as needed.