Data Warehouse and Business Intelligence Developer

Scurta descriere a companiei

Generali Romania is a member of Generali Group, one of the largest insurance providers in Europe and the biggest European Life insurer. With 85,000 employees worldwide and 70 million clients in 60 countries, the Group occupies a leadership position on Western European markets and an increasingly important place in Eastern Europe and Asia.

On the local market, Generali Romania (company resulting from the recent merger of the two insurers with a good reputation among customers, Generali and Ardaf) is a reputable insurer, respected for quality and complexity of its products. It ranks in the top 5 players of the Romanian insurance market and, moreover, benefits from one of the largest distribution networks in the country.
The company's vision on long term is to become one of the most reliable insurers and a leader on the local market.

Cerinte

Required Skills:
• Solid understanding and proven experience in ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of data warehouses, data marts, and operational data stores.
• Expert skills designing, developing, tuning, debugging and deploying SQL Server stored procedures, T-SQL.
• Experience with ETL processes and practices in data warehousing and data mart environments.
• Experience with one of the following reporting tools: MS SQL Server Reporting Services 2005/2008 (preferred), Cognos, Business Objects.

Preferred Skills:
• Experience developing and maintaining SSIS packages.
2+ years of ETL and database design, monitoring and tuning, profiling and performance optimization. Including aggregate and index design, usage and options to improve load and extract performance in Data Warehousing and BI environments.
• Comprehensive knowledge of underlying architecture of Microsoft SQL Server and SQL Server Integration Services.
• Experience with SSRS and SSAS highly desirable.
Ability to debug and solve complex problems.
Ability to manage multiple priorities, follow a project plan and meet project deliverables, working with and within cross functional Development, QA, Test and Production Teams.

Responsabilitati

Essential Functions:
• Works closely with the business and IT application owners to understand, document and design ETL processes and needs.
• Participates in the defining, development and implementation of data warehouse and data mart databases and their content.
• Develops and maintains mapping logic to move data content from varied sources systems to the data warehouse and data marts.
• ETL and data conversion design / implementation for other data integration scenarios.
• Design, Develop, Test, Optimize and Deploy SSIS packages and stored procedures to perform all ETL related functions.
• Plan and coordinate ETL and database roll-outs with project team members, development and database engineers.
• Provide support, maintenance and issue investigation and resolution for ETL processes.
• Design and implement BI technical and operational architecture / frameworks.
• End-user report development, from requirement gathering to design, build, test, deploy.