Data Engineer, Python

This is a fully remote position, open to applicants in Philippines.

📋 Description

• Oversee the creation, upkeep, and enhancement of the complete data transformation lifecycle utilizing Dataform.

• Design and maintain scalable, well-documented, and rigorously tested data transformation pipelines for business reporting purposes.

• Perform Exploratory Data Analysis on both new and existing datasets to pinpoint quality concerns, comprehend data structures, and unlock business insights.

• Develop efficient BigQuery SQL for intricate queries, aggregations, and data manipulation, with a focus on optimization for cost and performance.

• Establish data quality and validation measures to ensure the accuracy and reliability of reporting datasets.

• Take ownership of the transformation and modeling layers for a new data warehouse initiative.

• Utilize Kimball methodology principles to construct clean, dependable, and high-performance dimensional data models.

⛳️ Requirements

• Expert-level proficiency in Google BigQuery, inclusive of Dataform.

• Proven, extensive experience in designing and building dimensional data warehouses following Kimball's principles.

• Mastery of Dataform for the development, testing, and deployment of complex SQL-based data transformation workflows in a production setting.

• Demonstrable expertise in advanced SQL, including window functions, Common Table Expressions (CTEs), and intricate joins.

• Extensive hands-on experience with BigQuery, focusing on performance tuning, cost optimization, and partitioning/clustering strategies.

• Solid practical knowledge of data warehousing schemas: Star Schema, Snowflake Schema, and Data Marts.

• Capability to analyze and profile datasets to extract insights and evaluate quality.

• Experience in preparing data for Business Intelligence tools such as Looker, Tableau, or Power BI.

• Proficient in using Git for managing SQL and Dataform code.

• Familiarity with BigQuery ML is a notable advantage.

• A minimum of 4 years of relevant experience is required.

• Essential skills include Google BigQuery, Python, Gemini Enterprise, and Artificial Intelligence (AI).

🏝️ Benefits

• Competitive salary and performance-based incentives.

• Opportunities for professional development and continuous learning.

• Flexible working hours and remote work options.

• Comprehensive health and wellness benefits.

• Collaborative and inclusive company culture.