Bi Architect

col-wideJob Description:Description¿Who are we?We are Aratech, a consulting technology consulting firm, born 10 years ago to provide efficient solutions to our clients. Within our business lines we help our partners to find the best talent for their work teams.¿Who's our partner?A leading European company, that offers investors in everything related to the real state and structural sector with a focus on the green factor. Currently, they are looking for a BI Architect (w/m/d) to j oin them in their journey towards digital HR transformation.¿What do they offer you?A growing team in a Start-up environment 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 goalsAn academy membership with a wide range of advanced education and training offersAttractive career opportunities in a Partner-led company**Requirements**:¿What your tasks would be?Analyse and design of our Business Intelligence and data warehouse structure (DWH)Support 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 data¿What do we need?Completed studies in the field of Computer Science, Information Technology or similarMinimum 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 fixingProactive, strong entrepreneurial attitude and passion for dataAble to work independently and under pressureFluent in written and spoken English, Spanish and German are an advantageWilling to travel internationally and nationally by car and plane DON'T DOUBT TO SEND YOUR APPLICATION