Loading...
Share this Job
Location: 

Bratislava, SK

Data Warehouse Engineer

 


About Swiss Re
 

Swiss Re is one of the world’s leading providers of reinsurance, insurance and other forms of insurance-based risk transfer, working to make the world more resilient. We anticipate and manage a wide variety of risks, from natural catastrophes and climate change to cybercrime.

At Swiss Re we combine experience with creative thinking and cutting-edge expertise to create new opportunities and solutions for our clients. This is possible thanks to the collaboration of more than 13,000 employees across the world.

We offer a flexible working environment where curious and adaptable people thrive. Are you interested in joining us?

 

About the Role

 

We are the Swiss Re data warehouse team and seek to extend our team with an additional 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 Data Warehouse Engineer:

  • Strong database knowledge of leading database like Oracle, MS SQL Server
  • 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.
  • Optimizes data load performance and work on SQL performance tuning
  • 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 and deployment/testing tools like AzureDevOps, Bamboo, 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?

 

About You 

  • You hold a bachelors or master's degree in a technical field, preferably Information Technology or you have experience in the area of data warehousing or database development in your previous jobs.
  • You have a minimum 2-4 year experience with Data Warehouses on leading database(s) and you have built load processes or used ETL tools like Informatica Power Center or Azure Data Factory.
  • You have proven knowledge of relational databases (Oracle, Microsoft SQL Server) and database development tools like Toad for Oracle, SQLPlus, Sybase Power Designer, PL/SQL. T-SQL).
  • You are experienced with software development tool chains like Source Control (GitHub), Continuous Integration (Bamboo), Testing (Groovy), Build Tools (AzureDevOps).
  • You love working with data and information. You have strong analytical skill, you have an eye for detail and you can work with complex data constellations.
  • You enjoy to identify issues, offer a workaround and implement a problem resolutions to satisfy a customers concern.
  • You are a great teammate, a good communicator and you love collaborating within the team and various other teams spread around the globe.
  • You are proficient in English. Speaking German is a plus.

     

Minimum base salary for this job is from 1700 EUR gross/month/full time. Our offer to you may be higher based on your skills and experience and will include additional rewards and benefits. *

 

*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.


Keywords:  
Reference Code: 100307