Data Warehouse Architect

Aalto University is where science and art meet technology and business. We shape a sustainable future by making research breakthroughs in and across our disciplines, sparking the game changers of tomorrow and creating novel solutions to major global challenges. Our community is made up of 12 000 students, 400 professors and close to 4 000 other faculty and staff working on our dynamic campus in Espoo, Greater Helsinki, Finland. Diversity is part of who we are, and we actively work to ensure our community’s diversity and inclusiveness. This is why we warmly encourage qualified candidates from all backgrounds to join our community.

Aalto University IT Services supports our researchers, teachers, students and other staff by producing world class services that make their work easier, more flexible, comprehensive and secure regardless of time and location. We are a community of over 140 committed and talented IT experts.

Want to be a game changer?

We are now looking for a Data Warehouse Architect/Data Modeler to join our team.

In this role you will set the course for Aalto Data Warehouse architecture and development activities. You look actively for new technologies and possibilities to transform Aalto Data Warehouse to digital age, and you will take direct responsibility of further developing our Data Warehouse. You will drive the Aalto Data Warehouse platform architecture and best practices to ensure that Aalto Data Warehouse functions well according to the latest standards.

In addition to all this, we are curious about your ideas – you will be able to shape your work based on your interest areas. In this position, you will get to work with and support Finland’s top gurus from different fields and be a part of an ambitious working environment that you can be proud of.

Your Responsibilities

• Conception, design, development, and deployment of data architecture and data models
• Provide direction for the architectural design
• Work together with Aalto Data Warehouse solution owner to develop data warehouse platform vision, strategy, and roadmap
• Follow various ETL Processes to prepare design for all metadata
• Contribute to actual development of MS SQL Data Warehouse and related activities
• Encourage the adoption of Aalto Data Warehouse framework by providing documentation, training, sample code, and developer support

What we offer

Aalto University is technically unique and interesting: we have a rich and versatile IT environment with leading edge technologies and latest developments in the field of IT research. Our significant in-house IT resources and capabilities enable experimenting and committed long-term IT development. We have an ambitious digitalization strategy and a diverse and vast community of innovative users.

We offer you an interesting, independent and contributing role in heart of Aalto’s digitalization. Although you are independently responsible of your own area of work, we offer you support and coaching when you feel you need it. We offer you great possibilities for competence development and career advancement as we are looking for potential to grow into even more demanding IT roles.

With us you will be part of an inspiring and supportive work community of ambitious game-changers who are committed to identifying and solving grand societal challenges and building an innovative future. We support a culture of learning and experimentation. We fail fast and learn fast – together.

Watch videos! Here you can find out what it is like to work in Aalto IT Services https:// duunitori.fi/tyoelama/aalto-universitys-it-experts-in-spotlight
And here you can find what Aalto is all about https://www.youtube.com/user/aaltouniversity/featured

Your experience and ambitions

You are by nature a Data Warehousing and Data Modeling expert with experience and skills from on premise infrastructure to hybrid cloud. You don’t need to be an expert in all of the technologies we are using but you can communicate fluently with the internal and external specialist who are. Earlier you might have worked as an IT architect or Database specialist focusing on Data Warehouse. However, you can succeed and enjoy working in this position coming from many different backgrounds. You get excited about the newest IT technologies and envisioning the possibilities they could offer in taking Aalto’s digitalization further. Working with vendors is familiar to you. You collaborate and communicate naturally with other IT professionals, academics as well as entrepreneurs from Aalto startup community.

More than anything, we hope you are passionate about your field of work and enthusiastic about constantly innovating and learning something new together with others.

What we are looking for:

• Experience developing enterprise data warehouses, data migrations, data transformations, and data architecture
• Extensive experience writing SQL queries and stored procedures preferred
• Experience in Python Framework to Process XML, CSV, JSON, TSV, TXT files
• Experience in gathering and analyzing system requirements
• Proven critical-thinking skills and problem-solving attitude

Ready to join?

To hear more, you can reach out to Data Asset & Project Management Team leader Elena Pirinen (mobile: +358505778870) March 14th 13-14 and 28nd 9-10.

If you want to join our community, please submit your application through our recruitment system by Sunday, April 3rd, 2022. As we are eager to find the right game changer to join our team, we will start reviewing applications immediately.

More about Aalto University:

Aalto.fi
twitter.com/aaltouniversity
facebook.com/aaltouniversity
instagram.com/aaltouniversity