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