Data Engineer (SQL, BigQuery) - Fulltime - Worldwide

Role Overview

We are in search of a highly skilled Data Engineer to join our team. The ideal candidate will be responsible for designing and optimizing our data infrastructure, ensuring efficient data storage and retrieval processes. Your expertise will contribute to building robust data models and managing SQL pipelines, facilitating seamless data integration and analysis.

Responsibilities

• Develop and optimize complex SQL queries to handle wide tables, ensuring efficient data retrieval and storage.
• Design and implement dimensional data models, specifically Star Schemas, using the Kimball Methodology.
• Manage and maintain SQL pipelines and dependency graphs using tools like Dataform or dbt.
• Collaborate with cross-functional teams to understand data requirements and ensure data integrity across systems.
• Provide insights and recommendations for improving data processes and infrastructure.

Required Skills

• Expert-level proficiency in SQL and BigQuery, with a deep understanding of columnar storage and partitioning.
• Proven experience in dimensional modeling, particularly with Star Schemas (Kimball Methodology).
• Proficiency in analytics engineering tools such as Dataform (preferred) or dbt.

Nice to Have

• Familiarity with ERP data structures like SAP B1 or Netsuite.
• Experience with E-commerce schemas, particularly Magento eav_entity.