Business Intelligence (BI / DWH) Architect

Company Description Creating a future worth living for future generations gets us out of bed every morning. Depending on the project, we are consultants, implementers, or both for sustainable, innovative and economical solutions for real estate, industry, energy and infrastructure. Our more than 6,000 employees at 63 locations worldwide support our customers in interdisciplinary teams. Our thinking is both visionary and realistic. We work independently and as part of a team. With passion and the latest technologies. We unite. Join us at Dreso and let’s create a world we want to live in.

Job Description You will be part of a growing and diverse team that challenges itself to provide innovative cloud-based solutions in high-profile, multifaceted projects. Working alongside excellent colleagues from around the company and across the globe, Drees & Sommer is an environment where you and your career can flourish.

Want to work with business leaders, and alongside some of the most creative thinkers in industry? Can you develop and deliver innovative and core technology solutions that transform the way of working and maximize return on investment?

Drees and Sommer is expanding in Malaga. With us, you will become an important part of a fast-growing company and have plenty of exposure to learn and work on multiple products, with multiple technologies. Flexibility and productivity are embraced in our dynamic workplace because we focus on people centricity in enhancing the overall employee experience.

Your Tasks Analyse and design of our Business Intelligence and Data Warehouse (DWH) structure

Support and maintenance of the existing BI environment

Develop ETL mapping and logic

Create jobs for batch and real time processing of data from internal and external sources

Develop complex SQL queries and database objects (stored procs, views, etc) to pull and manage data

Develop complex SSIS packages to move and translate data

Interface with other teams and departments to develop new and modify existing reporting applications

Qualifications Completed studies in the field of Computer Science, Information Technology or similar

Minimum of 4 years of experience in SSIS, Power BI, ETL & SQL Development, Microsoft SQL Server+, experience with NoSQL databases is a plus

Strong Data analysis and data migration script creation skills as well as experience with data conversion, transformation and query optimizations

Proficient in system analysis, debugging and defect fixing

Proactive, strong entrepreneurial attitude and passion for data

Able to work independently and under pressure

Fluent in written and spoken English, Spanish and German are an advantage

Willing to travel internationally and nationally by car and plane

Additional Information To ensure your work-life balance, we offer the option of mobile working

We promote your professional and personal development through individual training and further education at the Drees & Sommer Academy

We support your health with a bonus for sports enthusiasts. We offer the possibility of subscribing to a private health insurance policy

Employees benefit from tax advantages related to their commuting expenses for the office

Fiscal advantages for employees expenses in meal costs during the worktime. Employee referral program with attractive bonus scheme

Supporting career and familiy by receiving tax benefits for kindergarten expenses

#J-18808-Ljbffr