DWH Engineer
Avalanche Labs, Lithuania

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.

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 for DWH Engineers to join our growing team. As a DWH (Data Warehouse) Engineer, you will be responsible for designing, developing, and maintaining data warehouses and enterprise data management systems. You will working closely with business stakeholders and data analysts to understand and translate business requirements into technical solutions that meet performance, scalability, and security standards. Your first project in Avalanche Labs will be in the Banking industry playing a key role in ensuring the effective delivery of technology solutions that meet the needs of our clients. The project that you and a team will be working on is in BI and DWH area (Group Business Intelligence, Group Data Warehouse development and architecture Risk area data loadings for Loss and Recovery and Capital Adequacy Assessment projects). The essence of the projects is to develop BI reporting solutions, incl. development of data sourcing for various banking regulatory credit reports. The team consists of between 7-10 consultants and the structure is as follows: between 1 product owner; 1 scrum master; 3-4 DWH engineers; 1-2 data analysts; 1-2 business analysts. Overall when joining our team as a DWH Engineer, you will work closely with Agile development teams to ensure that projects are delivered on time, within budget, and to the highest level of quality. In addition to that, you will have an opportunity to work with different clients and projects all over the world and kick-start your career here in Avalanche Labs.

3+ years of experience in DWH or ETL development;

Hands-on experience with DWH platforms such as Oracle, SQL Server, Teradata, or 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.

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.

Apply and join our team!

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

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

Benefit basket with options to get the latest tech, additional vacation weeks, training, travel around Europe in a camper van, go on extreme adventures with Avalanchers, and much more!

Excellent quarterly company events and monthly themed events!

Flexibl

Job Rewards and Benefits