Data Warehouse Developer

6 days ago

Prague, Hlavní město Praha, Czech Republic Absa Group Full time
Empowering Africa's tomorrow, together…one story at a time.

With over 100 years of rich history and strongly positioned as a local bank with regional and international expertise, a career with our family offers the opportunity to be part of this exciting growth journey, to reset our future and shape our destiny as a proudly African group.

My Career Development Portal: Wherever you are in your career, we are here for you. Design your future. Discover leading-edge guidance, tools and support to unlock your potential. You are Absa. You are possibility.

Job Summary

We are looking for a highly skilled Data Warehouse Developer to join our data engineering team. The successful candidate will be responsible for designing, building, and maintaining scalable data warehouse solutions and ETL pipelines across AWS environments. This role is central to enabling high-quality, reliable data for reporting, analytics, and advanced business insights.

Job Description

  • Design, develop, and maintain data warehouse solutions in Amazon Redshift, ensuring optimal schema design, distribution/sort keys, and performance tuning.

  • Build and optimize ETL workflows using AWS Glue and PySpark, integrating diverse data sources into centralized platforms.

  • Manage data ingestion pipelines from relational databases, APIs, flat files, and streaming systems into Hadoop and AWS ecosystems.

  • Leverage AWS services (S3, Lambda, Step Functions, CloudWatch, Athena) to design scalable and cost-efficient data solutions.

  • Implement data models (star, snowflake, and 3NF) to support analytics and BI reporting.

  • Ensure data quality, reliability, and governance, applying best practices for security, compliance, and metadata management.

  • Collaborate with analysts, BI developers, and data scientists to deliver well-structured, accessible datasets.

  • Document processes, data models, and workflows to ensure maintainability and knowledge sharing.

Required Qualifications

  • Proven experience as a Data Warehouse Developer or Data Engineer.

  • Strong proficiency in SQL (query optimization, complex joins, window functions).

  • Hands-on experience with Amazon Redshift (schema design, workload management, tuning).

  • Strong knowledge of AWS, Spark for ETL development.

  • Understanding of data modeling principles (Kimball, Inmon).

  • Proficiency with AWS cloud services (S3, IAM, Lambda, CloudFormation/Terraform).

  • Familiarity with version control (Git) and CI/CD pipelines.

  • Bachelor's degree in Computer Science, Information Systems, or related field.

Preferred Qualifications

  • Experience with real-time streaming frameworks (Kafka, Kinesis).

  • Knowledge of data cataloging and metadata management (Glue Data Catalog, Apache Atlas).

  • Understanding of data security (encryption, IAM, GDPR/POPIA compliance).

  • Exposure to BI/visualization tools (Tableau, Amazon QuickSight, Power BI).

Soft Skills

  • Strong problem-solving and analytical skills.

  • Excellent communication and collaboration abilities.

  • Ability to work in agile, fast-paced environments.

  • Attention to detail and commitment to data accuracy.

Education

Bachelor's Degree: Information Technology

  • Data Developer

    6 days ago

    Prague, Hlavní město Praha, Czech Republic Edwards Lifesciences Full time 40,000 - 60,000 per year

    We are seeking a motivated Data Developer to support the development of modern data solutions and reporting. This role is ideal for someone with a solid foundation in SQL, familiarity with Power BI, and a keen interest in data warehousing and analytics.How you will make an impact:Design, develop, and maintain Power BI reports to support internal business...

  • Data Engineer

    2 weeks ago

    Prague, Hlavní město Praha, Czech Republic UD4D Group Full time 60,000 - 120,000 per year

    Expand your experience with WhereScape - an automation tool for fast and efficient design, development, and management of data warehouses that minimizes manual work, supports various methodologies, and is compatible with many database platforms.Join our team as a Data Engineer. Work on leading technological solutions in an international team.What you...

  • Data Engineer

    2 weeks ago

    Prague, Hlavní město Praha, Czech Republic Oddin Full time 60,000 - 120,000 per year

    We're building a Realtime Data Platform – a platform that ingests data from multiple external sources, normalizes it into canonical models, and serves it for analytics, dashboards, and client-facing reports. As a BI Data Engineer, you'll design and operate data models and transformation pipelines, ensure data quality and reliability for...

  • Senior Data Warehouse Developer

    10 hours ago

    Prague, Hlavní město Praha, Czech Republic Principal engineering s.r.o. Full time 1,200,000 per year

    Postav datovou páteř v cloudu – AWS, Redshift, ELT a reálný business dopad. Budeš u návrhu, budeš rozumět datům a budeš stavět řešení, která dávají smysl. Čeká tě vývoj v prostředí AWS, přetváření starých BW modelů do moderních datových struktur a blízká spolupráce s analytiky i

  • Lead Data Engineer

    2 weeks ago

    Prague, Hlavní město Praha, Czech Republic Confirmo Full time 900,000 - 1,200,000 per year

    Job description Who are we?Confirmo is the fastest growing crypto payment gateway, trusted by industry leaders such as FTMO, Alza, or Trezor. Our flexible solutions, low fees, and top-class support make it easy for businesses of all sizes to accept crypto payments. Recognized by Forbes US as one of the top crypto payment gateways globally.Join our missionAt...

  • Data Engineer

    2 days ago

    Prague, Hlavní město Praha, Czech Republic Oddin Full time 60,000 - 120,000 per year

    About the RoleWe're building a Realtime Data Platform – a platform that ingests data from multiple external sources, normalizes it into canonical models, and serves it for analytics, dashboards, and client-facing reports.As a BI Data Engineer, you'll design and operate data models and transformation pipelines, ensure data quality and reliability for...

  • BI Developer

    6 days ago

    Prague, Hlavní město Praha, Czech Republic Wargaming Full time

    Job OverviewWargaming Data Warehouse is looking for a talented BI Developer to join our growing team. You will play a key role in designing and implementing data-driven solutions, leveraging cloud-based technologies like Snowflake and delivering valuable insights through Tableau. Working in collaboration with various business units, you'll be responsible...

  • Senior Data Engineer

    2 weeks ago

    Prague, Hlavní město Praha, Czech Republic 3Pillar Full time 1,200,000 - 2,400,000 per year

    At 3Pillar Global, we specialize in building impactful software products that power digital businesses.  We are seeking an experienced Senior Data Engineer with strong expertise in Looker, LookML, BigQuery, and SQL to join our data team. You will play a critical role in transforming data into actionable insights, building scalable data models, and...

  • Data Engineer

    2 weeks ago

    Prague, Hlavní město Praha, Czech Republic Jimmy Technologies Full time 60,000 - 120,000 per year

    Job description We are looking for Data Engineers for the data projects of our Fortune50 client. The main objective of the project is to modernize client's data infrastructure by migrating to Databricks. The solution is a cloud-based solution designed to empower users to build datasets for their projects in a swift, efficient, and standardized manner. The...

  • Data Engineer with Snowflake

    6 days ago

    Prague, Hlavní město Praha, Czech Republic Nexer Group Full time 60,000 - 120,000 per year

    Nexer Czech republic is a division within DANIR AB – an IT consulting and R&D company. We have the opportunity to work with world-renowned brands from Scandinavia, the USA, the UK, and Western Europe. Our goal is to grow strong but rather in competencies than in numbers.About the ProjectWe are currently seeking a Senior Data Engineer to join the Data,...