Data Engineer at Allps

Allps GmbH; Basel; Vor Ort; CHF 120.000 - 180.000; Vollzeit

Benefits dieser Stelle

Remote work environment

Career growth and learning

Competitive compensation

Zusammenfassung

ALLPS is seeking an experienced Data Engineer to design, build, and optimize an enterprise-wide data platform in Basel on a 3-year contract. You will break down data silos and construct scalable ETL/ELT pipelines to deliver clean, structured data for BI, analytics, and AI initiatives.

You will architect end-to-end data ingestion channels, implement scalable data lakes and data warehouses, enforce governance with RBAC, and map metadata while ensuring data quality and security across the

Qualifikationen

• 3–5+ years of hands-on data engineering experience.
• Experience building enterprise data platforms and ETL/ELT pipelines.
• Fluent German communication in business context (C1/C2) and collaboration with multilingual teams.

Aufgaben

• Architect ingestion pipelines and real-time streaming jobs.
• Scale data lakes and centralized data warehouses (Delta Lake/house).
• Enforce data governance, RBAC, and data quality validation gates.
• Maintain data lineage, metadata mappings, and dictionary schemas.
• Provide automated monitoring and security scanning for data flows.

Kenntnisse

ETL pipelines

Data architecture

RBAC

Data governance

Tools

SQL Server

Delta Lake

ETL tooling

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.

The AI screening interview may include:

• Questions about your professional background and relevant experience


• Role-specific technical or functional questions


• Questions about your motivation, availability, and communication skills

The interview can usually be completed online in 15-20 minutes at a time that is convenient for you. Your responses will be reviewed as part of the overall selection process, together with your CV, application details, and any follow-up interviews with the hiring team.

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.

About Allps

Who We Are : ALLPS is a Switzerland-based technology and AI company focused on building high-quality remote IT teams and AI-powered hiring solutions for global enterprises. Founded in 2017 and headquartered in Zurich, the company operates across Europe, India, and international markets, helping organizations accelerate digital transformation through talent, software, and AI solutions.

What to Expect : After an initial application review, shortlisted candidates go through an AI-powered video screening to assess communication skills, relevant experience, business judgment, and role-specific expertise. Selected candidates then participate in discussions with the HR and functional teams, followed by a technical or leadership round focused on practical problem-solving, collaboration, and alignment with our fast-paced technology-driven culture. We value clear communication throughout the process and aim to provide candidates with a smooth, professional, and engaging hiring experience from application to onboarding.

Why you will love it here : We are building the future of AI-powered hiring and remote technology teams. Our culture combines innovation, ownership, collaboration, and continuous learning in a fast-moving global environment.We believe in empowering people with the freedom to innovate, contribute ideas, and work on impactful projects that shape the future of recruitment and AI technology. Our teams work across international markets, collaborating closely with clients, engineers, product teams, and AI specialists.Benefits & PerksCompetitive compensation packageRemote work environmentExposure to international clients and projectsOpportunity to work with emerging AI technologies and enterprise SaaS platformsCareer growth and learning opportunitiesHigh-impact roles with ownership and decision-making exposureCollaborative and inclusive team cultureWork-life balance with flexible and outcome-driven environmentOpportunity to contribute directly to product innovation and company growth

Before you start

This takes about 5 minutes to complete.

Application Matching

We match your CV and responses to the role using AI-assisted technology.

Video Screening

Some roles include a short AI-assisted video screening interview. You can complete it right after applying or within the time frame in your confirmation email.

A recruiter or hiring team member reviews every application and video interview — AI supports the process but never makes the final decision.

Good To Have Skills

Postgre SQL Mongo DB AZURE DEVOPS TERRAFORM