Kıdemli Veri Ambarı Geliştirme Uzmanı

Welcome sahibinden.com world!

• We work for WOW? moments
• We stay curious and explore, we love innovation
• We look into the same topics from different perspectives
• We celebrate and feel proud of our success together

S- technology;

Sahibinden.com has been helping people meet their dreams for the last 24 years.

With more than 55 million users and approximately with its 1000 employees, sahibinden.com is among the top five companies globally in classifieds sector.

Approved in 2017 as an R&D center in Turkey, sahibinden.com has been the pioneer of a variety of new services and provide continuous and reliable service over the web and mobile networks. Through our dynamic and agile teams, we continue to be a driving force in the digital marketplace by developing scalable and high-performance platforms that serve millions of users daily.

At sahibinden.com, we adopt a culture of innovation and continuous improvement at work to empower our employees. This approach, which fosters creative thinking and professional development, consistently earns us the title of one of The Best Workplaces in Europe, as voted by our employees.

Join us and be a part of our journey to redefine the future of e-commerce.

Is that you? Great!

• Bachelor's degree in Computer Science, Information Systems, Industrial Engineering, Stastics, Mathematics or related field
• Minimum 4 years of experience as a Data Warehouse Developer, with a focus on BigQuery or similiar data platforms and  including experience with Vertica as the database platform
• General understanding Data Warehousing concepts and new modelling concepts
• Strong experience with SQL development in BigQuery ,including query optimization, partitioning and clustering strategies  and performance cost optimization
• Strong proficiency in writing complex SQL transformations using BigQuery SQL, with hands-on experience in Dataform for transformation layer and Dataflow for data processing pipelines
• Experience with Airflow or similiar workflow orchestration tools.
• Interest in AI/ML with a willingness to learn and adapt new technologies
• Strong communication skills, with the ability to collaborate effectively with cross-functional teams and business stakeholders.

If the requirements are met, then your job description is below;

We are seeking an experienced Senior Data Warehouse (DWH) Developer with expertise on enhancement DWH-Pipelines structure for our team for an enterprise-level Data Warehouse (DWH) project. The ideal candidate will have strong experience working with data analysis, Data Warehouse  modeling and SQL for ETL pipelines on data warehouse architecture. This role will involve creating data models on business domains and implementation of data models by developing optimized DWH-ETL pipelines. This role will interest to learn  AI/ML technologies.

Responsibilities:

• Design, develop, and optimize complex ETL processes for a large-scale Data Warehouse using BigQuery as the primary database platform.
• Ensure to data modeling and normalization principles to maintain data integrity and scalability of DWH environment.
• Build and automate DWH-ETL pipelines across the Data Warehouse on ETL-scheduling tool.
• Implement optimized query structures and table formats in order to enhance data querying efficiency and improve overall system performance.
• Build and enhance existing DWH models in order to enhance performance of queries triggered by BI Visualisation platform.
• Collaborate with DWH/BI analysts to understand reporting requirements across the business domains.
• Develop DWH pipelines regarding reporting requirements and system efficiency constraints.
• Collaborate with Data Architecture and infrastructure teams to optimize DWH pipelines deployment and monitoring on Vertica Analytics Platform.
• Support data analytics teams by providing optimized datasets and ensuring efficient ETL workflows.

Preferred Skills

• Solid knowledge of ETL and Data Warehouse concepts
• Knowledge of cloud platforms (GCP) and their data services (e.g., BigQuery).
• Familiarity with version control systems like Git.

What We Offer

• Birthday leave

• 2 weeks of remote work available throughout the year
• One week accommodation at Richmond Efes and Pamukkale Hotels (for employees who have completed 3 years at Sahibinden.com)
• Well-being opportunities; Quality life package, Gym and Dietician service