Senior Data Warehouse Developer

PricewaterhouseCoopers International Limited
Amsterdam, Netherlands
20 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Amsterdam, Netherlands

Tech stack

Azure
Data Cleansing
ETL
Data Structures
Data Vault Modeling
Data Warehousing
Python
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
SQL Server Analysis Services
Systems Integration
Data Processing
Snowflake
Backend
Ssas Tabular
Databricks

Job description

Description

& Summary

We don't need to tell you that data is the new gold. As a Data Warehouse Engineer, you also know that all that data doesn't just appear in dashboards and graphs by itself. You are the one with the technical knowledge behind the scenes. Do you want to use that knowledge to take our business processes to an even higher level with Business Intelligence solutions? Then apply for this job!

What does the job look like?

The data team provides insights and information that are decisive for the rest of the organization. The current Data Warehouse solution runs on the on-prem version of the Microsoft BI stack. This solution will be replaced by a solution on the Microsoft Azure Platform. The team consists of eight enthusiastic colleagues, including a lead developer, a test and process manager, analysts, and developers who can't wait to meet you. In this context, as a DWH Engineer, you will be involved with backend solutions. Furthermore, you work together with various professionals and stakeholders. Finally, you are responsible for:

  • Designing ETL processes based on business requirements;

  • Establishing and implementing business rules;

  • Improving ETL processes by increasing quality and availability;

  • Managing, modifying, and writing Stored Procedures for the ETL processes;

  • Integrating complex data structures;

  • Data Wrangling, Data Cleaning, and Data Pre-processing. This is how you see yourself You love to puzzle, analyze, and make connections. Especially when you get the chance to work on strategically important assignments. In doing so, you combine sharp insight with technical knowledge, good communication skills, and a bit of courage. You are proactive and ask the right questions. To make this position a success, you also have:

  • At least a bachelor's/master's degree;

  • At least five years of recent experience as a DWH Engineer, Data Warehouse developer, or similar, having worked with the Microsoft BI stack;

  • At least 5 years of recent experience with SSIS;

  • At least 5 years of recent experience with SSAS Multidimensional;

  • At least 3 years of recent experience with SSAS Tabular;

  • At least 5 years of recent experience with (T-)SQL;

  • Knowledge of data models (Data Vault, Snowflake, Dimensional). Pré

  • Experience with Azure DevOps is a plus.

  • Experience with Azure DataBricks is a plus.

  • Experience with Python is a plus. What are we offering? At PwC, you will have the opportunity to be yourself, get the best out of yourself in a high-performance organisation and grow within our global network. As part of our team we offer:

  • A competitive salary, attractive pension plan and the opportunity to grow;

  • Customised training for professional growth;

  • Motivating work environment where collaboration with ambitious colleagues and recognition for your contributions are highly valued;

  • Comprehensive benefits including "well-being budget" for physical and mental health;

  • Flexibility of hybrid working, including ergonomic home office and fixed expense allowance including internet allowance;

  • Attractive mobility options, including electric lease car, car waiver allowance and the possibility of using different shared transport providers;

  • 32 vacation days per year. These are just a handful of our terms of employment. Find more information on our. Getting started at PwC Are you interested in this vacancy and do you meet the requirements? Then let us know what motivates you and fill in your details. After we've received your application,

  • You'll immediately receive confirmation in your inbox;

  • If your qualifications match the profile that we have in mind, then we'll contact you within two weeks for a short introduction meeting;

  • If everyone is enthusiastic, we'll schedule an online assessment. Depending on the result, you'll receive an invitation for an initial interview. Click for more information about the application process. Would you like more information about the position at PwC? Peter de Vries is happy to help you via email. Peter. -- #LI-PD1

Requirements

Assessment, Business Intelligence, Network, Internet, Lead, Microsoft BI, SQL, Performance, Python, SSIS, Training, Training

Benefits & conditions

At PwC, you will have the opportunity to be yourself, get the best out of yourself in a high-performance organisation and grow within our global network. As part of our team we offer:

  • A competitive salary, attractive pension plan and the opportunity to grow;
  • Customised training for professional growth;
  • Motivating work environment where collaboration with ambitious colleagues and recognition for your contributions are highly valued;
  • Comprehensive benefits including "well-being budget" for physical and mental health;
  • Flexibility of hybrid working, including ergonomic home office and fixed expense allowance including internet allowance;
  • Attractive mobility options, including electric lease car, car waiver allowance and the possibility of using different shared transport providers;
  • 32 vacation days per year.

Apply for this position