Business Intelligence

Countrywide Spain | Experienced professional | Full-time

Business Intelligence (BI / DWH) Architect

Drees & Sommer is your innovative partner for consulting, planning, construction, and operation. As the leading European consulting, planning, and project management enterprise, Drees & Sommer has supported private and public clients and investors for over years in all aspects of real estate and infrastructure – both analog and digital. Through future-oriented consulting, the enterprise can offer solutions for successful buildings, profitable real estate portfolios, people-oriented working environments, and visionary mobility concepts. The company's with over 6, employees in locations around the world work in interdisciplinary teams to provide support for clients from a wide variety of sectors. All the services provided by us take into consideration both economic and ecological concerns.

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.

If you are eager to learn, contribute relentlessly, and want more responsibility, come, and join us. We want talented people like you to help lead the transformation. We are excited to see your applications. Come and join Drees & Sommer where You Decide

Responsibilities :

• Analyse and design our Business Intelligence and Data Warehouse (DWH) structure
• Support and maintain 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

Your profile

• 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

We offer

• A growing team in a Start-up environment with the backing of a large international group and an ambitious vision
• A work environment that enthusiastically embraces and supports innovative ideas and sustainable practices
• The opportunity to assume responsibility right from the start according to our 'encouraged to take-action' policy
• Exciting and varied tasks providing support for our teams and experts across all locations, achieving shared goals
• The Drees & Sommer Academy with its wide range of advanced education and training offers
• Attractive career opportunities in a Partner-led company

Drees & Sommer is an innovative consultancy, planning, building and management partner.

As a leading European consultancy, planning, building and management company, we help constructors and investors with all aspects of property and infrastructure – offering both analogue and digital support. Drees & Sommer offers cutting-edge consultancy for successful building projects, profitable portfolios, efficient infrastructure and liveable cities.

YOU DECIDE

Prospective employees choose Drees & Sommer for our strength in innovation, digitization, sustainability and profitability. This combination of strengths is what gives Drees & Sommer an edge. When you work for us, you get the opportunity to work on successful and cutting-edge projects and make a real impact.

The blue way : where reason meets emotion

Our employees work in interdisciplinary teams, globally, supporting clients operating in a diverse range of sectors. We are sustainable and holistic in how we think and what we do. Bringing a holistic approach to sustainability means that economics, ecology and functionality are inseparable for us. At Drees & Sommer, we call this holistic approach "the blue way". Balancing reason and emotion, it shapes the entire way our company operates, both internally and externally.

You can find out what we stand for and what we deliver to our clients here.

J-18808-Ljbffr

#J-18808-Ljbffr

---