Senior Consultant Data Warehouse

Company Description
At AFRY, we bring together leading digital expertise and technologies into AFRY X. The new division AFRY X is a digital leader and powerhouse in industrial IoT, AI, design and cyber security that helps clients to accelerate their digital transition.
We are a team consisting of Data Analysts, Data Engineers and Data Scientists working with both in-house projects/products and also assignments at our customer’s sites. Our customers are small, medium and large size companies in the Nordic region within Energy, Industrial and Process sectors with digital transformation and sustainability at the top of their agenda.
Due to an increased demand from our customer base we need to strengthen our team with more Data Engineers. We are looking for people with a solid background in data and analytics.
AFRY is a European leader in engineering, design, and advisory services with a global reach. We accelerate the transition towards a sustainable society.
We are 17,000 devoted experts in infrastructure, industry, energy and digitalization, creating sustainable solutions for generations to come.
Job Description
Do you want to be a part of a team that works in a diverse, complex and fast-changing landscape of data sources and consumers? AFRY’s wide customer base in a number of different industries, makes the wide spectra of projects and challenging assignments high.
We are looking for someone with a background in Cloud platforms for collection, storage, processing and visualization of data.
Qualifications
You are a team player that is used to working in cross functional teams using agile methodologies.
You have an academic degree at masters level in a relevant field.
Skills and experience (we understand however if you are not knowledgeable in all of the below)
Delivering modern data warehouse solutions in Azure or Snowflake
Data modelling including data vault and star schema
Worked with ETL/ELT processes and well versed in the SQL language and databases.
Structured, semi-structured, and unstructured data, including file formats ORC, Parquet, Avro, JSON, XML, CSV,
Data Pipeline frameworks such as Data Flow, Data Factory, Apache Beam, etc
CI / CD and DevOps
Strong knowledge of Agile methods
Fluent in English, both spoken and written
Due to the prompt need of this competence it is admirable if you’re living and/or have work permit in Sweden/EU

Nice to have
Familiar with data visualization tools such as Tableau or Looker
Experience from working as a consultant
Spoken and written Swedish
Experience with Google Cloud Platform, Azure or AWS
Data Security

Additional Information
The role is for our AI and Analytics Team with Henrik Mårtensson as Section Manager, who has 20+ years of experience within the field. Other than your closest colleagues in the team you will be able to build a network internally with other parts of AFRY working within analytics. The possibilities for you to grow within your area of expertise are therefore to be seen as very good.
In addition to this, we offer for example:
28 days of vacation + holiday on the 23rd of December
Work life balance
Access to a wide range of activities through our social club: Club AFRY, such as Hackathons, yoga, restaurant visits and more
Competitive benefits regarding pension, health care and parental leave
Company discounts with external partners through our benefits portal Advantage You.
Wellness allowance 3000 SEK/year
Restaurants and cafés on site (location dependent)
A huge network of technical experts: + 16,000 colleagues with offices in 50 countries and projects in 100

Our recruitment process consists of a first check over Teams, one to two interview steps (IRL or over Teams depending on the current situation), a technical test and references. Do not that we cannot process applications sent over email. Apply through our system. Last day to apply: 2022-11-16
Henrik Mårtensson (Team Lead), henrik.martensson@afry.com
Henriks LinkedIn
André Söderholm, Recruitment Partner, Andre.soderholm@afry.com
AFRY is committed to creating an inclusive & diverse environment and we are actively looking for qualified candidates irrespective of gender, gender identity, sexual orientation, ethnicity, religion, disability, or age. You will be part of a global and diverse company where our differences are our strengths. Join us to accelerate the transition towards a sustainable society.


AFRY is committed to creating an inclusive & diverse environment and we are actively looking for qualified candidates irrespective of gender, gender identity, sexual orientation, ethnicity, religion, disability, or age. You will be part of a global and diverse company where our differences are our strengths. Join us to accelerate the transition towards a sustainable society.