Senior Data Warehouse Engineer | ETL & Power BI Expert

SENSYS Inc.

Pakistan

On-site

PKR 1,800,000 - 2,400,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Global Exposure

Annual Bonus

In-House Lunch

Health Insurance

Learning Opportunities

Work-Life Balance

Inclusive Environment

Job summary

INTECH Automation Intelligence in Pakistan is seeking a Data Warehouse Engineer to design, develop, and optimize enterprise data warehouse solutions across ERP and OT systems. You will build robust ETL/ELT pipelines, craft high-performance SQL queries, and enable analytics with Power BI.

You will collaborate with BI developers, analysts, and business stakeholders to deliver scalable data models and reliable reporting.

Qualifications

5–10 years of experience in Data Warehousing or Data Engineering.
Advanced proficiency in SQL with hands-on experience on SQL Server, PostgreSQL, or Oracle.
Experience designing and implementing enterprise-grade ETL/ELT pipelines.
Experience with industrial data sources (SCADA, historians) is a plus.
Strong dimensional modeling knowledge (Star/Snowflake schemas).
Power BI data modeling, Power Query, and DAX experience.
SSIS/SSRS or modern cloud BI tools familiarity.
Bachelor's degree in a computing-related field.

Responsibilities

Design, develop, and optimize enterprise SQL-based data warehouse solutions.
Build and maintain ETL/ELT pipelines ingesting data from multiple sources.
Develop high-performance SQL queries, procedures, functions, and triggers.
Enable Power BI reporting with clean, structured datasets.
Collaborate with BI developers, analysts, and stakeholders to translate requirements.
Document data models, ETL processes, and data flows.
Monitor, troubleshoot, and optimize pipelines and DB performance.