Data Warehouse Engineer

We are the Swiss Re data warehouse team and seek to extend our team with an additional Oracle Data Warehouse Engineer. He or she is responsible for the data acquisition and information exploitation, so that we as a team successfully deliver information products to our customers.

The engineer develops, inspects and tests delivered data, executes reconciliations, coordinates deployments for releases, actively increases data quality in the warehouse and consults the business system developers on data quality improvements. The new team member will become the key person for a good collaboration with the business application team.

We work in an agile DevOps setup. We emphasize team work and always strive to improve. The engineer is actively contributing to deployment & test automation.

Our Oracle Data Warehouse Engineer:
- Develops & maintains the data load workflows of our data warehouse based on Oracle 12c and Informatica Power-center.
- Uses our in-house developed code generators and deployment automations, which accelerates our time to market and release frequency.
- Develops, tests and deploys data-marts and delivery views with advanced database PL/SQL and software development skills.
- Tunes and optimizes load performance.
- Collaborates and interacts with source system developers and reporting developers.
- Builds data marts and information delivery views for customers
- Uses programming languages like Python, Java, Groovy, Bash and deployment/testing tools like Bamboo, Gradle Ansible, Puppet, Chef, Maven, Gradle to increase our level of automation
- Is delivering reliable, high quality information items as contribution to our team that delivers frequent data warehouse.

About the Team

Our data warehouse is one of several warehouses developed and operated in our Group Data Warehouse unit. The information scope of the warehouse is Group IT and serves IT Executives to in decision-making for the IT department. Do you share our real passion for high quality information products that have high exposure and wide usage?

Our team is organized as an agile DevOps team. Team collaboration, continuous feedback and people over process is our DNA. We work together on improvement activities, tool evaluations, prototyping and hackathons to which you also chip in. We together develop, extend and rewrite our tool chain to deliver more and faster value to our customers. Do you love to work in a team that always challenges itself on how to become better?

*We are required by law to disclose basic wage component (minimum salary) for the advertised positions. We carefully consider your professional competencies, qualifications and experience in our compensation package and/or when offering you other positions. Our compensation philosophy is to pay fairly, also considering market situation and the value employees may bring to Swiss Re.

We are an equal opportunity employer, and we value diversity at our company. Our aim is to live visible and invisible diversity – diversity of age, race, ethnicity, nationality, gender, gender identity, sexual orientation, religious beliefs, physical abilities, personalities and experiences – at all levels and in all functions and regions. We also collaborate in a flexible working environment, providing you with a compelling degree of autonomy to decide how, when and where to carry out your tasks.

We provide feedback to all candidates via email. If you have not heard back from us, please check your spam folder.