01 Zakres zadań

Responsibilities:

Developing ETL/ELT pipelines for data ingestion and transformation based on SA specifications.
Implementing data mart prototypes in Greenplum for production: refactoring SQL, implementing incremental loading, and ensuring idempotency.
Optimizing queries and data marts in Greenplum: selecting distribution keys, implementing partitioning, analyzing query plans (EXPLAIN ANALYZE), mitigating data skew and broadcast/redistribute motion, and configuring resource queues/groups.
Configuring pipeline orchestration, monitoring, and alerting.
Performing data quality checks and ensuring SLAs for data mart freshness.

02 Wymagania

5 must-have · 1 język

Must-have

Ekspert

Zaawansowany

Wymagane języki

Angielski

Podstawowy

03 Profil

Must-haves:

Experience working as a Data Engineer for 3+ years.
Strong SQL skills, including complex queries, window functions, and working with large tables; advanced Python proficiency.
Extensive experience with Greenplum, including a strong understanding of distributed architecture and MPP systems, distribution keys and partitioning, query optimization and execution plan analysis, VACUUM/ANALYZE, and working with append-optimized and column-oriented tables.
Experience working with DWH systems and a solid understanding of data modeling principles, including Data Vault and star/snowflake schemas.
Experience working with orchestration tools such as Airflow or similar solutions and processing large volumes of data.
Experience working with Git and CI/CD pipelines and participating in code reviews.
Ability to read and analyze source system documentation and effectively collaborate with source system owners.
Ability to write clear, well-structured, and unambiguous technical specifications.
Level of English – from Intermediate and above.

04 O firmie

Andersen Lab

5000+ · Chișinău

Andersen – your global software development partner Andersen is a global software development company with over 18 years of experience supporting businesses worldwide in their digital transformation. Headquartered in Poland, we operate development centers across Germany, the USA, the UK, Lithuania, Hungary, Kazakhstan, Georgia, Azerbaijan, Cyprus, and the UAE, enabling us to deliver high-impact solutions close to our customers. We offer end-to-end IT services — from custom software development, API integration, and system architecture to legacy modernization and long-term support. With deep technical expertise and a focus on business value, we build tailored, scalable, and secure digital products. Harnessing the power of AI, Machine Learning, Data Science, Big Data, and Visual Technologies, we create intelligent, future-ready solutions that support digital transformation and solve real-world business problems. Recognized among the world's Top 1,000 B2B service providers, Andersen has earned the trust of industry leaders. Our portfolio includes long-term partnerships with Siemens, S&P Global, Ryanair, IHS Markit, TUI, Johnson & Johnson, T-Systems, and many more. With a team of 3,700+ highly qualified experts in 16+ global locations, we have successfully delivered over 1,000 projects across industries such as Healthcare, FinTech, Logistic, Automotive, Manufacturing, E-commerce, Multimedia & Entertainment and more. Driven by responsibility, client-focus, and commitment to results, Andersen is your reliable tech partner for building high-ROI, future-proof digital solutions — anywhere in the world.

Zobacz ogłoszenia Strona www

05 Lokalizacja

Stefan cel Mare St 31 31, Chișinău

Tryb pracy:
Elastyczne godziny pracy

Godziny pracy biura: 9-18

Model pracy

Stacjonarnie

Hybrydowo

100% zdalnie