DescriptionDrees & 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.All the services provided by the partner-run company take into consideration both economic and ecological concerns.Why work with Drees & Sommer? A growing team with the backing of a large international group and an ambitious visionA work environment that enthusiastically embraces and supports innovative ideas and sustainable practicesThe opportunity to assume responsibility right from the start according to our 'encouraged to take-action' policyExciting and varied tasks providing support for our teams and experts across all locations, achieving shared goalsThe Drees & Sommer Academy with its wide range of advanced education and training offersAttractive career opportunities in a Partner-led companyWhat You'll Do Analyze and design our Business Intelligence and data warehouse structureSupport and maintenance of the existing BI environmentDevelop ETL mapping and logicCreate jobs for batch and real-time processing of data from internal and external sourcesDevelop complex SQL queries and database objects (stored procs, views, etc) to pull and manage dataDevelop complex SSIS packages to move and translate dataQualifications 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 plusStrong Data analysis and data migration script creation skills as well as experience with data conversion, transformation, and query optimizationsProficient in system analysis, debugging, and defect fixingFluent in written and spoken English, Spanish and German is an advantageWilling to travel internationally and nationally#J-18808-Ljbffr