Data Warehouse Engineer

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. INTECHs 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 Youll 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:

• 510 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.
• Bachelors 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 INTECHs 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 were 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.