Data Warehouse Developer (m/f) in GDWH

Job description

JOB PURPOSE/ROLE

As a member of the Data Warehouse product development team in Global BI and Big Data, you will leverage your Data Warehousing (DW) experience and expertise to support the development of shared solutions to the Allianz entities worldwide. Duties include: DW development and testing; partner with our nearshore and offshore development teams; authoring technical, user and operations documentation; actively communicating and interact with different stakeholders, namely business analysts, architecture, data security authority, platform engineering, operations teams, feeding systems teams and external like SW Vendors; and perform other tasks as assigned.

KEY RESPONSIBILITIES

Develop ETL software using PL/SQL, SQL and SAS for DW and other solutions that require data provision

Work with the product owner and business analysts to fully understand the business requirements and assure that the project deliverables are fulfilling these

Commit as a team member to a self-organized team managed in SCRUM

Prepare test cases and strategies for unit testing, system and integration testing

Perform code reviews to identify basic technical and logical errors

Besides regular product development, address any vulnerability, deviation or breached identified after release

Further responsibilities

Participate, as a product consultant, in customer implementation projects

Follow the software development processes that are in place like version management, build and deployment management

Actively drive standardization and optimization of software development

Collaborate with and leverage new colleagues and near-offshore development teams

Develop best practices to improve productivity and utilize programming principles, tools, and techniques to write solution codes

KEY REQUIREMENTS/SKILLS/EXPERIENCE

Academic background

Bachelor’s degree in Computer Science or related quantitative field

1 to 3 years’ experience in Data Warehouse in an enterprise environment

Knowledge of SQL, PL/SQL and one or many ETL tools

Work experience with enterprise databases as a developer (Oracle preferable)

Demonstrated experience with software development life cycle methodologies, including agile

Worked in environments that demand fast paced effective delivery under tight timeline/budget

Skills and Competencies
Personal skills

Self-driven with an ability to work closely with business analysts and development team to work towards quality product rollout

Strong analytical, organizational and problem solving skills

Effective at managing multiple issues with conflicting priorities under tight deadlines

High energy, innovative individual who is motivated by challenging assignments

Comfortable working independently, but has experience working in a team environment

Excellent communication skills, interpersonal, oral, and written

Insurance or Finance Industry experience preferred

Very good command of English language

Desired requirements /skills /experience

Experience in SAS Enterprise Data Management suite and SAS programming/macros

Change data capture and real-time replication/real-time ETL (Attunity, DataGuard, GoldenGate, Oracle Data Integrator (ODI))

Use of Web Services for data exchange (SOAP, XML)

Experience in at least one reporting/OLAP tool such as Microstrategy, SAS Visual Analytics, Cognos, Business Objects

Understanding and interest in Hadoop and “non-classic” DW/BI approaches

Strong aptitude and desire to learn new technologies and tools

German language skills

ADDITIONAL INFORMATION

Documents required for complete application: CV, Cover letter for the Job, References, Diploma, Transcript of records.

Reference Code

AMOS-4345860-4

Allianz is the home for those who dare – a supportive place where you can take the initiative to grow and to actively strengthen our global leadership position. By truly caring about people – both its 85 million private and corporate customers and more than 142,000 employees – Allianz fosters a culture where its employees are empowered to collaborate, perform, embrace trends and challenge the industry. Our main ambition is to be our customers’ trusted partner, instilling them with the confidence to grow. If you dare, join us at Allianz Group.

At the core of the Group’s strength lies digitalization and its promise of growth opportunities through a ‘digital by default’ strategy. Allianz Managed Operations & Services (AMOS) is the principal driver behind transforming Allianz into a digital group – a quest to which nearly 7,500 AMOS employees around the globe have committed themselves. AMOS equips the Group with the most cutting edge digital solutions in the industry, bringing Allianz to the fingertips of its customers. At AMOS, innovation is more than a buzzword; it is the business of the day, every day.

We are interested in your strengths and experience. This means that we welcome all applications, irrespective of other characteristics such as gender, ethnic background, origin or any disability.