Data Analytics Engineer 80-100%

TWINT; Bern; Hybrid; CHF 110.000 - 160.000; Vollzeit

Benefits dieser Stelle

6 weeks vacation

Work from home option

Flexible working hours

Family allowances

Parental leave

Team events

Central locations in Zurich and Bern

Zusammenfassung

TWINT in Switzerland seeks a Data Analytics Engineer to design, build, and maintain data pipelines and the data warehouse to support BI and analytics initiatives.

You will work with ODI, Oracle databases, Kimball modeling, and cloud analytics (OCI & Azure), delivering scalable data marts and semantic layers for self-service reporting while ensuring performance and cost efficiency.

Qualifikationen

• Degree in computer science, information technology, or related field.
• 3–5 years in a similar role; payment industry experience is an advantage
• Certification in Oracle data infrastructure technologies an advantage
• Proven experience with ETL tools (ODI or equivalent)
• Strong knowledge of Oracle databases, with hands-on SQL and PL/SQL
• Practical experience with Kimball for dimensional modeling
• Hands-on BI modeling (semantic layers, metadata, KPIs, query optimization)
• Data Vault methodology (enterprise data warehouse modeling)
• Cloud analytics expertise (OCI & Azure)
• Experience with analytics administration (installation, configuration, security, performance)
• Ability to design scalable, maintainable data solutions
• Fluent English, German an advantage
• Experience with Oracle Analytics Cloud, Power BI, Tableau
• Oracle Analytics Cloud administration (configuration, security, performance)
• Knowledge of performance tuning in large-scale data environments
• Familiarity with hybrid cloud and advanced cloud-native analytics solution

Aufgaben

• Design, implement, and maintain ETL processes using ODI or similar tools
• Apply Kimball dimensional modeling and star schema design
• Build scalable data marts to support reporting and analytics
• Develop semantic layers in BI platforms for self-service analytics
• Collaborate with analysts to translate requirements into BI artifacts

Kenntnisse

ETL processes

Oracle databases

ODI

Dimensional modeling

Star schema design

Data marts

SQL

PL/SQL

Kimball methodology

BI modeling

Data Vault

Cloud analytics

OCI & Azure

Analytics tooling

German language

English fluency

Ausbildung

Bachelor's degree in Computer Science or IT

Tools

ODI (Oracle Data Integrator)

Oracle Analytics Cloud

Power BI

Tableau

Oracle databases

SQL/PLSQL

OCI/Azure

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.