Data Warehouse Engineer

SENSYS Inc.; Pakistan; On-site; PKR 1,800,000 - 2,400,000; Full time

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.

Skills

SQL

T-SQL/PL-SQL

ETL/ELT pipelines

Power BI

Python

Hadoop

SSIS/SSRS

Dimensional modeling

Data architecture

Stakeholder communication

Education

Bachelor's degree in Computer Science/Information Systems/Software Engineering/Data Engineering

Tools

Microsoft SQL Server

PostgreSQL

Oracle

SSIS

SSRS

Power BI Desktop

Job description

## Data Warehouse EngineerPakistan · Mid Senior Level#### About The Position**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.Click Here to learn more about our hiring process and discover your path to success with us.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.