Data Warehouse Developer

1 week 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

    1 week 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

    1 week ago

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

    UD4D GroupExpand 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...

  • Data Engineer/Data Steward

    3 hours ago

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

    Job OverviewWargaming is looking to hire a proactive, passionate, and goal-oriented Data Engineer/Data Steward possessing deep technical knowledge on high-load telemetry systems creation and operation along with project management skills necessary for keeping the World of Tanks data storage, transfer, and usage efficient.We gather various types of...

  • Data Engineer

    1 week ago

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

    Department OverviewThe Data Engineering team is the backbone of the company's data-driven ambitions. We ensure the seamless flow, integrity, and cost-effectiveness of data across the organization. Our mission is to collaborate closely with the BI, Machine Learning, AI Engineering and other departments to align our data solutions directly with business goals....

  • Data Engineer

    4 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...

  • Data Engineer

    1 week ago

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

    BI | Prague, Czech Republic (Headoffice)Department OverviewThe Data Engineering team is the backbone of the company's data-driven ambitions. We ensure the seamless flow, integrity, and cost-effectiveness of data across the organization. Our mission is to collaborate closely with the BI, Machine Learning, AI Engineering and other departments to align our data...

  • Data Engineer

    3 hours ago

    Prague, Hlavní město Praha, Czech Republic Deutsche Börse Group Full time 60,000 - 120,000 per year

    Your area of work:  Datawarehouse Luxembourg builds, maintain and operates applications related to Clearstream Data Warehouse area via numerous applications called: CDL application (Clearstream Data Layer built on cloud latest technologies), Claims and Risk Management, Risk management, Regulatory Reporting, Customer's Reporting, Reference Data Repository...

  • BI Developer

    7 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...

  • Data Engineer with Snowflake

    1 week 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,...

  • Data Analyst in Software, Services and Enterprise Markets

    2 weeks ago

    Prague, Hlavní město Praha, Czech Republic International Data Group, Inc. Full time 1,200,000 - 2,400,000 per year

    Overview:IDC is seeking a Data Analyst to join the software team. In this role, you will have the opportunity to work on several of IDC's software programs, including applications, application development and deployment, and systems infrastructure software. Having familiarity with or expertise in the overall AI platforms will be advantageous for this role....