Senior Data Warehouse Engineer | ETL & Power BI Expert
Posted Updated
Description
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.
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. 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. Global Exposure Annual Bonus In-House Lunch Health Insurance Learning Opportunities Work-Life Balance Inclusive EnvironmentSkills
Sign in to read and join the discussion.