Data Engineer at Allps

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)

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.

• 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.

• 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).

• 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

• 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…