Business Intelligence (BI/ DWH) Architect, null

Social network you want to login/join with:

Business Intelligence (BI/ DWH) Architect

Client: Drees & Sommer

Location: Spain

Job Category: Other

EU work permit required: Yes

Job Views: 4

Posted: 06.03.2025

Expiry Date: 20.04.2025

Job Description:

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.

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!

Your tasks

1. Analyse and design of our Business Intelligence and Data Warehouse(DWH) structure
2. Support and maintenance of the existing BI environment
3. Develop ETL mapping and logic
4. Create jobs for batch and real time processing of data from internal and external sources
5. Develop complex SQL queries and database objects (stored procs, views, etc) to pull and manage data
6. Develop complex SSIS packages to move and translate data
7. Interface with other teams and departments to develop new and modify existing reporting applications

Your profile

1. Completed studies in the field of Computer Science, Information Technology or similar
2. Minimum of 4 years of experience in SSIS, Power BI, ETL & SQL Development, Microsoft SQL Server+, experience with NoSQL databases is a plus
3. Strong Data analysis and data migration script creation skills as well as experience with data conversion, transformation and query optimizations
4. Proficient in system analysis, debugging and defect fixing
5. Proactive, strong entrepreneurial attitude and passion for data
6. Able to work independently and under pressure
7. Fluent in written and spoken English, Spanish and German are an advantage
8. Willing to travel internationally and nationally by car and plane

We offer

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