Data Engineer

ALLPS; Basel; Vor Ort; CHF 70.000 - 90.000; Vollzeit

Benefits dieser Stelle

Professional development opportunities

Collaborative work environment

Competitive salary and benefits package

Zusammenfassung

Join ALLPS in Basel as a Data Engineer for a 3-year contract role, supporting a major enterprise project. You will design, build, and optimize data platforms while ensuring clean and reliable data streams.

Candidates should have 3+ years of experience with Microsoft SQL Server and a strong command of German. The role offers a collaborative work environment and opportunities for professional growth.

Qualifikationen

• 3 to 5+ years of experience in Microsoft SQL Server database administration or engineering.
• Strong knowledge in data modelling and relational database design principles.
• Experience in high-availability and disaster recovery solutions.

Aufgaben

• Design and optimize ETL/ELT pipelines for operational data.
• Create scalable corporate Data Lakes and Enterprise Data Warehouses.
• Establish data governance and access enforcement standards.

Kenntnisse

Microsoft SQL Server

Database administration

ETL/ELT pipelines

Data modelling

Database security

German language proficiency (C1/C2)

Jobbeschreibung

Location: Basel, Switzerland

Contract Duration: 3 years, with possible extension

Experience Required: 3+ years.

Industry Experience: Utilities & Energy (Energie & Wasserversorgung) or Telecommunications or Banking & Financial Services or Information Technology & Services

Role Overview

We are looking for an experienced Data Engineer to support a long-term enterprise project in Basel. This is a 3-year contract role with the possibility of extension.

We are seeking a senior-tier Data Engineer to design, build, and optimize our enterprise-wide data platform. In this role, you will be responsible for breaking down operational data silos and constructing scalable, low-latency ETL/ELT pipelines. Your mission is to establish a unified data architecture that delivers clean, highly structured, and reliable data streams for downstream business intelligence, advanced analytics, and AI initiatives.

Strategic Scope: Architects, deploys, and operates end-to-end automated data ingestion channels, distributed big data pipelines, enterprise analytics platforms, and central repository frameworks.

Core Responsibilities

• Pipeline Ingestion Architecture: Analyze raw structured and unstructured source data formats to construct resilient automated ETL/ELT pipelines and real-time streaming ingestion jobs.
• Analytical Platform Scaling: Design, scale, and optimize scalable corporate Data Lakes, centralized Enterprise Data Warehouses, and modern Delta Lakehouse architectures.
• Governance & Access Enforcements: Enforce data classification standards, programmatic object masking, multi-level role-based access control (RBAC), and automated data quality validation gates.
• Lineage & Metadata Mapping: Author, trace, and maintain technical data dictionary mappings, schema evolution profiles, and unified end-to-end data lineage tracking catalogs.
• Automation Pipeline Infrastructure: Provision and manage isolated environments using code-driven versioning templates, integrating automated monitoring and security scanning for data flows.

Required Skills & Experience

• Minimum of 3 to 5+ years of hands‑on experience in Microsoft SQL Server database administration, database engineering, or enterprise database architecture.
• Strong experience with SQL Server platform sizing, deployment modelling, resource planning, memory configuration, storage design and performance-oriented database setup.
• Good knowledge of data modelling, schema design, indexing strategies, constraints, data types, partitioning and relational database design principles.
• Experience designing, implementing and maintaining high‑availability and disaster recovery solutions, including failover, mirroring, replication, backup/restore strategies and DR runbooks.
• Strong performance tuning experience, including execution plan analysis, stored procedure optimisation, deadlock resolution, nested view tuning and complex query optimisation.
• Experience planning and executing database migrations, version upgrades, schema changes, patch deployments and production releases with minimal downtime.
• Ability to advise software development teams on database design, query performance, data integrity and scalable application-database interaction patterns.
• Good understanding of database security, access control, operational monitoring, incident troubleshooting and enterprise change management practices.
• Ability to work independently as well as part of a distributed project team.
• Languages: Flawless bilingual/native-level business German communications proficiency (C1/C2 level written and spoken) is required. The candidate must present seamlessly in German during the technical panel interview (Anbieterfachgespräch).
• Swiss Compliance: Must hold EU/EFTA nationality or possess an active, valid Swiss permanent residency/work card (C Permit or unrestricted B/G Permit).
• What We Offer:
  • Opportunity to work on challenging projects and contribute to the growth of our company
  • Collaborative and dynamic work environment
  • Professional development and growth opportunities
  • Competitive salary and benefits package

Recruitment Process – AI Screening with TARA

• As part of our recruitment process, candidates may be invited to complete an initial AI-powered screening with TARA, the ALLPS.AI interview agent.
• TARA helps us make the hiring process faster, fairer, and more consistent by asking structured, role-relevant questions based on the job requirements. The interview is designed to understand your experience, skills, motivation, and suitability for the role.

Candidate Experience

• We use AI to support the recruitment process, but final hiring decisions are made by people. Human recruiters and hiring managers remain involved in reviewing candidates and making selection decisions.
• We are committed to a transparent, respectful, and fair candidate experience. Your data will be handled confidentially and in accordance with applicable data protection requirements.

If you are a motivated and experienced Data Engineer looking for a new challenge, please submit your application, including your resume and a cover letter, to our website. We look forward to hearing from you.