Data Warehouse Engineer

Position Summary

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.

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