DWH Engineer - Kraków, Polska - Avalanche Labs

Opis

WHO WE ARE

Our Mission is to help those in need with our out-of-this-world superpowers. Avalanche Laboratory's purpose is to be a reliable and long-term business partner to our customers offering them customized software solutions tailored for their business processes. We work on a project basis (in the EU and beyond), to this day we have already implemented over 320 projects and currently, we are working on another 45 projects. We have a wide range of clients from the financial sector, fintech, government projects, manufacturing companies etc.

WHAT WE DO

We are set up to provide our customers with end-to-end support in the process of developing software solutions:

• Business need analysis, design of functional and non-functional requirements, system analysis, support for business transformation and IT/business consultancy;
• User interface and experience design and development for mobile and desktop applications;
• Front and back-end development in a wide range of technologies: Java, .Net, Ruby, GoLang, Oracle, Python.
• Complete Data Warehouse solutions from architecture, design and implementation using mainly Vertica, Oracle and Microsoft platforms.
• Avalanche has been the central counterparty for multiple major banking projects in the Scandinavia and Baltics, in areas such as lending automation, regulatory reporting and calculations, integrations, governance, risk and compliance, Basel II/III, Stress Testing, AML/KYC.

Do you like us already? Wait until you see the role

Avalanche Labs is looking forDWH Engineers to join our growing team. In this role, you will be responsible for designing, developing, and maintaining data warehouses and enterprise data management systems. You will work closely with business stakeholders and data analysts to understand and translate business requirements into technical solutions that meet performance, scalability, and security standards.

You will have the opportunity to work on a diverse range of projects across industries, with an initial focus on the Banking sector. The project involves BI and DWH tasks, such as developing BI reporting solutions, including the development of data sourcing for various banking regulatory credit reports. You'll be a part of a team of our consultants.

As a DWH Engineer, you will play a critical role in ensuring the timely delivery of high-quality technology solutions that meet our clients' needs. You will be provided with the opportunity to work with clients and projects worldwide, offering a perfect platform to boost your career with Avalanche Labs.

DO YOU HAVE...

3+ years of experience in DWH or ETL development;

Hands-on experience with DWH platforms such as Oracle, SQL Server, Teradata, Hadoop;

Expertise in SQL and PL/SQL programming languages;

Experience with ETL tools such as Informatica, DataStage, or SSIS;

Familiarity with API development and integration technologies such as REST, SOAP, and JSON;

Strong analytical and problem-solving skills with attention to detail and accuracy.

Specific Skills and Tools:

Proficiency in Oracle and Teradata DWH database;

Experience with Oracle Data Integration (ODI) for ETL tasks;

Familiarity with Erwin for data modeling;

SQL for Data Analysis;

Experience using collaboration tools such as Confluence, JIRA, and Git;

Knowledge of additional full stack tools including Teradata SQL Assistant, Oracle Database, EDW-Board, Jenkins, Tivoli Scheduler, Visual Studio, Bit Bucket, ERwin, Jira, and Procreg.

WHAT YOU WILL BE DOING:

Design, develop, and maintain DWH and ETL (Extract, Transform, Load) solutions;

Collaborate with business stakeholders and data analysts to understand and translate business requirements into technical solutions;

Develop and maintain data models and database schemas that support business processes and analytics;

Develop and maintain data integration and API solutions;

Build automated testing and validation frameworks to ensure data quality and accuracy;

Troubleshoot and resolve data-related issues, such as missing or incorrect data;

Document technical designs, processes, and procedures.

THEN...

Apply and join our team

If you have any questions or want to know more details about this vacancy - feel free to contact us

WHY BECOME AN AVALANCHER...

This is an opportunity to work with talented teammates and shape the future of Avalanche Labs (and we have daring plans)

Working on an international level in a fast-paced environment with professional growth opportunities

Flexible work time and remote work arrangements