Would you like to join to the one of the most interesting technology projects in Nordea? We are now looking for a Snowflake Expert to implement very large scale data intelligence solutions around Snowflake Data Warehouse on AWS.
In Nordea, we’re harnessing the power of technology to reinvent the future of banking. A tech revolution is underway – and you can make an impact. Though we’re a Nordic bank, we’re also one of the largest IT employers in Tricity and Warsaw. Working with international teams in an inspiring working environment, you’ll have lots of opportunities to expand your skills and advance your career.
About this opportunity
Welcome to the Datawarehousing Development team. We add value by designing solutions matching the capabilities to the prioritised business challenges . As a Snowflake Expert, you’ll play a valuable role in Common Data Warehouse (CDW) - common repository for all banking book data within Nordea, with users across Group Treasury, Group Capital and Group Finance as well as Retail.
What you’ll be doing:
- Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL
- Writing SQL queries against Snowflake
- Developing scripts Unix, Python etc. to do Extract, Transform and Load data
- Providing production support for Data Warehouse issues such data load problems, transformation translation problems
- Translating requirements for BI and Reporting to Database design and reporting design
- Understanding data transformation and translation requirements and which tools to leverage to get the job done
- Understanding data pipelines and modern ways of automating data pipeline using cloud based
- Testing and clearly documenting implementations, so others can easily understand the requirements, implementation, and test conditions.
In Datawarehousing Development we develop, maintain, test and evaluate data sourcing solutions within Nordea’s Group data platforms. We are also involved in the design of solutions matching the capabilities to prioritised business challenges. Besides above, we are responsible for delivering the ETL development capability on the platform. The role is based in Tricity or Warsaw.
Who you are
Collaboration. Ownership. Passion. Courage. These are the values that guide us in being at our best – and that we imagine you share with us.
To succeed in this role, we believe that you:
- are able work in an challenging and agile environment with quick turnaround and strict deadlines
- are familiar with CI/CD concepts and the processes
Your experience and background:
- Minimum 1 year of designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.
- 3 years of hands on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python
- 2 years of hands on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Teradata, Oracle or DB2 Expertise and excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
- Knowledge of JavaScript needed to write the stored procedures on the Snowflake side
- A solid experience and understanding of architecting, designing and operationalization of large scale data and analytics solutions on Snowflake Cloud Data Warehouse.
Nice-to-have:
- Bachelor’s degree in Computer Science, Engineering, Technical Science or 3 years of technical architecture and build experience with large scale solutions.
- Minimum 1 year of experience in architecting large-scale data solutions, performing architectural assessments, crafting architectural options and analysis, finalizing preferred solution alternative working with IT and Business stakeholders Experience including data ingestion pipeline using Talend, Informatica Experience in working with AWS, Azure and Google data services Prior experience in client facing projects.
- Good to have professional knowledge of AWS Redshift.
If this sounds like you, get in touch!
Submit your application no later than 26/11/2021.
At Nordea, we know that an inclusive workplace is a sustainable workplace. We deeply believe that our diverse backgrounds, experiences, characteristics and traits make us better at serving customers and communities. So please come as you are.
Please include permit for processing personal data in CV as following:
In accordance with art. 6 (1) a and b. Regulation (EU) 2016/679 of the European Parliament and of the Council of 27 April 2016 on the protection of natural persons with regard to the processing of personal data and on the free movement of such data, and repealing Directive 95/46/EC (General Data Protection Regulation) hereinafter ‘GDPR’. I agree to have: my personal data, education and employment history proceeded for the purposes of current and future recruitment processes in Nordea Bank Abp.
The administrator of your personal data is: Nordea Bank Abp operating in Poland through its Branch, address: Aleja Edwarda Rydza Śmiglego 20, 93-281 Łodź. Your personal data will be processed for the recruitment processes in Nordea Bank Abp. You have a right to access your personal data, right to rectify and right to delete. Disclosing the personal data in the scope specified by the provisions of Polish Labour Code from 26 June 1974 and executive acts are mandatory. Providing personal data is necessary to conduct the recruitment processes. The request for the deletion of your personal data means resignation from further participation in recruitment processes and causes the immediate removal of your application. Detailed information concerning processing of your personal data can be found at: https://www.nordea.com/en/doc/privacy-policy.2021.pdf.
We reserve the right to reply only to selected applications.