Description Drees & Sommer - The leading European consulting, planning, and project management enterprise, supports private and public clients and investors for 50 years in all aspects of real estate and infrastructure - both analog and digital.
The result is cost-effective and sustainable buildings, profitable real estate portfolios, people-oriented working environments, and visionary mobility concepts.
The company's more than 4,000 employees in 46 locations around the world work in interdisciplinary teams to provide support for clients from a wide variety of sectors.
Why work with Drees & Sommer?
- A growing team 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 What You'll Do - Analyze and design our Business Intelligence and data warehouse 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 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 - Fluent in written and spoken English, Spanish and German is an advantage - Willing to travel internationally and nationally #J-18808-Ljbffr