Business Intelligence (BI / DWH) Architect

Drees & Sommer España; Málaga; Presencial; EUR 40.000 - 55.000; Jornada completa

Descripción de la vacante

A leading consultancy firm in Málaga is seeking a Business Intelligence Developer to join their growing team. The successful candidate will be responsible for designing and maintaining BI structures, developing ETL processes, and creating complex SQL queries. Candidates should have a degree in Computer Science or similar and at least 4 years of experience in relevant technologies. This role offers flexible working and opportunities for professional development.

Servicios

Mobile working option

Individual training and professional development

Health insurance bonus

Tax advantages for commuting expenses

Fiscal benefits for meal costs

Tax benefits for kindergarten expenses

Formación

• At least 4 years of experience in SSIS, Power BI, ETL & SQL Development.
• Experience with NoSQL databases is a plus.
• Proficient in debugging and defect fixing.

Responsabilidades

• Analyse and design of 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.
• Interface with other teams to develop new reporting applications.

Conocimientos

SSIS

Power BI

ETL Development

SQL Development

Data analysis

Data migration script creation

System analysis

Fluent English

Educación

Completed studies in Computer Science or Information Technology

Herramientas

Microsoft SQL Server

Descripción del empleo

Company Description

Creating a future worth living for future generations gets us out of bed every morning. Depending on the project, we are consultants, implementers, or both for sustainable, innovative and economical solutions for real estate, industry, energy and infrastructure. Our more than 6,000 employees at 63 locations worldwide support our customers in interdisciplinary teams. Our thinking is both visionary and realistic. We work independently and as part of a team. With passion and the latest technologies. We unite. Join us at Dreso and let’s create a world we want to live in.

Job Description

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.

Want to work with business leaders, and alongside some of the most creative thinkers in industry? Can you develop and deliver innovative and core technology solutions that transform the way of working and maximize return on investment?

Drees and Sommer is expanding in Malaga. With us, you will become an important part of a fast-growing company and have plenty of exposure to learn and work on multiple products, with multiple technologies. Flexibility and productivity are embraced in our dynamic workplace because we focus on people centricity in enhancing the overall employee experience.

Your Tasks

• Analyse and design of our Business Intelligence and Data Warehouse (DWH) 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
• Interface with other teams and departments to develop new and modify existing reporting applications

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
• 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

Additional Information

• To ensure your work-life balance, we offer the option of mobile working
• We promote your professional and personal development through individual training and further education at the Drees & Sommer Academy
• We support your health with a bonus for sports enthusiasts. We offer the possibility of subscribing to a private health insurance policy
• Employees benefit from tax advantages related to their commuting expenses for the office
• Fiscal advantages for employees expenses in meal costs during the worktime. Employee referral program with attractive bonus scheme
• Supporting career and familiy by receiving tax benefits for kindergarten expenses