Data Warehouse Engineer

INTECH Process Automation

38d • Onsite

About The Position

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.

Requirements

• 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.
• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or a related discipline.
• 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.

Nice To Haves

• 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.

Responsibilities

• 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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level