Data Analytics Engineer 80-100%

TWINT; Zürich; Hybrid; CHF 120.000 - 160.000; Vollzeit

Benefits dieser Stelle

6 weeks vacation

Flexible working hours

Work from home option

Parental leave enhancements

Team events

Central locations in Zurich & Bern

Zusammenfassung

TWINT in Switzerland is seeking a Data Analytics Engineer to design, develop, and maintain our data infrastructure to support BI and analytics initiatives.

You will work with ODI or similar ETL tools, apply Kimball dimensional modeling, build data marts, and optimize Oracle databases with SQL/PL-SQL, while collaborating with business analysts.

The role offers a hybrid work model with offices in Zurich and Bern and attractive benefits including six weeks of vacation and flexible hours.

Qualifikationen

• Degree in computer science, Information Technology, or correlated field.
• 3-5 years in a similar role; Payment industry experience is an advantage.
• Certification in Oracle data infrastructure technologies is an advantage.
• Proven experience with ETL tools (ODI or equivalent).
• Strong knowledge of Oracle databases, with SQL/PL-SQL and performance tuning.
• Experience with Kimball methodology for dimensional modeling.
• Hands-on experience in BI modeling (semantic layers, metadata, KPIs, querying).
• Data Vault methodology (enterprise data warehouse modeling and usage).
• Cloud analytics expertise (OCI & Azure analytics).
• Experience with analytics administration (installation, configuration, security, performance).
• Ability to design scalable, maintainable data solutions.
• Fluent English; German an advantage.
• Familiarity with hybrid cloud analytics solutions.

Aufgaben

• Design, implement, and maintain ETL processes.
• Apply Kimball dimensional modeling and star schema design.
• Build scalable data marts for reporting and analytics.
• Use Oracle databases with SQL/PL-SQL for data processing.
• Develop stored procedures, functions, and scripts for data integration.
• Design semantic layers in BI platforms for self-service analytics.
• Define metadata repositories and manage KPIs and business rules.
• Ensure consistency and reusability of BI objects across dashboards and reports.
• Collaborate with analysts to translate requirements into BI artifacts.
• Ensure scalability, performance, and cost efficiency of cloud analytics workloads.
• Monitor and tune cloud analytics environments for high availability.

Kenntnisse

ETL processes

Oracle databases

Data warehouse architecture

English (Fluent)

German language (advantage)

Ausbildung

Degree in Computer Science or IT

Tools

Oracle Data Integrator (ODI)

SQL

PL/SQL

Power BI

Tableau

Oracle Analytics Cloud

Jobbeschreibung

At TWINT, we believe that innovation should simplify our lives and coexistence. It should help us focus on the things that truly matter: the experiences that move us, the people close to us, and everything that brings us together. That's why we ensure that our daily lives continually become easier – because payment and everything around it gets seamlessly integrated into our lives. So that each one of us can make more out of the moment. For ourselves, for others, and for all of Switzerland.

We are seeking a skilled Data Analytics Engineer to join our team. The ideal candidate will have strong expertise in ETL processes, Oracle databases, and data warehouse architecture methodologies. You will play a key role in designing, developing, and maintaining our data infrastructure to support business intelligence and analytics initiatives.

Your impact at TWINT:

• Design, implement, and maintain ETL processes using Oracle Data Integrator (ODI) or similar tools

• Apply Kimball methodology for dimensional modeling and star schema design.

• Build scalable, user-friendly data marts to support reporting and analytics

• Utilize the data warehouse as source for flexible reporting, auditability, and reliable historical analysis across business domains.Work extensively with Oracle databases, including writing and optimizing SQL and PL/SQL code

• Develop stored procedures, functions, and scripts to support data integration and reporting needs

• Design and implement semantic layers (subject areas, dimensions, hierarchies, measures) in BI platforms, optimized for self-service analytics

• Define metadata repositories and manage calculation logic, KPIs, and business rules

• Ensure consistency and reusability of BI objects across dashboards, reports, and ad-hoc queries

• Collaborate with business analysts to translate requirements into technical BI artifacts

• Ensure scalability, performance, and cost efficiency of cloud-based analytics workloads

• Monitor and fine-tune cloud analytics environments for high availability and user satisfaction

Your Profile

• Degree in computer science, Information Technology, orrelatedfield.

• 3-5 years in a similar role. Payment industry experience is an advantage

• Certification in Oracledata infrastructuretechnologiesan advantage

• Proven experience with ETL tools (Oracle Data Integrator or equivalent)

• Strong knowledge of Oracle databases, with hands-on experience in SQL, PL/SQL, and performance tuning

• Practical experience with Kimball methodology for dimensional modeling

• Hands-on experience in BI modeling (semantic layers, metadata, KPIs, query optimization)

• Data Vault methodology (enterprise data warehouse modeling and usage)

• Cloud analytics expertise (configuring and optimizing OCI & Azure analytics instances)

• Experience with analytics administration (installation, configuration, security, performance)

• Ability to design scalable, maintainable data solutions

• Fluent English, German an advantage

• Experience with other BI tools and reporting platforms (e.g., Oracle Analytics Cloud, Power BI, Tableau)

• Oracle Analytics Cloud administration (configuration, security, performance)

• Knowledge of performance tuning and optimization in large-scale data environments

• Familiarity with hybrid cloud and advanced cloud-native analytics solution

What awaits you:

• Career and development: Shape your professional future through exciting tasks and challenges, as well as comprehensive further education opportunities in an innovative technology company.

• Work-life balance: Enjoy 6 weeks of vacation time and benefit from flexible working hours with the option to work from home.

• Balancing work and family: Benefit from additional perks such as increased family allowances and more parental leave.

• Team spirit and positive work atmosphere: Experience a collegial and healthy work culture, accompanied by regular events that strengthen collaboration.

• Fair and competitive compensation: At TWINT, we focus on a fair wage culture & fair pay. We also offer attractive additional benefits.

• Central locations: Our offices are located in the heart of Zurich and Bern and are easily accessible by public transport.