Data Architect
67 Prosta St, 00-838. Warsaw, Poland
Apply
Key Responsibilities
- Evaluate database schemas and DDL, identifying gaps and opportunities for improvements
- Analyze and optimize long-running queries and workloads for performance efficiency
- Collaborate with DBAs to assess Greenplum cluster and tune performance
- Establish governance for SQL code reviews and best practices
- Lead database capacity planning and scalability strategy
- Participate in data modeling of modern centralized data models and architecture for data streaming, ingestion, and API scalability
- Support and evaluate the state of ETL/ELT optimization and integration with MPP platforms
- Ensure database design aligns with security, governance, and compliance
- Drive Greenplum to Redshift migration POCs, including performance benchmarking
Qualifications
- 2+ years of experience in data architecture and optimization
- Strong expertise in Greenplum performance tuning and MPP optimization
- Hands-on experience with AWS Redshift design and migration
- Proven track record in query optimization and remediation
- Strong skills in SQL, indexing, and schema design
- Experience with ETL/ELT pipelines and cloud-native integrations (e.g., Kafka, S3)
- Knowledge of database monitoring, governance, and compliance best practices
- Knowledge of PostgreSQL and integration patterns with Data Warehouse
- English proficiency at B2 level or higher
Nice-to-Have:
- Experience with Snowflake
- Familiarity with Informatica, Glue, modern ETL tools and Batch orchestration
- Scripting skills (Python/Scala/Java) for automation
About us
At Vention, we assemble senior-level, dedicated teams of developers to help fast-growing startups and innovative enterprises drive impact and achieve their goals. We’ve delivered solutions across multiple domains, including FinTech, PropTech, AdTech, HealthTech, e-commerce, and more.
Benefits
Our culture is rooted in the belief that ongoing growth benefits employees and the company alike. Because of that, we offer:
- An individualized approach to career development, tailoring growth plans to every role
- Access to our technology mentorship program as a mentor or mentee
- The opportunity to contribute to up to 300 original projects in 30 different fields
And that's not all! We also offer:
- Expanded medical support through Luxmed Complex
- Сonferences & meetups, organized by our company
- Corporate getaway & teambuilding activities
- Access to credits to spend across a variety of stores, restaurants & cafes through Kafeteria My Benefit
- And referral bonuses
Engineer your success!
Apply for Data Architect: