Data Analytics Engineer — ETL/Oracle DW, Remote

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

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.