Data Warehouse Engineer (Analytics) at ITB Holdings

, , -

Full Time

Start Date

Immediate

Expiry Date

19 Apr, 26

Salary

0.0

Posted On

19 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Warehousing, Data Build Tool (DBT), Google Cloud Platform (GCP), PowerBI, Data Modeling

Industry

Description

Overview We are seeking a highly technical Data Warehouse Engineer with deep expertise in database administration and data transformation. This role is crucial for building and maintaining the foundation of our data stack, focusing on data warehouse development and performance optimization. You will be responsible for architecting relational data models, ensuring database performance, and building clean, reliable data sources that agnostically power BI products (Looker Studio, Power BI, Tableau etc). Your expertise will be vital in creating a high-performance, well-documented, and scalable data warehouse. Responsibilities Perform advanced PostgreSQL optimization, including query tuning, index management, and analyzing EXPLAIN plans to resolve bottlenecks. Develop, manage, and optimize our entire data transformation layer using dbt, ensuring models are efficient, tested, and well-documented. Design and implement robust, scalable data models using data warehousing strategies (Star Schema, Snowflake Schema). Collaborate directly with BI developers and analysts to build and optimize data sources for various dashboard design tools (e.g., Looker Studio, Looker, Power BI). Write and maintain DDL and DML scripts, manage database migrations, and enforce data quality standards. Manage our dbt project in source control (GitLab/GitHub), managing branching and CI/CD pipelines. Qualifications DBT Expertise: Expert-level proficiency in dbt for building and managing complex data transformation pipelines. SQL & Query Optimization: Mastery of advanced SQL (DDL, DML) and the ability to interpret and act on EXPLAIN plans to tune performance. Data Warehousing Concepts: Strong, practical knowledge of relational databases and data warehousing strategies (Star Schema, Snowflake Schema). Postgres Features: Proven experience with advanced PostgreSQL features, including partitioned tables, views, and materialized views. BI Data Modeling: Strong experience designing data models to support general dashboard design tools (Looker Studio, Looker, Power BI, etc.). GitLab/GitHub: High level of competency in using Git for version control, especially for managing a dbt project. Required Skills SQL, Data Warehousing, Data Build Tool (DBT), Google Cloud Platform (GCP), PowerBI, Data Modeling

Responsibilities

The Data Warehouse Engineer will perform advanced PostgreSQL optimization and develop, manage, and optimize the data transformation layer using dbt. They will also collaborate with BI developers to build and optimize data sources for dashboard design tools.