What it's about
The Business Applications Group is closely aligned with the business teams and responsible for the key applications to administer, monitor and analyse Partners Group’s business processes through the investment value chain. We take care of the availability, development, customization and on-going enhancement of these applications to best support the global business operations of Partners Group.
We are now looking to add a Data Engineer to our team, based in Zug.
You will have the following responsibilities:
Design
1. Analyse relevant internally and externally sourced data (raw data) to generate BI and Advanced Analytics datasets based on your stakeholders’ requirements
2. Design data pipelines to curate sourced data into the inhouse data warehouse
3. Design data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholders
4. Design data model changes that align with the inhouse data warehouse standards
5. Define migration execution activities to move data from existing database solutions to the inhouse data warehouse
Engineer
6. Regular housekeeping of raw data and data stored in the inhouse data warehouse
7. Build and maintenance of data pipelines and data platforms
8. Build data solution prototypes
9. Explore ways to enhance data quality and reliability
10. Identify and realize opportunities to acquire better data (raw data)
11. Develop analytical tooling to better support BI and Advanced Data Analytics activities
12. Execute data migration from existing databases to the inhouse data warehouse
13. Promote and champion data engineering standards and best-in-class methodology
.newspaper { h1 { font-size: 250%; font-family: Lato;} h2 { font-size: 200%;} p { font-size: 100%;} What we expect
You will have the following qualifications:
14. Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline
15. 4+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry
16. Strong understanding or practical experience of at least one common Enterprise Agile Framework e.g., Kanban, SAFe, SCRUM, etc.
17. Strong understanding of ETL, data warehouse and BI and Advanced Data Analytics concepts
18. Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.
19. Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQL
20. Strong programming skills with advanced knowledge of Java and/or Python
21. Experience in building data models, which includes the conceptual, logical, and physical and practical experience using DataVault 2.0
22. Practical experience with ETL tools such as Talend, etc.
23. Strong critical-thinking, analytical and problem-solving skills
24. Excellent communicator with team-oriented approach
Desired:
25. Working knowledge of big data concepts in organizing both structured and unstructured data
26. Certified in AWS Data Analytics Specialty/AWS Machine Learning Specialty
27. Knowledge about private markets
What we offer
Partners Group is a global financial institution that retains the culture, pace and agility of a start-up. As a growing firm, we are committed to attracting, developing and retaining the very best talent, by offering a workplace where results are truly recognized and rewarded.
We offer a fantastic opportunity for you to grow:
28. Professional, international working environment
29. Challenging, rewarding career within a growing company
30. Collaborative environment, with on-the-job training and mentorship opportunities
31. Competitive compensation package, including performance based annual bonus
32. Lunch allowance
33. 25 vacation days
34. One-month fully paid sabbatical after every five years of employment