Práca SME SME.sk
Pridať inzerát

Data Warehouse Engineer

Swiss Re

Information about the position

  • Place of work: Mlynské nivy 12, Bratislava
  • Basic wage component (gross) and other rewards: From 1 700 EUR/monthMinimum 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. *
  • Contract type: full-time

Job description, responsibilities and duties

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?

Information about the selection process

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

Requirements for the employee

Candidates with education suit the position

University education (Bachelor's degree)
University education (Master's degree)
Postgraduate (Doctorate)

Language skills

English - Upper intermediate (B2)

Number of years of experience

0

Personality requirements and skills

- 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 Oracle Data Warehouses and you have built load processes or used ETL tools like Informatica Power Center, Kettle/Pentaho.
- 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).
- You are experienced with software development tool chains like Source Control (GitHub, SVN, TFS), Continuous Integration (Jenkins, Bamboo), Testing (DBUnit, JUnit), Build Tools (Gradle, Ansible, Maven).
- 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.

Advertiser

Brief description of the company

As the world's leading and most diversified global reinsurer, we offer as our core business financial services products that enable risk taking essential to enterprise and progress. Our company was founded in Zurich, Switzerland in 1863, and operates in more than 25 countries and provides its expertise and services to clients throughout the world. We combine financial strengths with experience, knowledge and creative thought to explore new opportunities in the interests of our clients, staff and shareholders.

Number of employees

1000 and more employees

Company address

Swiss Re Business Services (Slovakia) s.r.o.
Mlynske Nivy 12
821 08 Bratislava