This is us
At Avenga, we believe that human creativity empowers technology that matters. Operating globally, our 6000+ specialists provide a full spectrum of services, including business and tech advisory, enterprise solutions, CX, UX and Ul design, managed services, product development, and software development.
This is you
- Minimum of 5 years of experience as a Data Engineer or related position, in a Microsoft SQL Server environment
- Very good knowledge of SQL Server, including query optimization and data warehouse design
- Practical experience in building and maintaining ETL processes using SSIS
- Experience in designing and maintaining OLAP cubes in SSAS, including knowledge of MDX language
- Ability to analyze business requirements and translate them into technical solutions
- Self-motivated, accurate and proactive in solving technical problems
- Ability to work in a team and communicate
Nice-to-have skills :
Experience in optimizing SQL routines for performanceExperience integrating data from Hyperion Financial Management class systemsThis is your role
Development and optimization of more than 20 databases - structure design, advanced queries, stored procedures with emphasis on performance and data integrityPerformance optimization of existing solutionsManagement and development of more than 400 ETL packages - integration of financial data and from external sources. SSAS OLAP :Development and maintenance of more than a dozen analytical cubes - aggregation design, partitioning, implementation of business logic in MDXCreation of new KPIsCreation and updating of technical documentation of implemented solutions.Supporting budgeting and forecasting processes.W e take pride in the diverse skills and character of our teams, welcoming everyone to apply and contribute to our collective strength .