Data Warehouse Engineer - Designer / Developer

Job description / Role

Data Warehouse Engineer - Designer / Developer - AZURE - SQL - PYTHON

New and exclusive to eMagine Solutions we are working with a global company who are embarking on a Digital and Data Transformation program. As such they have recently created a MS Azure Date Warehouses and Data Lake, implementing Big Data. Due to the growth of the project we are now hiring for a DW Engineer to lead the Design, Development and Implementation of new a Data Warehouse environment and the creation of a Data Lake in order to administer a Big Data environment. This will be a senior role and you will be expected to act as an authority and present to senior management (CTO, CIO, Head of Data, Head of Digital) your ideas and proposals. You will also be expected to guide and mentor junior team members.

Requirements

As such we are looking for you to have completed end-to-end Data Warehouse Design and Implementations, ideally using Dimension Modelling / Kimball methodology (bottom-up approach whereby data marts are first created to provide reporting and analytical capabilities for specific business\functional processes and later on these data marts can eventually be unioned together to create a comprehensive enterprise data warehouse) emphasizing the value of the data warehouse to the users as quickly as possible. Although Top Down Design can also be considered. The ideal candidate will have experience with OLTP tables and then modelled a DWH implementation from those tables and thereafter managed the different data marts feeding from that DWH with multiple fact tables. You should also have good Microsoft Tech stack experience with SQL, Azure, Power BI and DAX. Some scripting knowledge is a must and our preference here is Python.

About the Company

eMagine Solutions is one of the leading authorities on leadership and talent globally. Our combined resources of over 100 years professional experience mean that our clients trust us with finding them the top talent globally and candidates trust us to find them the right opportunity in a timely and confidential manner.

Throughout our offices we provide complete solutions for our clients, including traditional temporary and permanent recruitment, executive search, recruitment process outsourcing (RPO), salary survey's, market mapping and training and development courses.

Our global client list work with us not only because of our expertise but also because of our honesty, integrity and passion.