Data Warehouse Engineer

Intechww; Pakistan; On-site; PKR 1,800,000 - 3,000,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 is seeking a Data Warehouse Consultant/Engineer to design and deliver scalable data warehouse solutions powering enterprise reporting, analytics, and data-driven decision-making across industries such as Oil & Gas, Petrochemicals, Utilities, and Manufacturing.

You will collaborate with BI developers, analysts, and business stakeholders to translate reporting requirements into robust data models and ETL/ELT pipelines, while modernizing legacy reporting platforms and

Qualifications

• 5–10 years in Data Warehousing, Data Engineering, or related fields.
• Advanced SQL proficiency with SQL Server, PostgreSQL, or Oracle.
• Proven ETL/ELT design experience aggregating multiple data sources.
• Experience with industrial data sources (SCADA, historians) is a plus.
• Strong dimensional modeling and data quality practices.

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, procedures, and functions.
• Enable data warehouse for Power BI reporting with clean data models.
• Collaborate with BI developers, analysts, and stakeholders to translate requirements.
• Modernize legacy reporting platforms with improved data structures.
• Monitor, troubleshoot, and optimize pipelines and DB performance.
• Create thorough technical documentation on data models, ETL/ELT, and flows.
• Partner with customer technical teams; travel locally and internationally as needed.

Skills

SQL

ETL/ELT design

Power BI

Python

Data warehousing

Analytical thinking

Stakeholder communication

Education

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

Tools

SSIS/SSRS

SQL Server

PostgreSQL/Oracle

Hadoop

Job description

Description

About the job

Join our Team-Your career journey starts here – not just a job, but a future.

Our Potential Opportunity

INTECH Automation Intelligence is seeking a Data Warehouse Consultant/Engineer to join our dynamic team. This role is pivotal in supporting Industrial Digitalization Solutions across industries such as Oil & Gas, Petrochemicals, Utilities, and Manufacturing. You will be responsible for designing and delivering scalable data warehouse solutions that power enterprise reporting, analytics, and data-driven decision-making across complex industrial environments. INTECH’s commitment to providing cutting-edge Digital Solutions ensures you will contribute to transformative projects that enhance operational efficiency and productivity.

Our Digital Solutions are a testament to our dedication to driving innovation and optimizing industrial processes, reflecting our focus on excellence, reliability, and overcoming industry challenges.

What You’ll Lead and Deliver

• Design, develop, and optimize enterprise SQL-based data warehouse solutions that consolidate data from multiple sources, including relational databases, enterprise applications, OT/SCADA systems, historians, and flat files into a centralized source of truth.
• Build and maintain robust ETL/ELT pipelines to ingest, cleanse, validate, and transform data across development, pre-production, and production environments.
• Develop high-performance SQL queries, stored procedures, functions, and triggers to efficiently manage and serve large-scale datasets.
• Enable the data warehouse to serve as the foundation for enterprise reporting and analytics by delivering clean, well-structured datasets optimized for Power BI.
• Collaborate with Business Intelligence developers, analysts, and business stakeholders to translate reporting requirements into scalable data models and data integration solutions.
• Support the modernization of legacy reporting platforms, including SSRS, Excel, and Crystal Reports, by redesigning underlying data structures for Power BI reporting.
• Monitor, troubleshoot, and continuously optimize data pipelines and database performance to ensure scalability, reliability, and high availability.
• Develop and maintain comprehensive technical documentation covering data models, ETL/ELT processes, pipeline architecture, and data flows.
• Partner with customer technical teams throughout project delivery, with occasional local and international travel as required.

Requirements

To Be Successful in This Role, You Must Have:

• 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 working with relational database platforms such as Microsoft SQL Server, PostgreSQL, and Oracle.
• Proven experience designing and implementing enterprise-grade ETL/ELT pipelines that integrate multiple heterogeneous data sources.
• Experience working with industrial data sources such as SCADA systems, process historians, or OT environments will be considered a strong advantage.
• Strong understanding of dimensional data modeling, including Star and Snowflake schemas, as well as data warehousing architecture and data quality best practices.
• Working knowledge of Microsoft Power BI, including data modeling, Power Query, and DAX, to support downstream reporting and analytics.
• Experience with Microsoft BI technologies such as SSIS and SSRS and/or modern cloud-based data platforms is preferred.
• Practical experience with Python for data processing, scripting, or automation; exposure to big data technologies such as Hadoop is an added advantage.
• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or a related discipline.

Competencies:

• Strong analytical thinking and problem-solving abilities.
• Excellent SQL development and database optimization skills.
• Strong understanding of enterprise data architecture and modern data engineering practices.
• Effective communication and stakeholder management skills with the ability to work across business and technical teams.
• Strong documentation, planning, and organizational capabilities.
• Self-motivated, collaborative, and capable of delivering high-quality solutions in customer-facing environments.
• Ability to manage multiple priorities while maintaining a focus on quality, scalability, and continuous improvement.

We Offer Competitive Benefits:

• Global Exposure: Opportunities to work on international projects and collaborate with global teams.
• Competitive Compensation: A salary package that recognizes your expertise and contributions.
• Annual Bonus: Performance-driven rewards based on your gross pay to celebrate your achievements and contributions.
• In-House Lunch: Delicious meals provided during work hours to keep you fueled and focused.
• Health Insurance: OPD coverage for you and your parents, plus IPD coverage for you and your dependents.
• Learning Opportunities: Access to training programs, workshops, and certifications to enhance your skills.
• Work-Life Balance: Paid time off, including annual leave and holidays.
• Inclusive Environment: A workplace that celebrates diversity and fosters collaboration.

Why Join INTECH Automation Intelligence?

At INTECH, you will have the opportunity to work with a globally renowned industrial automation and digitalization technology company. For nearly 30 years, INTECH has partnered with major oil and gas global giants to deliver innovative solutions. As we continue to lead in the Industry 4.0 era, you will be at the forefront of transformative technologies that solve real-world challenges.

What to Expect After Applying?

Explore how INTECH’s Talent Acquisition team ensures a seamless hiring journey. From embracing talent with a passion for innovation to fostering a culture of continuous learning and growth, we’re dedicated to finding and supporting the best minds in the industry.

Our hiring process is designed to assess your skills and potential in a fair and inclusive manner. After applying, you will be guided through a structured evaluation process to ensure mutual alignment.

INTECH Automation Intelligence is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.